14 days ago
Remote, United StatesMid Level

Base Salary

$84k - $126k/yr

Responsibilities

  • Design, build, and maintain analytics-ready facts, dimensions, data marts, and other data models.
  • Develop and manage SQL-based transformations in the semantic and transformation layers using dbt.
  • Define, document, and maintain consistent metrics, business logic, calculations, and semantic-layer standards.
  • Apply dimensional modeling practices optimized for BI and analytical consumption.
  • Partner with product, operations, finance, business, analyst, BI, and data engineering stakeholders.
  • Identify and resolve gaps, ambiguities, and inconsistencies in metric definitions.
  • Optimize models for clarity, usability, performance, discoverability, and trusted self-service consumption.
  • Support dashboard, reporting, and ad hoc analysis development for analysts and BI developers.
  • Implement analytics-layer data quality checks and testing.
  • Contribute to analytics engineering conventions, documentation, and source-data readiness feedback.

Requirements

  • Bachelor’s degree in Computer Science, Data Analytics, Statistics, Mathematics, or a related field, or equivalent experience.
  • At least 3 years of experience in analytics engineering, analytics, business intelligence, or a related role.
  • Advanced SQL expertise and experience building complex, maintainable transformations.
  • Hands-on experience with dbt.
  • Strong understanding of dimensional modeling, metrics design, and semantic-layer concepts.
  • Experience supporting BI tools and downstream dashboards, reporting, and ad hoc analysis.
  • Clear communication skills with technical and non-technical stakeholders.
  • Healthcare-related operations experience and familiarity with industry processes and terminology.
  • Product or application engineering experience is preferred.
  • Must demonstrate inquisitiveness and openness to innovation, including AI.

Benefits

  • Comprehensive benefits include healthcare, time off, retirement, and well-being programs.
  • Remote work is available, with required travel to and work at client, temporary, or corporate offices as business needs require.
  • Professional development includes earning a relevant professional certification and access to tuition reimbursement.
  • Quarterly and annual incentive programs are available for eligible employees.
  • The company emphasizes collaboration, growth, innovation, work-life flexibility, and recognition.

Tech Stack

dbtSQL

Categories

Data Engineering
Ensemble Health Partners

About Ensemble Health Partners

5,001-10,000 employees

Ensemble Health Partners builds and delivers technology-enabled revenue cycle management services for hospitals, health systems, and affiliated physician groups, spanning end-to-end outsourcing and targeted point solutions. Its offerings include RCM operations, assessments, revenue recovery, and support for Epic and other EHR platforms. Founded in 2014 and headquartered in Cincinnati, the privately held company is backed by Golden Gate Capital and partners with health systems nationwide.

Contact me