Senior Data Warehouse Engineer

Job overview

The Senior Data Warehouse Engineer role is hybrid, with at least three days per week in Lantern’s Dallas, Texas offices. Compensation is not specified. Lantern connects members with specialist care and dedicated care teams, aiming to provide quality care with cost savings for employers and their workforces. The engineer builds and maintains reliable ELT pipelines, scalable data models, and analytic performance for the Lantern Analytic Platform. By partnering with analysts and other teams, the role helps ensure data is dependable, well-structured, and performant for analytics and reporting needs.

What you'll do

• Design, develop, maintain, monitor, and troubleshoot ELT workflows using Azure Data Factory, Fivetran, and dbt
• partner with analysts to translate business needs into documented data models
• refine models as analytic requirements evolve
• monitor query performance
• implement data partitioning strategies
• optimize the Lantern Analytic Platform.

What we're looking for

Skills & competencies

senior data warehouse engineer

data engineering

elt pipelines

azure data factory

fivetran

dbt

databricks

python

sql

data modeling

hybrid

dallas tx

lantern

Work arrangement

• Weekend coverage required

Benefits & perks

• Medical, dental, and vision insurance
• short- and long-term disability
• life insurance
• 401(k) with company match
• flexible time off
• paid parental leave.

Why this role

The posting requires production-grade Python and SQL experience, Databricks experience, and hands-on use of AI coding tools. Benefits include medical, dental, and vision insurance, disability and life insurance, 401(k) with company match, flexible time off, and paid parental leave.

About the employer

Lantern is hiring for this role. Industry: Direct Health and Medical Insurance Carriers. Sector: 52.