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 involves developing and optimizing Power BI reports, building and maintaining data pipelines, and implementing automation tools.

This role will require both analytical depth and technical expertise in data engineering, business intelligence, and automation. The Senior Engineer, Business Intelligence will develop scalable analytics solutions, automate business processes and reports, and act as an administrator for our Power BI and Azure resources.

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.
• 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.
• Automate recurring report generation and business processes to improve operational efficiency.
• Serve as a Power BI platform administrator, managing permissions, workspace governance, and capacity optimization.
• 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.
•  3–5 years of experience with relational databases and advanced T-SQL.
•  3–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.­­­­

Essential Job Functions:

• Manage big data and create solutions for reporting requirements provided by stakeholders.
• Solve problems and perform root cause analysis on production bugs.
• Follow standard SDLC process and agile practices within a team.
• Develop internal and external partnerships to provide opportunities for efficient so