Ensemble Health Partners
Engineer II, Business Intelligence
🇺🇸Ohio, United StatesRemote available3 days ago
From $84,000MidFull Time
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:
Job Summary
The BI Engineer II role will focus on developing and maintaining Power BI reports, automating workflows using Azure and Power Platform tools, and supporting Power BI enterprise governance and compliance. The ideal candidate combines strong technical skills with a solid understanding of reporting best practices, automation, and platform stewardship in a federated BI environment.
This role partners closely with business stakeholders, platform teams, and governance groups to deliver reliable, compliant, and scalable BI solutions.
Key Responsibilities
Design, develop, and maintain Power BI reports with complex data models to meet business requirements
Leverage Power Automate to design and deploy automation solutions for routine business tasks and data workflows
Utilize SQL, DAX, M, and Python to manipulate, analyze, and validate large and complex datasets
Collaborate with cross-functional teams to ensure reporting solutions align with Power BI best practices and governance standards
Design, develop, and maintain YAML-based code stored in Azure DevOps Repos to support automation and data workflows
Build and schedule Azure Data Factory (ADF) pipelines to execute Power BI archival, audit, and compliance processes
Support Power BI enterprise governance and administration, including:
Enforcing owner governance standards across workspaces and reports
Defining and performing audit processes for report, workspace, and semantic model usage
Publishing Power BI reports and apps on behalf of federated teams in accordance with governance standards
Owning workspace, app, and semantic model compliance, including metadata, security, and certification requirements
Partner with BI, platform, and governance stakeholders to identify unused or non-compliant Power BI assets
Monitor, troubleshoot, and optimize Azure Data Factory pipelines and scheduled governance workflows
Maintain documentation and operational runbooks related to Power BI governance and automation
Follow DevOps best practices, including version control, code reviews, and environment-based deployments
Qualifications
3+ years of professional experience in Business Intelligence, Analytics Engineering, or Data Engineering
Strong hands-on experience with Power BI, including report development, data modeling, and workspace management
Working knowledge of SQL, DAX, and Power Query (M); experience with Python for data processing or automation
Experience building automation using Power Automate
Familiarity with Azure DevOps, including Repos and YAML-based code management
Experience working with Azure Data Factory, including pipeline development, scheduling, and monitoring
Demonstrated experience with Power BI enterprise governance, compliance, or administrative processes
Understanding of BI best practices related to security, performance, and lifecycle management
Experience using Git-based version control and participating in code reviews
Strong collaboration and communication skills when working with technical and non-technical partners
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.
Preferred Qualifications
Experience in a federated or enterprise-scale Power BI environment
Exposure to Power BI REST APIs, service principals, or tenant-level administration
Familiarity with data governance, audit, or compliance programs
Azure or Power Platform certifications
This position pays between $84,000-126,000 based on experience
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, and time in position. A candidate's entry rate of pay does not typically fall at the minimum or maximum of the role’s range.
#LI-MT1
#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
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.
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.
