Analytics Engineer, Semantic Layer

Welldoc Inc; Columbia (MD); In loco; USD 110.000 - 130.000; Tempo pieno

Vantaggi offerti da questo lavoro

PTO

Medical insurance

Dental insurance

Vision care

Life and disability insurance

Retirement benefits

Health savings accounts

Dependent care accounts

Descrizione del lavoro

Welldoc Inc is seeking a data modeling and analytics expert to design and own the semantic layer powering BI dashboards and AI-driven applications. You’ll shape the data model end-to-end, collaborate with analysts and engineers, and drive data governance and standards across the team.

You’ll work closely with stakeholders to translate questions into reusable metrics, improve performance, and enable analytics and AI tooling across Welldoc’s platforms.

Competenze

• 3–5 years designing and building data models and transformations for analytics.
• 3+ years of hands-on Databricks experience including Unity Catalog and Bronze/Silver/Gold architecture.
• Hands-on experience building a semantic or metrics layer (Databricks metric views preferred).
• Advanced SQL, Python, and Git-based development workflows.
• Able to translate ambiguous business needs into concrete data models and metrics.
• Clear written and verbal communication with non-technical audiences.
• Ownership mindset and proactive problem-solver.
• Experience with Power BI downstream of semantic layer (preferred).
• Experience preparing data for AI/BI tools (preferred).

Mansioni

• Semantic layer: design and build our consumption layer using Databricks Unity Catalog metric views.
• The data model: evaluate current Silver/Gold structures and lead buildout of the new model for usability, performance, and scale.
• Translate business questions into well-scoped technical requirements with analysts, data engineers, and stakeholders.
• BI and AI consumption: ensure layer serves Power BI, self-service analytics, and AI tools like Databricks Genie and LLM apps.
• Standards and governance: establish modeling conventions, data quality checks, and metric definitions with Data Governance Council.
• Engineering rigor: bring version control, testing, modular design, and automation to analytics workflows.
• Tooling: evaluate new tools and features and recommend adoption.
• Troubleshooting: diagnose data issues and explain root causes to non-technical stakeholders.

Conoscenze

Databricks

SQL

Python

Git workflows

Power BI

Data modeling

Data governance

Communication

AI tools

LLM applications

Formazione

Bachelor’s in CS/Data Science/Business Analytics

Strumenti

Databricks Unity Catalog

dbt Semantic Layer/MetricFlow

LookML

Cube

Descrizione del lavoro

Company & Culture

Welldoc is driven by a powerful mission: empowering better health across conditions through AI-powered, personalized health tech, with a vision to be the leading clinically trusted AI tech partner across the healthcare industry. We're a team passionate about leveraging cutting-edge science to improve lives, united by core values of collaborative innovation, accountability to excellence, customer focus, efficiency, and unwavering integrity, quality, and safety.

At Welldoc, you'll thrive in a collaborative and innovative environment where your contributions directly impact our mission. Recognized as a Great Place to Work for the past five years and named to Modern Healthcare’s Best Places to Work 2026, as well as being an industry thought leader featured at SXSW and in the Wall Street Journal and Economist, we invite you to make a real difference in healthcare with us.

Job Purpose

This role sits on the Reporting & Visualization (analytics) team. You’ll design and build the semantic layer that defines how Welldoc measures its business. That layer will power our BI dashboards and our AI-driven applications. This is an individual contributor role real leadership scope. You’ll be the team’s go-to expert on the data model. You’ll set modeling standards, help shape data governance, and influence how analysts, engineers, and business stakeholders use data.

This role is a fit if you…

• Like owning a data model end to end: the business definitions, the build, and the long-term upkeep.
• Enjoy sitting with analysts and stakeholders, understanding their questions, and turning them into clean, reusable metrics.
• Are comfortable with ambiguity and would rather shape the plan than follow one.
• Want to work in person with a small, collaborative team.

Resposibilities

• Semantic layer: Design and build our consumption layer using Databricks Unity Catalog metric views. This includes defining measures, dimensions, joins, and business logic once so they can be reused everywhere.
• The data model: Evaluate our current Silver and Gold structures and recommend changes. Then lead the buildout of the new model with a focus on usability, performance, and scale.
• Requirements: Partner with analysts, data engineers, and business stakeholders to turn business questions into well-scoped technical requirements.
• BI and AI consumption: Make sure the layer serves Power BI reporting, self-service analytics, and AI tools such as Databricks Genie and LLM-based applications.
• Standards and governance: Help establish modeling conventions, documentation, data quality checks, and metric definitions. Work alongside our Data Governance Council.
• Engineering rigor: Bring version control, testing, modular design, and automation to analytics workflows.
• Tooling: Evaluate new tools and features as our stack evolves, and recommend what’s worth adopting.
• Troubleshooting: Diagnose data issues and explain root causes and fixes clearly to non-technical stakeholders.

Required Skills & Experience

• 3–5 years designing and building data models and transformations specifically for analytics use cases.
• 3+ years of hands‑on Databricks experience, including Unity Catalog and the medallion (Bronze/Silver/Gold) architecture.
• Hands‑on experience building a semantic or metrics layer. Databricks metric views are strongly preferred, and dbt Semantic Layer/MetricFlow, LookML, Cube, or Power BI semantic models are relevant too.
• Advanced SQL, working Python, and Git‑based development workflows.
• A track record of translating ambiguous business needs into concrete data models and metric definitions.
• Clear written and verbal communication, especially with non‑technical audiences.
• A proactive, ownership‑driven mindset. You spot problems and opportunities before anyone asks.
• Experience with Power BI as a downstream consumer of a semantic layer (preferred).
• Experience preparing data for AI/BI tools such as Genie or LLM applications (preferred).
  

Welldoc operates in ISO 13485 and MDSAP regulated and HITRUST and SOC 2 Type II compliant environments. Therefore, it is expected that all employees will have either prior experience working in those environments or will be trained to understand the requirements needed to work and support those requirements and culture as they relate to individual roles and responsibilities.

Required Education

• Bachelor’s degree in Computer Science, Data Science or Business Analytics is preferred. A Masters Degree in a relevant field may substitute for some required experience.

Compensation & Benefits

Welldoc offers a competitive compensation package which, in addition to salary, includes generous PTO, medical insurance, dental insurance, vision care, life and disability insurance, retirement benefits. and the opportunity to participate in health savings accounts and/or dependent care accounts. While the anticipated salary range for this position is between $110,000 - $130,000/year with the expectation that most candidates will fall around the midpoint of the range. Exceptional candidates may exceed the range if education and experience warrant.

Upon receipt of a conditional offer of employment, you may be required to complete and clear a multi‑panel drug screening process. This screening is in connection with requirements set by certain of the Company’s customers, with which you may be working in this role, and will at all times be administered all applicable laws.

Welldoc is an equal opportunity employerand prohibits discrimination and harassment of any kind. We offer an inclusive workplace and will not tolerate discrimination against any job candidate or employee due to age, race, religion,color, ethnicity, national origin, gender, gender identity/expression, sexual orientation, membership in an employee organization,medical condition, family history, genetic information, veteran status, marital status or parental status.