Data Engineer I, II (27785806)

Insperity; Oregon; Hybrid; USD 79,000 - 110,000; Full time

Job summary

Moda Health is seeking a Data Engineer to design, develop, and maintain ETL/ELT pipelines feeding the Enterprise Data Warehouse. You will support on-prem data workflows while contributing to cloud modernization with dbt and Snowflake.

You'll work with SQL, data modeling, and BI tools to enable analytics across the organization. This full-time, work-from-home role offers competitive benefits and opportunities to shape data infrastructure.

Qualifications

• Bachelor's degree in a related field or equivalent practical experience preferred.
• 1–5 years of experience with large datasets in relational databases and SQL-based analytics; SQL Server + cloud warehouses preferred.
• 1–5 years of SQL development: complex queries, stored procedures, and performance tuning.
• 1–5 years building data pipelines using SSIS, SQL Agent, Azure Data Factory, Airflow; dbt exposure preferred.
• Experience supporting on-premises EDW and migrations to Snowflake/ cloud tech.
• Understanding of data management, relational structures, and data modeling; best practices for on-prem and cloud.
• Analytical skills for data-driven solutions; team guidance, Agile, and DevOps exposure.
• Experience with BI/reporting tools (SAS Enterprise Guide, Power BI, SSRS).
• Familiarity with Python, R, or Java; healthcare data preferred.

Responsibilities

• Design, develop, test, and maintain ETL/ELT pipelines into the EDW from multiple sources.
• Automate and enhance data pipelines for reliability and scalability, supporting cloud modernization.
• Contribute to data platform modernization and migrations to cloud-based infrastructure.
• Develop data quality checks, validations, and monitoring for data accuracy.
• Build and support enterprise-grade data pipelines and models under guidance.
• Collaborate with cross-functional teams to understand data and reporting needs.
• Support Data Science with data solutions for advanced analytics and ML cases.
• Participate in EDW, BI, and related data-management initiatives; perform code reviews and document.
• Perform other duties as assigned.

Skills

SQL

ETL/ELT

Python

R

Java

Power BI

SSIS

Azure Data Factory

Airflow

DevOps

SAS Enterprise Guide

SSRS

dbt

Snowflake

SQL Server

Education

Bachelor's degree

Tools

dbt

Snowflake

Azure DevOps

Airflow

Job description

About Moda

Founded in Oregon in 1955, Moda is proud to be a company of real people committed to quality. Today, like then, we’re focused on building a better future for healthcare. That starts by offering outstanding coverage to our members, compassionate support to our community and comprehensive benefits to our employees. It keeps going by connecting with neighbors to create healthy spaces and places, together. Moda values diversity and inclusion in our workplace. We aim to demonstrate our commitment to diversity through all our business practices and invite applications from candidates that share our commitment to this diversity. Our diverse experiences and perspectives help us become a stronger organization. Let’s be better together.

Position Summary

The Data Engineer role on the Data Science Team (DST) is responsible for designing, maintaining, and enhancing data integration pipelines that support the Enterprise Data Warehouse (EDW) and downstream analytics. This role supports the existing on premises data environment while actively contributing to cloud modernization initiatives, including the adoption of modern data transformation and cloud data warehouse technologies such as dbt and Snowflake.This is a FT WFH position.

Pay Range

$78,911.43 - $110,265.00 annually (depending on experience). *This role may be classified as hourly (non-exempt) depending on the applicant's location. Actual pay is based on qualifications. Position level is based on qualifications & experience. Applicants who do not exceed the minimum qualifications will only be eligible for the low end of the pay range

Benefits

• Medical, Dental, Vision, Pharmacy, Life, & Disability
• 401K- Matching
• FSA
• Employee Assistance Program
• PTO and Company Paid Holidays

Required Skills, Experience & Education

1. Bachelor's Degree in a related field or equivalent practical experience preferred
2. 1 - 5 years of experience working with large datasets in relational databases and SQL-based data analytic platforms. Experience with SQL Server and modern SQL-based cloud data warehouses, e.g. Snowflake, BigQuery, Redshift, etc.) is preferred.
3. 1 - 5 years of hands-on SQL development experience, including writing complex queries, stored procedures, and performance tuning.
4. 1 - 5 years of practical experience developing and supporting data pipelines and transformations using SSIS, SQL Agent, Azure Data Factory, and/or Airflow. Exposure to modern cloud-based transformation tools such as dbt or similar is preferred.
5. Experience supporting on-premises data warehouse environments and contributing to future cloud modernization efforts, including assisting with migrations from on-premises SQL Server–based platforms to Snowflake or similar cloud technologies.
6. Solid understanding of data management principles, relational data structures, and data modeling, with the ability to apply best practices in both on-premises and modern SQL-based cloud data warehouses.
7. Demonstrated analytical skills and ability to contribute to data driven solutions that address real business problems, with guidance from senior engineers when needed.
8. Working knowledge of Agile development methodologies and participation in collaborative, team-based delivery models.
9. Exposure to DevOps practices using tools such as Azure DevOps (CI/CD, work item tracking, GIT version control, Pull Requests) is desirable.
10. Experience working with business intelligence and reporting tools such as SAS Enterprise Guide, Power BI or SSRS, including supporting downstream analytics and reporting users.
11. Familiarity with programming or scripting languages such as Python, R, or Java is a plus.
12. Experience with healthcare data is strongly preferred.

Primary Functions

1. Design, develop, test, and maintain ETL/ELT pipelines that ingest data from multiple internal and external source systems into the Enterprise Data Warehouse (EDW).
2. Automate, maintain and enhance existing data pipelines to ensure reliability, performance, and scalability, while implementing incremental improvements as part of ongoing cloud modernization efforts.
3. Contribute to data platform modernization initiatives, including assisting with migrations to cloud-based infrastructure and adoption of modern data tools and practices.
4. Develop, implement, and support data quality checks, validation processes, and monitoring to ensure data accuracy and consistency.
5. Build and support modern, enterprise-grade data pipelines and models under the guidance of senior engineers to enable adoption of next-generation data architecture.
6. Collaborate with cross-functional teams to understand data and reporting requirements and provide ongoing support for data infrastructure needs.
7. Support the Data Science team by implementing and maintaining data solutions that enable advanced analytics and machine learning cases.
8. Participate collaboratively in Enterprise Data Warehousing, Business Intelligence, and other data management initiatives, including code reviews and documentation.
9. Perform other duties as assigned.

Working Conditions

• Office environment with extensive close PC and keyboard use, constant sitting, and frequent phone communication. Must be able to navigate multiple computer screens. A reliable, high-speed, hard-wired internet connection required to support remote or hybrid work. Must be comfortable being on camera for virtual training and meetings. Work in excess of standard workweek, including evenings and occasional weekends, to meet business need.
• Experience in healthcare systems is a plus; Facets experience preferred.

Together, we can be more. We can be better.

Moda Health seeks to allow equal employment opportunities for all qualified persons without regard to race, religion, color, age, sex, sexual orientation, national origin, marital status, disability, veteran status or any other status protected by law. This is applicable to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absences, compensation, and training.

For more information regarding accommodations, please direct your questions to Kristy Nehler & Danielle Baker via [e-mail] email.