Data Engineer I, II

Summary

Moda Health is a healthcare organization focused on providing coverage, support, and benefits to its members, community, and employees. The Data Engineer role designs, maintains, and enhances data integration pipelines supporting the Enterprise Data Warehouse and downstream analytics while contributing to cloud modernization initiatives. The role also supports data quality, reporting, data science, and machine learning solutions.

Responsibilities

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

Skills

• 1 - 5 years of experience working with large datasets in relational databases and SQL-based data analytic platforms
• 1 - 5 years of hands-on SQL development experience, including writing complex queries, stored procedures, and performance tuning
• 1 - 5 years of practical experience developing and supporting data pipelines and transformations using SSIS, SQL Agent, Azure Data Factory, and/or Airflow
• 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
• 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
• Demonstrated analytical skills and ability to contribute to data driven solutions that address real business problems, with guidance from senior engineers when needed
• Working knowledge of Agile development methodologies and participation in collaborative, team-based delivery models
• Experience working with business intelligence and reporting tools such as SAS Enterprise Guide, Power BI or SSRS, including supporting downstream analytics and reporting users
• • Bachelor's Degree in a related field or equivalent practical experience preferred
• Experience with SQL Server and modern SQL-based cloud data warehouses, e.g. Snowflake, BigQuery, Redshift, etc.) is preferred
• Exposure to modern cloud-based transformation tools such as dbt or similar is preferred
• Exposure to DevOps practices using tools such as Azure DevOps (CI/CD, work item tracking, GIT version control, Pull Requests) is desirable
• Familiarity with programming or scripting languages such as Python, R, or Java is a plus
• Experience with healthcare data is strongly preferred
• Experience in healthcare systems is a plus; Facets experience preferred

Qualifications

Must Haves

• 1 - 5 years of experience working with large datasets in relational databases and SQL-based data analytic platforms
• 1 - 5 years of hands-on SQL development experience, including writing complex queries, stored procedures, and performance tuning
• 1 - 5 years of practical experience developing and supporting data pipelines and transformations using SSIS, SQL Agent, Azure Data Factory, and/or Airflow
• 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
• 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
• Demonstrated analytical skills and ability to contribute to data driven solutions that address real business problems, with guidance from senior engineers when needed
• Working knowledge of Agile development methodologies and participation in collaborative, team-based delivery models
• Experience working with business intelligence and reporting tools such as SAS Enterprise Guide, Power BI or SSRS, including supporting downstream analytics and reporting users

Nice to Haves

• • Bachelor's Degree in a related field or equivalent practical experience preferred
• Experience with SQL Server and modern SQL-based cloud data warehouses, e.g. Snowflake, BigQuery, Redshift, etc.) is preferred
• Exposure to modern cloud-based transformation tools such as dbt or similar is preferred
• Exposure to DevOps practices using tools such as Azure DevOps (CI/CD, work item tracking, GIT version control, Pull Requests) is desirable
• Familiarity with programming or scripting languages such as Python, R, or Java is a plus
• Experience with healthcare data is strongly preferred
• Experience in healthcare systems is a plus; Facets experience preferred

Benefits

• This is a FT WFH position.
• Medical, Dental, Vision, Pharmacy, Life, & Disability
• 401K- Matching
• FSA
• Employee Assistance Program
• PTO and Company Paid Holidays