Ensemble Health Partners

Senior Analytics Engineer

Ensemble Health Partners

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

SQL

About the role

  • 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.
Benefits
  • Health insurance
  • Time off
  • Retirement programs
  • Professional development opportunities
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLdimensional modelingdata modelingdata transformationsmetrics designdata quality checksanalytics engineeringbusiness intelligencesemantic layer conceptsreport development
Soft Skills
communicationcollaborationproblem-solvingstakeholder managementdocumentationattention to detailproactive identification of issuesalignment facilitationclarity in definitionssupporting analysts
Certifications
Bachelor’s degree in Computer ScienceBachelor’s degree in Data AnalyticsBachelor’s degree in StatisticsBachelor’s degree in Mathematics