Senior Data Analyst (Information Systems Specialist 7)

Initial Posting Date:

Application Deadline:

Agency:

Salary Range:

Position Type:

Position Title:

Job Description:

Do you look at data like a mountain of untapped potential? Do you have a passion for finding the hidden stories buried within the data? Do you relish opportunities to communicate the stories you discover through visuals? If you answered yes to these questions, then this may be the job for you! 

The Oregon Department of Justice is seeking to hire an experienced Senior Data Analyst (Information Systems Specialist 7) to serve on its Legal Tools Program team. This senior level position has the highest level of responsibility to provide management, analysis, reporting, expertise, planning, advice, and related technical services and support for all Program managed data. This position is part of a team dedicated to ensuring that the Legal Tools Program delivers a product that meets the unique needs of the Department of Justice.

At this time, this position is Limited Duration through June 30, 2025. Funding for this position from July 1, 2025 through June 30, 2027 may be secured and the appointment may be extended. A developmental, work-out-of-class, or underfill (until MQs can be met) rotational opportunity may be possible if the best candidate is internal and a rotation won’t negatively impact the business.      

Apply today! In exchange, we'll ensure you are paid well and equitable to your peers, we'll make work-life balance attainable, and we'll show you the door to professional development and job satisfaction.  You will find that we embrace inclusive and supportive work environments and respect the diverse perspectives, knowledge, and experiences of our coworkers and those seeking to join the organization. We strive to build an inclusive and performance-oriented workplace where all individuals are welcomed and appreciated, leading to increasingly higher levels of fulfillment and success.  

This position may be offered as full time remote within Oregon. Remote work for out-of-state candidates may also be possible, however, a number of factors must be considered; at this time, we are unable to accommodate remote work in all 50 states.

WHAT YOU WILL DO (in part)

• Lead the analysis of 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.
• Manage, 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.

WHAT'S IN IT FOR YOU

When you become a DOJ team member, you will join an agency that values loyal and enthusiastic employees by providing a competitive salary and great benefits, including excellent medical, vision, dental, pension and retirement programs. You also get paid Sick Leave, Vacation, Personal Business Leave, and 11 paid holidays a year.  The position is represented by the Service Employees International Union (SEIU). For more information about our benefits, you can learn here.

REQUIRED EXPERIENCES AND ATTRIBUTES 

Research suggests that women and people of color are less likely to apply unless they are confident they meet 100% of the listed qualifications. We welcome members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, and all interested individuals to apply, and allow us to evaluate the knowledge, skills, and abilities that you demonstrate, using an intentional equity lens.

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. Work experience is based on a 40-hour work week. (Example: 20 hours a week for one year would equal six-months of work experience.)

• Associate’s Degree (or 2-year vocational training) = Two (2) Years
• Bachelor's Degree = Four (4) Years
• Master's Degree = Six (6)

AND

• 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. Adverse findings will be evaluated to determine eligibility for the position.

OUR IDEAL CANDIDATE WILL HAVE

• 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.

APPLICATION PROCESS

• Click "Apply" and complete the online application and all supplemental questions.
• Attach your resume.
• Attach your cover letter.

ALL APPLICANTS: You will only have one opportunity to upload the required resume and cover letter. Drag and drop both resume and cover letter into Workday when prompted to upload your resume. If you are concerned that one or both documents didn't attach to your application, if you need an accommodation under the Americans with Disabilities Act (ADA), have questions, or need assistance with the application process, please contact doj.recruitment@doj.oregon.gov. Any materials emailed will be associated on your behalf if received before the posting deadline.

CURRENT STATE EMPLOYEES: Login to Workday using your state-issued login and apply via the Jobs Hub Worklet located on your home page. Using a private account disrupts the hiring process for all internal candidates. Prior to clicking "Apply", update your employee profile to reflect your Education, Skills, and Job History (including your current job). 

For additional information regarding working for the Department of Justice and application assistance, click HERE.

Candidates from diverse backgrounds are encouraged to apply.  The Department of Justice is an equal opportunity employer, does not discriminate based on race, color, national origin, ethnicity, veteran status, gender, sexual orientation, religion, age, or disability, and is committed to workplace diversity. 

Oregon Department of Justice 
1162 Court St NE 
Salem OR, 97301 
DOJ.recruitment@doj.oregon.gov 

Phone: (503) 947-4328 
Fax: (503) 373-0367