Senior Data Warehouse Engineer

The role

This person will build and maintain ELT pipelines and design scalable data models. They will optimize the Lantern Analytic Platform for performance.

What you will do

• Design, develop, and maintain scalable ELT workflows using Azure Data Factory, Fivetran, and dbt.
• Monitor pipeline health and troubleshoot issues.
• Partner with data analysts to translate business needs into data models using dbt.
• Refine models to support evolving analytic requirements.
• Manage and optimize the Lantern Analytic Platform.
• Monitor query performance.
• Implement data partitioning strategies.
• Refine data models to enhance speed and efficiency.

Required qualifications

• Bachelor's degree in Computer Science or a related field (or equivalent practical experience)
• A minimum of 5 years of professional experience as a Data Engineer, Data Warehouse Engineer, or similar role building production data pipelines
• A minimum of 5 years of production-grade experience with Python and SQL
• A minimum of 2 years of hands-on experience with Databricks (Spark/PySpark, Delta Lake, Workflows)
• Hands-on experience building ELT/ETL pipelines with tools such as Azure Data Factory, Fivetran, or dbt
• Strong understanding of data warehousing concepts, with hands-on experience designing, building, and optimizing data models (e.g., dimensional modeling)
• Experience with query and pipeline performance tuning
• Experience supporting analytics and reporting consumers, partnering with analysts and cross-functional teams
• Hands-on experience using AI coding tools (e.g., Claude Code, Copilot) in day-to-day engineering work

Nice to have

• Experience with Databricks Genie or Snowflake Cortex
• Experience in the healthcare industry

Benefits

• Medical Insurance
• Dental Insurance
• Vision Insurance
• Short & Long Term Disability
• Life Insurance
• 401k with company match
• Flexible Time Off
• Paid Parental Leave

About the company

Lantern is a specialty care platform connecting people with a Network of Excellence of specialists for surgery, cancer care, infusions and more. It is trusted by the nation's largest employers to deliver care to more than 6 million members.