Sr Engineer, Business Intelligence

Thank you for considering a career at Ensemble Health Partners!

Ensemble Health Partners 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:

The Senior Engineer, Business Intelligence plays a pivotal role in transforming complex data into actionable insights. This position requires both technical depth and forward-thinking innovation, combining BI and data engineering with the emerging domain of Agentic AI.
This role involves developing and optimizing power BI solutions, building and maintaining pipelines and Databricks, automating workflows, and embedding autonomous AI agents into business intelligence processes to enable proactive, self-service analytics and intelligent alerting.

Key Responsibilities:

• Design, develop, and maintain Power BI reports with complex data models to meet business requirements.
• Develop, test, deploy, monitor, and maintain scalable data pipelines using Azure Data Factory, Databricks, and Python to ingest, transform, and store data efficiently.
• Integrate and deploy Agentic AI capabilities - including copilots, LLM powered insights, and autonomous agents into dashboards and data workflows to improve user interaction, insight discovery and actionability.
• Partner with BI leaders to develop specific agents that perform reasoning, prompt orchestration and contextual data analysis within BI platforms.
• Perform root cause analysis on data discrepancies and production issues, ensuring data integrity and accuracy.
• Create, manage, and optimize tables within Azure Databricks for use across BI platforms.
• Leverage Power Automate to design and deploy automation solutions for routine business tasks and data workflows.
• Utilize advanced SQL, DAX, and M language skills to manipulate and analyze large datasets.
• Provide mentorship to junior engineers by providing technical guidance on best practices and contribute to knowledge sharing and process improvement initiatives.
• Collaborate with cross-functional teams to ensure requirements are clear and deliver data-driven solutions.
• Implement and follow standard SDLC processes and agile methodologies.
• Engage in continuous improvement initiatives to enhance reporting capabilities and data quality.
• Leverage Databricks and Visual Studio Code for data engineering tasks and workflow automation.

Qualifications:

• Bachelor’s degree in computer science, Information Systems, or a related field.
• 5+ years of experience with relational databases and advanced T-SQL.
• 5+ years of experience developing Power BI reports with proficiency in DAX and M languages.
• 3+ years of experience with ETL processes and best practices and Azure data warehouse concepts, including Azure Databricks and Azure Data Factory.
• 2+ years of experience with Power Automate and automation tools.
• Hands-on experience in Visual Studio Code, Git, and CI/CD pipelines.
• Experience in platform administration (Power BI and Azure) including provisioning, monitoring, and policy enforcement.
• Proficiency in Python for data engineering tasks.
• Experience with tools such as DAX Studio, Performance Analyzer, and Vertipaq.
• Excellent problem-solving, analytical, and communication skills.­­­­
• Healthcare or revenue cycle management experience is strongly preferred.­­­­

Preferred Skills

• Exposure to cloud-native AI platforms (Azure Open AI, Azure ML, Prompt Flow)
• Experience with integrating vector databases, embedding models or LLM -based Q&A systems into Dashboards.
• Familiarity with dbt, Delta Lake, Azure Synapse or semantic models.
• Experience mentoring team members and leading cross functional projects.
• This position pays between $91,400-175,200 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; time in position.  A candidate entry rate of pay does not typically fall at the minimum or maximum of the role’s range.

#LI-BT1

#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 Health Partners 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 Health Partners also prohibits harassment of applicants or employees based on any of these protected categories.

Ensemble Health Partners 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 [email protected].

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.

EEOC – Know Your Rights
FMLA Rights - English

La FMLA Español

E-Verify Participating Employer (English and Spanish)

Know your Rights