Pay
$127K–$190K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,133 postings in the last year. Stated ranges, not salaries paid.
Senior Data Warehouse Engineer
Dallas, TX - Hybrid (3x in office/week)
Live, first seen by us 31 days ago- Pay
- Pay not listedSimilar roles state $127K–$190K
- Work setting
HybridLocation limits apply — work setting source
Lantern is looking for an experienced, Senior Data Warehouse Engineer to join our 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. Location: Hybrid - at least 3 days/week in our Dallas, TX offices Responsibilities:
Listed location: Dallas, TX - Hybrid (3x in office/week)
Read the full posting- Employment
- Not stated
What you’ll work on
Full postingDesign, develop, and maintain ELT workflows using Azure Data Factory, Fivetran, and dbt
Monitor pipeline health and troubleshoot issues to keep data delivery reliable
Translate analyst business needs into documented dbt data models
Optimize platform speed through query monitoring, partitioning, and model refinement
From the employer’s posting
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
monitoring query performance, implementing data partitioning strategies, and refining data models to enhance speed and efficiency
What you’ll bring
All qualificationsCore experience
- Bachelor's degree in Computer Science or a related field (or equivalent practical experience)
- 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
Preferred experience
- Experience with Databricks Genie or Snowflake Cortex
- Experience in the healthcare industry
Qualification wording
Bachelor's degree in Computer Science or a related field (or equivalent practical experience)
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
Experience with Databricks Genie or Snowflake Cortex
Experience in the healthcare industry
Education & alternatives
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
Benefits in the posting
Full benefits wording- Medical Insurance
- Dental Insurance
- Vision Insurance
- Short & Long Term Disability
- Life Insurance
- 401k with company match
- Flexible Time Off
- Paid Parental Leave
From the employer’s posting.
About Lantern
Lantern is the specialty care platform connecting people with the best care when they need it most.
In the employer’s words · Read in context
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Oct 4, 202631 days ago
- Recorded sightings
- 30
- Last seen by us
- Nov 5, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
Time since we first saw it
Day 31
Similar jobs usually come down between day 6 and day 54.
At Lantern, jobs usually come down by about day 67.
From 11,033 similar postings that came down, and 5 of Lantern’s. Coming down is not always a hire.
Lantern is hiring
5 open jobs
Open jobs by the week we first saw them, last 12 weeks.
- Takes jobs down at a usual pace
- 20% of open jobs were reposted
See how this role fits your experience
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Python
- SQL
- Azure
- Databricks
- dbt
- Delta Lake
- Fivetran
- Snowflake
- Spark
- PySpark
Where the posting names them
- 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)
Lantern is the specialty care platform connecting people with the best care when they need it most. By curating a Network of Excellence comprised of the nation's top specialists for surgery, cancer care, infusions and more, Lantern delivers excellent care with significant cost savings to employers and their workforces. Lantern also pairs members with a dedicated care team, including Care Advocates and nurses, for the entirety of their care journey, helping them get back to good health, back to their families and back to work. With convenient access to specialists nationwide, Lantern means quality care is within driving distance for most. Lantern is trusted by the nation's largest employers to deliver care to more than 6 million members across the country. Learn more about us at lanterncare.com. Lantern is looking for an experienced, Senior Data Warehouse Engineer to join our 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. Location: Hybrid - at least 3 days/week in our Dallas, TX offices
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.
- 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)
- 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
Preferred Skills: - Experience with Databricks Genie or Snowflake Cortex - Experience in the healthcare industry
- 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.
Your next step
Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.
Applying through Greenhouse
- No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
- Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.
Already applied? Track this application
Demand for Data Engineer roles
New Data Engineer postings at the employers we follow are up 8% over the last 5 weeks compared with the 5 before.
Each bar is one week of new postings. The darkest bars are the last 5 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
- Median yearly pay, May 2025
- $139,500
- Expected change, 2025 to 2035
- 9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Job description
About Lantern
Lantern is the specialty care platform connecting people with the best care when they need it most. By curating a Network of Excellence comprised of the nation's top specialists for surgery, cancer care, infusions and more, Lantern delivers excellent care with significant cost savings to employers and their workforces. Lantern also pairs members with a dedicated care team, including Care Advocates and nurses, for the entirety of their care journey, helping them get back to good health, back to their families and back to work. With convenient access to specialists nationwide, Lantern means quality care is within driving distance for most. Lantern is trusted by the nation's largest employers to deliver care to more than 6 million members across the country. Learn more about us at lanterncare.com.
Lantern is looking for an experienced, Senior Data Warehouse Engineer to join our 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.
Location: Hybrid - at least 3 days/week in our Dallas, TX offices
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.
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
Preferred Skills:
- Experience with Databricks Genie or Snowflake Cortex
- Experience in the healthcare industry
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.
- You have the GRIT, 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 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.
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
Dallas, TX - Hybrid (3x in office/week)
Lantern is looking for an experienced, Senior Data Warehouse Engineer to join our 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. Location: Hybrid - at least 3 days/week in our Dallas, TX offices Responsibilities:
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.