Analytics Engineer

Ensemble RCM LLC; 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

Thank you for considering a career at Ensemble! Ensemble is a leading provider of technology-enabled revenue cycle management solutions for health systems, including hospitals and affiliated physician groups. They offer end-to-end revenue cycle solutions as well as a comprehensive suite of point solutions to clients across the country. Ensemble keeps communities healthy by keeping hospitals healthy. We recognize that healthcare requires a human touch, and we believe that every touch should be meaningful. This is why our people are the most important part of who we are. By empowering them to challenge the status quo, we know they will be the difference!

O.N.E Purpose:

Customer Obsession: Consistently provide exceptional experiences for our clients, patients, and colleagues by understanding their needs and exceeding their expectations. Embracing New Ideas: Continuously innovate by embracing emerging technology and fostering a culture of creativity and experimentation. Striving for Excellence: Execute at a high level by demonstrating our "Best in KLAS" Ensemble Difference Principles and consistently delivering outstanding results.

The Opportunity: Position Overview

The Analytics Engineer plays a critical role in transforming curated data into clear, consistent, and analytics ready‑ data models that power reporting, dashboards, and decision-making‑ across the organization. This role sits at the intersection of data engineering, analytics, and the business—owning the semantic layer, partnering closely with stakeholders, and ensuring that metrics are trusted, well-defined‑, and easy to use. The ideal candidate is deeply skilled in SQL based transformations and dimensional modeling, has strong business acumen, and is passionate about enabling analysts and leaders with high-quality, intuitive data.

Essential Job Functions

• 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.

Qualifications

Required Skills & Experience

• 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.

This position pays between $84,000 - $126,000 based on experience.

Must be inquisitive and demonstrate openness to innovation including AI to explore better processes and ways to alleviate friction and improve patient and client experiences. This is a remote position; however, candidates must be willing and able to travel to and work onsite at client, temporary, or corporate office locations as business needs require. #LI-SA1 #LI-REMOTE

Join an award-winning company

• Five-time winner of "Best in KLAS" 2020-2022, 2024-2025
• Black Book Research's Top Revenue Cycle Management Outsourcing Solution 2021-2024
• 22 Healthcare Financial Management Association (HFMA) MAP Awards for High Performance in Revenue Cycle 2019-2024
• Leader in Everest Group's RCM Operations PEAK Matrix Assessment 2024
• Clarivate Healthcare Business Insights (HBI) Revenue Cycle Awards for strong performance 2020, 2022-2023
• Energage Top Workplaces USA 2022-2024
• Fortune Media Best Workplaces in Healthcare 2024
• Monster Top Workplace for Remote Work 2024
• Great Place to Work certified 2023-2024
• Innovation

Bottom line, we believe in empowering people and giving them the tools and resources needed to thrive.

• Associate Benefits – We offer a comprehensive benefits package designed to support the physical, emotional, and financial health of you and your family, including healthcare, time off, retirement, and well‑being programs.
• Our Culture – Ensemble is a place where associates can do their best work and be their best selves. We put people first, last and always.
• Growth – We invest in your professional development. Each associate will earn a professional certification relevant to your field and can obtain tuition reimbursement.
• Recognition – We offer quarterly and annual incentive programs for all employees who go beyond and keep raising the bar for themselves and the company.

Ensemble is an equal employment opportunity employer. It is our policy not to discriminate against any applicant or employee based on race, color, sex, sexual orientation, gender, gender identity, religion, national origin, age, disability, military or veteran status, genetic information or any other basis protected by applicable federal, state, or local laws. Ensemble also prohibits harassment of applicants or employees based on any of these protected categories.

Due to business, operational, payroll, and regulatory requirements, this position is limited to individuals who reside and are authorized to work within the United States. Applications generated from outside the United States will not be considered. Individuals may reapply when located within the United States.

Ensemble provides reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local law. If you require accommodation in the application process, please contact [e-mail].

This posting addresses state specific requirements to provide pay transparency. Compensation decisions consider many job-related factors, including but not limited to geographic location; knowledge; skills; relevant experience; education; licensure; internal equity; time in position. A candidate entry rate of pay does not typically fall at the minimum or maximum of the role’s range.

Employment Disclaimers – Ensemble Legitimate Ensemble Recruiters will only contact you from an email address ending in "@ensemblehp.com." Don’t fall victim to fake job postings from fraudsters posing as Ensemble Human Resources personnel. Ensemble will never ask for a payment in exchange for a job opportunity or ask you to submit sensitive personal information via email, phone, form, app or text.

Ensemble is dedicated to providing our clients with experienced healthcare finance and revenue cycle professionals. We believe that our core values of trust, integrity, loyalty and service married with the belief that our work is worthwhile helps us build and sustain sincere relationships with our associates and clients. If you are a passionate, dedicated and experienced revenue cycle, consulting or finance professional and seek career and personal growth, we would love to hear from you. We believe we foster an environment where talented individuals can excel and shine. Our team believes that people are the most important part of our success and that when we take care of our people, they pay it forward by providing our clients with excellent results and world‑class service.