Analytics Engineer

Lantern•Dallas, TX

3d•Hybrid

About The Position

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. 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. The Analytics Engineer is a hands-on individual contributor within Lantern’s centralized Analytics Center of Excellence (CoE), responsible for building, testing, releasing, and maintaining shared analytical data models that enable a distributed analytics community to confidently self-serve insights. The role partners with analysts and analytics leaders across the business to identify common needs, close data gaps, and improve the reliability and consistency of analytics. This is a builder role focused on durable, reusable data products, not one-off analysis. Success is measured by data quality, adoption of certified models, smooth analytics releases, and reduced ambiguity in business reporting.

Requirements

3–6 years of experience in analytics engineering or closely related data roles.
Strong SQL skills with experience delivering production analytical data models.
Handson experience with dbt (Core or Cloud).
Experience with cloud data platforms such as Databricks or Snowflake.
Experience working with regulated data (PII/PHI).
Ability to communicate data changes and assumptions clearly to nontechnical partners.
Experience working with large datasets, performing data validation, comparison, and reconciliation tasks.
Strong proficiency in Microsoft Excel for data analysis, reconciliation, and reporting.

Nice To Haves

Experience with medallion or layered data architectures.
Exposure to automated data quality tooling (e.g., dbt tests, Soda).
Familiarity with orchestration and deployment workflows (Airflow, Azure Data Factory).
Experience supporting Finance, Operations, or Commercial analytics use cases.

Responsibilities

Data Modeling & Analytics Engineering Design and maintain fact and dimension models optimized for dashboards, reporting, and self-service analytics in Databricks using dbt.
Explore and onboard new or external data sources, developing Bronze and Silver layer models that make data usable by analysts.
Implement approved "single source of truth" KPI logic in Silver and Gold models, ensuring accuracy, consistency, and maintainability.
Maintain clear documentation to support adoption and correct usage by the analytics community.
Apply established SDLC practices, including Gitbased version control, code reviews, and participation in QA/UAT.
Collaboration & Enablement Partner with Business Analysts, Finance, Operations, and Strategy teams to translate recurring analytics needs into scalable, shared models.
Act as an enablement resource for a distributed analytics community by answering questions, providing guidance, and coaching on data usage and SQL best practices.
Improve shared data assets based on analyst feedback and usage patterns rather than building one-off solutions.
Production Support & Deployment Implement automated data tests (schema, freshness, and business logic) as part of regular development work.
Support and lead analytics releases, including regression testing, release documentation, release notifications, and post release validation.
Perform level1 triage of data quality and performance issues, resolving issues where possible and escalating to Data Engineering when required.
Collaborate with Data Engineering to address source data issues and identify performance optimizations.