Database Engineer, Information Systems Specialist 7

State of Oregon; United States; Remote; USD 6,800 - 10,000; Full time

Benefits offered by this job

ODHS Employee Resource Groups

Cost of Living Adjustments

Annual salary increases

Amazing benefits package

Public Service Loan Forgiveness

Job summary

The Oregon Department of Human Services is seeking a Database Engineer to modernize data infrastructure, migrating from on‑prem to Snowflake, building data models, and delivering self‑service BI. You will collaborate with DBAs, data engineers, and BI teams to ensure secure, scalable solutions and governance across enterprise reporting.

This role focuses on equity and empowerment through data-driven insights.

Qualifications

• Six+ years of information systems experience translating business needs into data models and data warehouse solutions.
• Bachelor’s or higher in IT/CS or related field with relevant experience; substitute master’s for all above.
• Experience implementing governance, security, and data lineage across enterprise data solutions.

Responsibilities

• Collaborate with stakeholders to capture data needs and reporting requirements.
• Translate requirements into conceptual, logical, and physical data models.
• Design and implement Power BI semantic models with secure access and governance.
• Integrate data from multiple sources for scalable analytics.
• Maintain SQL Server and Snowflake environments, supporting migrations.
• Establish RBAC, encryption, data masking, and data governance standards.
• Troubleshoot complex data warehouse issues and optimize performance.
• Collaborate with DBAs, BI developers, and leadership on data solutions.
• Promote a diverse, discrimination-free workplace.
• Value diversity and inclusion in the workplace.

Skills

Data warehouse design

ETL/ELT workflows

Power BI semantic models

RBAC and data security

Education

Bachelor's degree in IT/CS or related field

Associate's degree in CS/IT or related field

Master’s degree may substitute for all above

Tools

SQL Server

Snowflake

Azure Data Factory

Python

Job description

Initial Posting Date:

09/21/2026

Application Deadline:

09/28/2026

Agency:

Department of Human Services

Salary Range:

$6,846 - $10,344

Position Type:

Employee

Position Title:

Database Engineer, Information Systems Specialist 7

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 data infrastructure is secure, reliable, efficient, and scalable, enabling high-quality reporting, advanced analytics, and self-service BI capabilities.

The position plays a critical role in 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 Database Engineer will also contribute to the modernization of ODHS data infrastructure, including the migration from traditional on‑premises data warehouse environments to the Snowflake cloud data platform.

The position functions as a technical expert within the ODHS Data Office and collaborates closely with BI developers, data engineers, data analysts, database administrator professionals, and external partners to design, develop, and implement integrated data solutions. This includes supporting cloud data migration, workflow automation, data modeling, data governance, security, and other strategic initiatives that advance ODHS’s mission through data‑driven insights.

Summary of Duties

As a Database Engineer , you will:

• Collaborate directly with ODHS program business partners to understand business processes, workflows, data needs, and reporting requirements. This may include observing or shadowing program staff to understand how work is performed and how data is created, captured, and used.
• Translate business processes and requirements into conceptual data models and develop logical and physical data models that accurately represent business needs and support enterprise reporting and analytics.
• Design, develop, and implement Power BI semantic models based on business requirements and enterprise data models. Work closely with business partners and BI developers to ensure semantic models accurately represent business definitions, measures, relationships, and reporting needs while providing secure, governed, and reusable data for reporting and self‑service analytics.
• Identify and integrate data from multiple sources and design data solutions optimized for performance, scalability, reliability, security, and ease of use.
• Design, develop, and maintain data solutions across on‑premises SQL Server and cloud‑based Snowflake environments, including supporting the migration and modernization of existing data warehouse solutions.
• Establish and document standards for role‑based access control (RBAC), encryption, data masking, metadata management, data lineage, data documentation, and other data governance and security practices.
• Apply data warehouse and database best practices for indexing, partitioning, clustering, performance, scalability, reliability, and cost effectiveness.
• Troubleshoot complex database and data warehouse issues and recommend scalable and cost‑effective solutions.
• Collaborate with DBAs, data engineers, BI developers, reporting teams, business partners, and leadership to design and implement data solutions that meet organizational and reporting needs.
• Promote and foster a diverse, qualified, and discrimination/harassment‑free workplace.
• Recognize and value all individuals regardless of their cultures, identities, and backgrounds.

Minimum Qualifications

Six (6) years of information systems experience in:

• Experience analyzing business processes and data requirements and translating them into conceptual, logical, and physical data models; designing and implementing data warehouse solutions; and developing governed semantic models to support enterprise reporting, analytics, and self‑service business intelligence;

OR

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:

• Experience analyzing business processes and data requirements and translating them into conceptual, logical, and physical data models; designing and implementing data warehouse solutions; and developing governed semantic models to support enterprise reporting, analytics, and self‑service business intelligence;

OR

A Bachelor’s degree in Information Technology, Computer Science, or related field
AND two (2) years of information systems experience in:

• Experience analyzing business processes and requirements and translating them into conceptual, logical, and physical data models, designing and implementing data warehouse solutions, and developing and implementing semantic models to support enterprise reporting, analytics, and self‑service business intelligence.

OR

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, Snowflake, or similar relational and cloud data platforms.
• Experience designing and implementing ETL/ELT workflows and data integration solutions using SQL, Azure Data Factory, Python, or similar technologies.
• Experience analyzing business processes and requirements and translating them into conceptual, logical, and physical data models, including dimensional models and star schemas.
• Experience designing, developing, and implementing Power BI semantic models, including relationships, measures, DAX, and row‑level security (RLS), in collaboration with business partners and BI developers.
• Experience applying data governance, security, metadata, data lineage, performance, and DevOps practices to enterprise data solutions.
• Strong communication, collaboration, and knowledge‑sharing skills, including the ability to work directly with business partners, explain technical concepts, mentor peers, support onboarding, and help resolve complex technical issues.

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.
• Occasional travel is required for this position. Employees must be able to report to the Salem office when training, business needs, or operational requirements necessitate on‑site participation. For additional details on travel expectations, please refer to the Statewide Travel Policy. https://www.oregon.gov/das/Financial/Acctng/Documents/40.10.00.pdf

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.
• Must be approved by the designated Criminal Justice Information Services (CJIS) through a fingerprint‑based national criminal background check for access to Criminal Justice Information (CJI). Must complete the appropriate level of CJIS Security Awareness Training.

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.

General Information

• This is a permanent, full‑time position and is represented by the Service Employees International Union (SEIU).
• This recruitment may be used to fill future vacancies in the same classification.

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 Nora Leyva Esquivel. If you contact the recruiter, please include the job requisition number: REQ- 207045
• Email: [e-mail] Phone (call or text): 503-269-4222