> Markdown version of [/jobs/ext/4704750-sr-business-intelligence-analyst](https://www.wearedevelopers.com/jobs/ext/4704750-sr-business-intelligence-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr. Business Intelligence Analyst

- **Company:** Ensemble RCM LLC
- **Location:** Sharonville, OH, United States (Remote available)
- **Experience:** Expert
- **Salary:** $101,600 - $152,400
- **Contract:** Permanent contract
- **Skills:** Third Normal Form, Artificial Intelligence, Information Systems, Continuous Integration, Data Validation, Information Engineering, Data Warehousing, Relational Databases, Database Queries, Python (Programming Language), Operational Data Store, Power BI, SQL Databases, Azure Data Factory, Git, Powerquery, Microsoft Fabric, Data Lakes, Pyspark, Information Technology, Data Analytics, Star Schema, Data Pipelines, Databricks
- **Published:** November 13, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=ae7b025fa5184367

## About the Role

* 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., * 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., 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.

## Description

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., * 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.