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.

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 work spaces, 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…