Sr. Business Intelligence Analyst

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:

CAREER OPPORTUNITY OFFERING:

• Bonus Incentives
• Paid Certifications
• Tuition Reimbursement
• Comprehensive Benefits
• Career Advancement
• This position pays between $101,600- $152,400 based on experience

By embodying our core purpose of customer obsession, new ideas, and driving innovation, and delivering excellence, you will help ensure that every touchpoint is meaningful and contributes to our mission of redefining the possible in healthcare.

The Senior Business Intelligence Analyst turns complex financial and operational data into trusted, decision-ready insight for finance leaders and business partners. Working primarily in Power BI and Databricks, this role designs semantic models, builds executive dashboards and develops the curated data pipelines that feed them. The analyst partners closely with finance, operations and data engineering teams to define metrics, improve data quality, and scale self-service analytics across the organization.

Key responsibilities:

• Design, build and maintain Power BI reports, dashboards and semantic models that support revenue cycle, financial planning, performance management, and executive reporting.
• Develop well-structured Star schema data models and advanced DAX measures, applying industry best practices for performance, row-level security and reusability.
• Build and optimize data transformations in Databricks using SQL and PySpark, delivering curated analytics-ready tables in the Lakehouse (Delta Lake, Unity Catalog).
• Translate business questions from revenue cycle, finance and operational stakeholders into clear requirements, KPI definitions, and analytical solutions.
• Establish data validation and reconciliation checks to ensure accuracy and consistency of reported figures.
• Manage Power BI workspaces, deployment pipelines, refresh schedules, and comply with Ensemble Health Partners governance standards.
• Mentor junior analysts, lead peer reviews and promote BI standards, documentation and self-service adoption and support Power BI report office hours.

Required qualifications:

• Bachelor's degree in Finance, Business Analytics, Computer Science, Information Systems or related fields.
• 5+ years of experience in business intelligence, data analytics, revenue cycle, or financial analytics.
• 3-5 years of advanced Power BI expertise, including semantic data modeling, DAX, M, Power Query and Power BI Service administration.
• Hands-on experience with Databricks, including SQL, notebooks and Delta Lake; working knowledge of PySpark or Python.
• Strong SQL skills and expertise in dimensional (Star schema) and Third Normal Form (3NF) modeling, relational databases, data warehousing concepts.
• Ability to communicate complex findings clearly to executive and non-technical audiences.

Preferred qualifications:

• Experience in healthcare revenue cycle management or finance and FP&A environment heavily preferred.
• Familiarity with Unity Catalog, Databricks Genie, Azure data services, Microsoft Fabric or Git-based CI/CD.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) or Databricks certification.
• 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.

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
• Work-Life Flexibility
• Leadership
• Purpose + Values

Bottom line, we believe in empowering people and giving them the tools and resources needed to thrive. A few of those include:

• 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. Our culture is rooted in collaboration, growth, and innovation.
• Growth – We invest in your professional development. Each associate will earn a professional certification relevant to their 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 TA@ensemblehp.com.

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

Recruitment Fraud Notice

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.

About Us

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.