Analytics Engineer: Semantic Data Modeling & BI (Remote)

Ensemble Health Partners; Ohio; Hybrid; USD 84,000 - 126,000; Full time

Benefits offered by this job

Healthcare coverage

Tuition reimbursement

Professional certifications

Incentive programs

Remote-friendly

Job summary

Ensemble Health Partners is hiring an Analytics Engineer to transform curated data into analytics-ready models and metrics that power dashboards and decision-making across the organization.

You will own semantic layer design, partner with stakeholders, and ensure trusted, well-defined data. Strong SQL and dimensional modeling skills, plus healthcare domain understanding, are essential. This is a remote role with travel to client sites as needed.

Qualifications

• Bachelor’s degree in Computer Science, Data Analytics, Statistics, Mathematics, or equivalent.
• 3+ years in analytics engineering, analytics, BI, or related role.
• Advanced SQL expertise with maintaining complex transformations; dbt experience is a plus.

Responsibilities

• Design and maintain analytics ready data models (facts, dimensions, data marts).
• Develop transformations in the semantic layer using SQL based tooling.
• Define metrics and calculations to ensure consistency across dashboards and reports.
• Apply dimensional modeling best practices for BI consumption.
• Collaborate with product, operations, finance, and stakeholders to translate requirements into data models and metrics.
• Act as steward of business logic with clear, documented definitions across teams.
• Identify gaps or inconsistencies in metrics and drive standardization of definitions.
• Optimize data models for clarity, usability and performance for analysts and BI users.
• Support analysts and BI developers for faster, reliable dashboards and reports.
• Ensure analytics outputs are intuitive, discoverable and trusted by decision-makers.
• Implement data quality checks at the analytics layer.

Skills

Analytics Engineering

SQL

dbt

Dimensional Modeling

Communication

Healthcare domain knowledge

Education

Bachelor’s degree in Computer Science, Data Analytics, Statistics, Mathematics, or related field

Tools

dbt

Job description

Ensemble Health Partners is hiring an Analytics Engineer to transform curated data into analytics-ready models and metrics that power dashboards and decision-making across the organization.

You will own semantic layer design, partner with stakeholders, and ensure trusted, well-defined data. Strong SQL and dimensional modeling skills, plus healthcare domain understanding, are essential. This is a remote role with travel to client sites as needed.