Ensemble Health Partners is a leading provider of technology-enabled revenue cycle management solutions for health systems. The Senior Analytics Engineer plays a critical role in transforming data into analytics-ready models to support decision-making and reporting across the organization.
Responsibilities:
- 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 (e.g., dbt)
- Define and maintain metrics, business logic, and calculations to ensure consistency across dashboards, reports, and analyses
- Apply dimensional modeling best practices (e.g., star schemas) 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
Requirements:
- Bachelor's degree in Computer Science, Data Analytics, Statistics, Mathematics, or a related field (or equivalent experience)
- 5+ 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 experience with analytics engineering tools (e.g., dbt or similar transformation frameworks)
- 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