Database Engineer (Information Systems Specialist 7)

Initial Posting Date:

Application Deadline:

Agency:

Salary Range:

Position Type:

Position Title:

Job Description:

The Oregon Department of Human Services is proud to be an Equal Opportunity Employer. We are guided by our Equity North Star and our vision for a positive RiSE organizational culture that advances equity and diversity. We encourage applications from members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, LGBTQIA2S+ community members, and others to help us achieve our vision of a diverse and inclusive community.

Opportunity awaits! We are seeking a Database Engineer to join our team! This position ensures that ODHS's data infrastructure is secure, reliable, efficient, and scalable, enabling high-quality reporting, advanced analytics, and self-service BI capabilities. The role is critical to transforming complex transaction data into well-structured data warehouse models, including star schemas and semantic layers, that support agency-wide decision-making and equity-focused outcomes. The position functions as a technical expert within the ODHS Data Office program and collaborates closely with BI developers, data analysts, program managers, and external. partners to deliver integrated solutions. This includes implementing workflow automation, enforcing data governance and security practices, and supporting strategic initiatives that advance ODHS's mission through data-driven insights.

Summary of Duties

As a Database Engineer, you will:

• Collaborate with cross-program and cross-agency professionals to identify data sources and design database models optimized for performance, scalability, and ease of use.
• Partner with program personnel to develop data structures that enable self-service reporting and provide advanced support for data warehouse-related issues.
• Design, develop, and maintain data solutions across on-premises SQL Server and cloud-based Snowflake environments.
• Define and document enterprise processes for role-based access control (RBAC), encryption and data masking for new or enhanced applications to safeguard sensitive information and ensure alignment with ODHS data governance and security standards.
• Define and establish metadata management standards, technical documentation processes and data lineage tracking for new or enhanced applications.
• Apply best practices for indexing, partitioning, clustering, and caching to enhance system efficiency and scalability.
• Troubleshoot complex database performance issues and recommend cost-effective, scalable solutions.
• Collaborate with DBAs, data engineers, reporting teams, business partners, and leadership to align data solutions with organizational needs and reporting requirements
• Promotes and fosters a diverse and qualified workforce and discrimination/harassment-free workplace.
• Recognizes and value of all individuals regardless of their cultures, identities, and backgrounds.

Minimum Qualifications

• (a) Six (6) years of information systems experience
  OR
  (b) An Associate's degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field;
  AND
  four (4) years of information systems experience in:
  (agency will specify specific experience);
  OR
  (c) A Bachelor's degree in Information Technology, Computer Science, or related field
  AND
  two (2) years of information systems experience in:
  (agency will specify specific experience);
  OR
  (d) Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

Essential Attributes

We are looking for candidates with:

• Advanced experience designing, and developing enterprise data warehouse solutions using SQL Server and Snowflake.
• Experience designing and supporting ETL/ELT workflows using tools such as SQL, Azure Data Factory, and Python.
• Experience designing semantic models, star schemas, DAX measures, and row-level security - RLS in Power BI Service.
• Strong leadership, communication, collaboration, governance, and DevOps skills.

Attention all candidates! A cover letter is required.

Clearly describe how you meet the minimum qualifications and essential attributes in your application materials. Your application materials will determine if you are selected to move forward in the selection process. Please include detailed work and education history.

• Please upload a resume or complete the work history profile. Note: Your resume and cover letter may be uploaded in the Resume/CV field on the online application.
• Current State of Oregon employees: Apply via your employee Workday account.
• If you are not a current State of Oregon employee, view this application instructional video.
• After you submit your application, you will have additional tasks to complete in Workday. Please continue to check your Workday account throughout the recruitment process.

• The use of outside resources such as Artificial Intelligence software during applicant skill assessments, examinations, and/or interviews is prohibited unless otherwise stated by the hiring agency. Unauthorized use of outside resources during the hiring process will result in disqualification.
• The State of Oregon does not request or require your age, date of birth, attendance or graduation dates from an educational institution during the application process.

Working Conditions

• This position generally works a standard work week that may involve irregular work hours at times of contract development and budget implementation and rebalancing. Infrequent travel throughout the state may be required.

Background Checks and Requirements

• If selected as a finalist, we will conduct a criminal history and background check. Adverse criminal history or background check may lead to disqualification. Additional background check information.
• The Oregon Department of Human Services does not offer visa sponsorship. Within three days of hire, you will be required to complete the US Department of Homeland Security’s I-9 form confirming authorization to work in the United States. ODHS will use E-Verify to confirm that you are authorized to work in the United States.

Benefits

• ODHS Employee Resource Group communities that promote shared learning.
• Cost of Living Adjustments.
• Annual salary increases (until you reach the top of the listed salary range).
• Amazing benefits package.
• Possible eligibility for the Public Service Loan Forgiveness Program.

Employment Preference

Veterans’ and Oregon National Guard preference:

• Eligible Veterans and Oregon National Guard servicemembers (current and former) who meet the qualifications of the position will be awarded candidate preference. For more information, please visit Veterans Resources.

Contact Information

We invite you to contact the recruiter for accommodation requests under the Americans with Disabilities Act (ADA), application questions or job-specific questions. The recruiter for this position is Ryan Bennett and can be reached at [email protected]