Senior Data Engineer

Madison-Davis; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

Madison-Davis, LLC is seeking a Senior Data Engineer to design and optimize enterprise data solutions using Snowflake and Azure. You will build data warehouses, pipelines, and data models while ensuring reliability and governance across complex health-care related datasets.

You will collaborate with analysts and stakeholders to deliver well-governed data, implement security and CI/CD practices, and drive scalable data processing across enterprise systems.

Qualifications

• 10+ years of production data engineering experience.
• Deep Snowflake engineering expertise.
• Strong SQL development and performance tuning.
• Enterprise ETL/ELT pipeline experience.
• Hands-on Azure data services.
• Data modeling and cloud warehouse architecture experience.
• Production reliability, data quality, and governance expertise.
• Git, CI/CD, and collaborative engineering experience.

Responsibilities

• Design, build, and optimize Snowflake-based data warehouses.
• Develop and maintain Azure-based data ingestion and transformation pipelines.
• Implement incremental processing, automated loading, and scalable transforms.
• Design dimensional models and layered warehouse architectures.
• Improve SQL performance, cost efficiency, and reliability.
• Monitor pipelines, troubleshoot production issues, and ensure data quality.
• Implement data security, access controls, and recovery practices.
• Collaborate with engineers and stakeholders on data requirements and delivery.

Skills

Snowflake engineering

Azure data services

Advanced SQL

ETL/ELT pipelines

Data modeling

Git & CI/CD

Collaboration & comms

Tools

Azure Data Factory

CI/CD tooling

Job description

A healthcare technology organization is seeking a Senior Data Engineer to build and optimize enterprise data solutions using Snowflake and Azure. The position combines hands-on data warehouse engineering, SQL development, scalable data pipelines, data modeling, and production reliability. The engineer will work with complex datasets, including healthcare-related information, while helping analytical and operational teams access reliable, well-governed data. Technical engineering depth is the primary consideration. Relevant candidates from outside the healthcare industry are encouraged to apply.

RESPONSIBILITIES

• Design, build, and optimize cloud data warehouse structures in Snowflake.
• Develop and maintain Azure-based data ingestion and transformation pipelines.
• Implement incremental processing, automated data loading, and scalable data transformation patterns.
• Design dimensional models and layered warehouse architectures.
• Improve SQL performance, warehouse cost efficiency, and processing reliability.
• Monitor data pipelines, troubleshoot production issues, and maintain data quality.
• Implement data security, access control, and recovery practices.
• Collaborate with engineering and business stakeholders on data requirements and delivery.

Role Requirements

• Substantial senior-level production data engineering experience, with 10+ years targeted in the formal JD.
• Strong, recent Snowflake engineering expertise.
• Advanced SQL development and performance tuning.
• Enterprise ETL/ELT pipeline implementation experience.
• Hands-on Azure Data Factory and Azure data services.
• Data modeling and cloud data warehouse architecture experience.
• Production troubleshooting, reliability, and data quality expertise.
• Understanding of data governance, privacy, and access controls.
• Git, CI/CD, and collaborative engineering experience.
• Strong problem-solving and communication skills.

PREFERRED EXPERIENCE

• Healthcare claims, payer, or provider data experience.
• Healthcare EDI and medical coding knowledge.
• SQL Server and SSIS modernization.
• Snowpark, stored procedures, or infrastructure-as-code.
• AI-assisted data engineering tools.