Lantern · 3 months ago
Data Warehouse Engineer lll
United States
Full-time
Remote
Mid Level
3+ years expLantern is a specialty care platform that connects people with top specialists for various medical needs. They are seeking an experienced Data Warehouse Engineer to build and maintain ELT pipelines, design scalable data models, and optimize analytics performance within their platform.
Health CareHospitalMedicalMedical DeviceMental Health
Responsibilities
Implement and Monitor ELT Pipelines: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
Data Modeling and Collaboration: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
Analytics Platform Optimization:Manage and optimize the Lantern Analytic Platform by monitoring query performance, implementing data partitioning strategies, and refining data models to enhance speed and efficiency
Qualification
Required
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
Preferred
Familiarity with cloud data platforms (e.g., Azure, Snowflake, BigQuery)
Have experience with SQL and Python within the healthcare industry, and demonstrate the ability to learn new business models and technologies
Benefits
Medical Insurance
Dental Insurance
Vision Insurance
Short & Long Term Disability
Life Insurance
401k with company match
Paid Time Off
Paid Parental Leave
Company
Lantern
Lantern is the specialty care platform connecting people with the best care when they need it most.
501-1000 employees
H1B Sponsorship
Lantern has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (12)
2024 (7)
2023 (3)
2022 (4)
2021 (3)
2020 (1)
Funding
Current Stage
Late StageTotal Funding
$93MKey Investors
Insight PartnersDundon Capital PartnersTEXO Ventures
2023-12-19Secondary Market· $92M
2020-10-27Series Unknown
2016-01-12Series C
Leadership Team
John Zutter
Chief Executive Officer
Fiona Mulligan
Chief Operating Officer
Recent News
Company data provided by crunchbase