Data Warehouse Engineer lll

Lantern • Dallas, TX

85d

About The Position

Lantern is looking for an experienced Data Warehouse Engineer to join the growing 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

• Bachelors degree in computer science or related field
• 3-5 years of experience with reporting and analytics
• Proven experience with ELT tools such as Azure Data Factory, Fivetran, and dbt
• Strong SQL skills and understanding of data warehousing concepts
• Experience with performance tuning and data model optimization
• Ability to collaborate effectively with cross-functional teams
• Familiarity with cloud data platforms (e.g., Azure, Snowflake, BigQuery) is a plus

Nice To Haves

• Experience with SQL and Python within the healthcare industry
• Demonstrate the ability to learn new business models and technologies

Responsibilities

• Design, develop, and maintain scalable ELT workflows using Azure Data Factory, Fivetran, and dbt.
• Proactively monitor pipeline health and troubleshoot issues to ensure reliable data delivery.
• Partner with data analysts to understand business needs and translate them into efficient, well-documented data models using dbt.
• Continuously refine models to support evolving analytic requirements.
• Manage and optimize the Lantern Analytic Platform by monitoring query performance, implementing data partitioning strategies, and refining data models to enhance speed and efficiency.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 501-1,000 employees