Apply on Employer Site

Oregon Department of Justice · 1 day ago

Senior Data Analyst (Information Systems Specialist 7)

Salem, OR

Full-time

Hybrid

Senior Level

$6,679/mo - $10,092/mo

6+ years exp

The Oregon Department of Justice is seeking to hire an experienced Senior Data Analyst to serve on its Legal Tools Program team. This role involves providing data analysis, reporting, expertise, and technical support for DOJ managed data, ensuring the Legal Tools Program meets the unique needs of the Department of Justice.

GovernmentLaw EnforcementNon Profit

Responsibilities

Analyze data stored across multiple relational databases for trends, patterns, and data quality issues including completeness, consistency, uniqueness, and integrity using data analysis tools (Power BI and SSMS), database query languages (T-SQL), and manual assessments

Plan and implement data inventories, catalogs, information analysis, modeling, and data quality testing in collaboration with DOJ staff and vendor resources

Design, develop, test, and deploy impactful reports, dashboards and visualizations that effectively communicate key insights regarding data migration, data governance, and business process decision making

Evaluate potential information management designs and solutions, and their capabilities in conjunction with the Legal Tools Digital Information and Records Manager, Principal Solutions Architect, and Data Architect to ensure that they meet DOJ’s data governance and compliance requirements and technology standards

Verify and validate the quality of migrated data against source systems, data models, and standards

Contribute to the development of data governance policies, standards, procedures, and guidelines

Maintain knowledge of current and emerging data analysis and management practices, technologies and innovations through training, blogs, professional journals and publications, contact with other IT and security professionals, and self-initiated study

Develop and maintain effective working relationships with other external organizations, DOJ Program and Project staff, DOJ divisions, and DOJ personnel

Other program related duties as assigned

Qualification

Data analysisSQL Server Management StudioPower BIData governanceData quality analysisComplex data migrationsProblem-solving skillsCommunication skillsInterpersonal skillsOrganizational skills

Required

Six (6) years of information systems experience in performing data and data quality analysis with large, complex data systems

Education will be counted as experience if degree is in Computer Science, Information Technology, or related field, or if a two (2) year accredited vocational training program was completed in information technology or related field

Finalists must pass a comprehensive employment reference check and fingerprint-based criminal background check

A driver history check will be included for positions requiring state vehicle driving privileges

Preferred

Desire and ability to learn and master new technical and business skills

Keen understanding of data management and analysis best practices and technology solutions

Experience analyzing information across multiple disparate databases

Experience using SQL Server Management Studio (SSMS) and Power BI

Experience with complex data migrations

Experience identifying, reporting, and resolving data quality issues

Experience contributing to data governance policies, standards, and procedures

Proactive troubleshooting, listening and problem-solving skills

Ability to plan and perform assignments with minimal or no supervision

Ability to meet deadlines while maintaining attention to detail and accuracy

Ability to sort through multiple and, at times, conflicting needs and priorities is required

Strong communication skills with the ability to communicate clearly, concisely and in a way that technical information is understood by all customers and users, both verbally and in writing

Ability to communicate effectively to both business and information technology staff both verbally and written

Ability to work independently or on a team as a partner to collectively achieve goals

Strong interpersonal skills with the ability to establish and maintain great working relationships with all levels of staff in the Department

Strong organization skills with the ability to shift priorities quickly while continuing to make progress on all work assignments