Data Warehouse Engineer lll
Employer Direct HealthcareDallas, Texas, United States
Posted October 2, 2025
Full Time
About the Company
Employer Direct Healthcare is a specialty care platform connecting individuals with top-tier medical experts for surgeries, cancer care, infusions, and more. The company offers significant cost savings to employers and their employees through its network of quality providers and bundled case rates. Employers Direct also provides dedicated care coordination, including Care Advocates and nurses, ensuring patients receive comprehensive support throughout their treatment journey.
Job Description
Lantern is seeking an experienced Data Warehouse Engineer to join the Analytics Engineering team. This role will focus on building and maintaining robust ELT pipelines, designing scalable data models, and optimizing analytic performance within the Lantern Analytic Platform. The ideal candidate will have hands-on experience with Azure Data Factory, Fivetran, and dbt, and a strong understanding of modern data architecture and performance tuning.
Requirements
- Design, develop, and maintain scalable ELT workflows using Azure Data Factory, Fivetran, and dbt.
- Partner with data analysts to understand business needs and translate them into efficient data models using dbt.
- Manage and optimize the Lantern Analytic Platform by monitoring query performance, implementing data partitioning strategies, and refining data models.
- Strong SQL skills and understanding of data warehousing concepts.
Benefits
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Short & Long Term Disability
- Life Insurance
- 401k with company match
- Paid Time Off
- Paid Parental Leave
