Employer Direct Healthcare
Employer Direct Healthcare
Employer Direct Healthcare ajută organizațiile care își asigură singure angajații să le ofere acestora îngrijire medicală de specialitate de înaltă calitate, la un cost mai accesibil. Prin platforma Lantern Specialty Care, compania conectează membrii cu o rețea atent selectată de chirurgi și unități medicale pentru proceduri planificate, tratamentul cancerului și îngrijire prin perfuzie. Modelul său de îngrijire combină selectarea furnizorilor, negocierea tarifelor și sprijinul pe parcursul întregului tratament, punând accent pe accesul la îngrijire excelentă la o distanță rezonabilă cu mașina pentru membrii din comunități rurale și urbane deopotrivă.

Senior Data Warehouse Engineer - Hybrid

Build and optimize ELT pipelines and analytical data models for Lantern’s specialty healthcare platform. Work with Azure Data Factory, Fivetran, dbt, Python, and SQL to improve data reliability and analytics performance.

Descriere

  • Develop and maintain scalable ELT workflows with Azure Data Factory, Fivetran, and dbt
  • Track pipeline health, investigate failures, and resolve issues to maintain dependable data delivery
  • Collaborate with data analysts to translate business needs into efficient, clearly documented dbt data models
  • Update and improve data models as analytical requirements evolve
  • Administer and optimize the Lantern Analytic Platform
  • Evaluate query performance and apply appropriate data partitioning strategies
  • Improve data models to increase processing speed and operational efficiency

Cerințe

  • Bachelor’s degree in computer science or a related discipline, or equivalent practical experience
  • At least five years of professional experience as a data engineer, data warehouse engineer, or comparable specialist developing production data pipelines
  • At least five years of production experience programming with Python and SQL
  • At least two years of hands-on Databricks experience, including Spark or PySpark, Delta Lake, and Workflows
  • Practical experience creating ELT or ETL pipelines with platforms such as Azure Data Factory, Fivetran, or dbt
  • Strong knowledge of data warehousing, including the design, development, and optimization of data models such as dimensional models
  • Experience tuning query and pipeline performance
  • Experience supporting analytics and reporting users while collaborating with analysts and cross-functional partners
  • Regular hands-on use of AI coding tools such as Claude Code or Copilot in engineering work
  • Preferred: Familiarity with Databricks Genie or Snowflake Cortex
  • Preferred: Background in healthcare

Beneficii

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Short- and long-term disability coverage
  • Life insurance
  • 401(k) with company matching
  • Flexible time off
  • Paid parental leave

Locuri de muncă similare