Remote Analytics Engineer - Semantic Layer & BI

Ensemble Health Partners; Columbus (OH); Teletrabalho; USD 84 000 - 126 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Healthcare benefits

Tuition reimbursement

Professional development

Resumo da oferta

Ensemble Health Partners is seeking an Analytics Engineer to transform curated data into analytics-ready models and semantic layer definitions. You will partner with product, operations, and finance to design facts, dimensions, and data marts, ensuring trusted metrics across dashboards and reports.

The ideal candidate has deep SQL and dbt experience, strong business acumen, and is comfortable communicating with technical and non-technical stakeholders in a healthcare context.

Qualificações

• Bachelor's degree in Computer Science, Data Analytics, Statistics, Mathematics, or a related field (or equivalent experience).
• 3+ years of experience in analytics engineering, analytics, business intelligence, or a related role.
• Advanced SQL expertise, with a strong track record of building complex, maintainable transformations.
• Hands-on dbt experience.
• Product or application engineering experience is a plus, with an understanding of both data and how it's used in product and engineering applications.
• Strong understanding of dimensional modeling, metrics design, and semantic layer concepts.
• Experience supporting BI tools and downstream analytics use cases (dashboards, reporting, ad hoc analysis).
• Ability to communicate clearly with both technical and non-technical stakeholders.
• Experience in healthcare-related operations, with an understanding of industry processes and terminology.

Responsabilidades

• Design, build, and maintain analytics ready- data models, including facts, dimensions, and data marts.
• Develop and manage transformations primarily in the semantic and transformation layer using SQL based tooling.
• Define and maintain metrics, business logic, and calculations to ensure consistency across dashboards, reports, and analyses.
• Apply dimensional modeling best practices optimized for BI and analytical consumption.
• Partner closely with product, operations, finance, and business stakeholders to understand requirements and translate them into well-defined- data models and metrics.
• Act as a steward of business logic—ensuring definitions are clear, documented, and aligned across teams.
• Proactively identify gaps, ambiguities, or inconsistencies in metrics and drive alignment toward standardized definitions.
• Optimize data models for clarity, usability, and performance for downstream consumers, including analysts and self-service- BI users.
• Support analysts and BI developers by enabling faster, more reliable dashboard and report development.
• Ensure analytics outputs are intuitive, discoverable, and trusted by decision-makers.
• Implement data quality checks and testing at the analytics layer to ensure accuracy and reliability.
• Contribute to analytics engineering standards, conventions, and documentation.
• Collaborate with data engineering partners to provide feedback on source data structure and readiness for analytics.

Conhecimentos

Advanced SQL

dbt

Business acumen

Stakeholder communication

Formação académica

Bachelor's degree in CS / Data Analytics / Statistics or related field

Ferramentas

dbt

Descrição da oferta de emprego

Ensemble Health Partners is seeking an Analytics Engineer to transform curated data into analytics-ready models and semantic layer definitions. You will partner with product, operations, and finance to design facts, dimensions, and data marts, ensuring trusted metrics across dashboards and reports.

The ideal candidate has deep SQL and dbt experience, strong business acumen, and is comfortable communicating with technical and non-technical stakeholders in a healthcare context.