Senior Data Warehouse Engineer

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.

Requirements

• Bachelor's degree in Computer Science or a related field (or equivalent practical experience)
• A minimum of 5 years of professional experience as a Data Engineer, Data Warehouse Engineer, or similar role building production data pipelines
• A minimum of 5 years of production-grade experience with Python and SQL
• A minimum of 2 years of hands-on experience with Databricks (Spark/PySpark, Delta Lake, Workflows)
• Hands-on experience building ELT/ETL pipelines with tools such as Azure Data Factory, Fivetran, or dbt
• Strong understanding of data warehousing concepts, with hands-on experience designing, building, and optimizing data models (e.g., dimensional modeling)

Experience with query and pipeline performance tuning

• Experience supporting analytics and reporting consumers, partnering with analysts and cross-functional teams
• Hands-on experience using AI coding tools (e.g., Claude Code, Copilot) in day-to-day engineering work, drive and ambition to tackle big problems. Big problems require big ideas and a team that supports new ideas.
• You care deeply for your customers are driven to keep

Preferred

• Experience with Databricks Genie or Snowflake Cortex
• Experience in the healthcare industry

Location

Hybrid - at least 3 days/week in our Dallas, TX offices

Benefits

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

About You

You use

LOGIC

in your decision making and understand that progress is critical to making change. You focus on the execution of your content while balancing a fast-paced environment and you take the time to celebrate both the small & big wins.

INCLUSION

is a core tenant of your personal beliefs. A diverse and inclusive environment is incredibly important to you. You understand and desire to be a part of a diverse team with different experiences and perspectives & you cherish the differences in each individual that you interact with.

HUMANITY

• in all decisions. Your customers aren’t just the individuals using your product. They are the driving factor in your motivation to make a change.
• Integrity guides you in life. Focusing on the

TRUTH

• vs. giving people the answers they want to hear.
• You thrive in a Team Environment. Collaboration is key in innovation and creating change.
• These pillars of

LIGHT

are a reminder to our team that we are making a difference by providing guidance and support in navigating the often complex and confusing landscape of healthcare. We hope that through this

LIGHT

, individuals can find their way to the best care, resources, and support they need to get back to life.

If this sounds like you, we would love to connect to speak further about career opportunities at Lantern.

Please apply to our role & someone from our Talent Acquisition Team will reach out to help you navigate our interview process.

Lantern does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.