Engineer II, Business Intelligence
Ensemble Health Partners · United States
- Hybrid
- Full-time
- $126,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Develop Power BI reports and automate workflows.
- Utilize SQL, DAX, M, and Python for data.
- Collaborate on BI best practices and governance.
- Manage Azure Data Factory pipelines.
- Support Power BI enterprise administration.
About the role
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, defining and performing audit processes, and publishing Power BI reports and apps in accordance with governance standards.
- Own 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.
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.
Compensation
This position pays between $84,000-126,000 based on experience.About Ensemble Health Partners
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.
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.
Key skills/competency
- Business Intelligence
- Power BI
- Automation
- SQL
- DAX
- M (Power Query)
- Python
- Azure Data Factory
- Azure DevOps
- Data Modeling
Skills & topics
- Business Intelligence Engineer
- Power BI
- Automation
- SQL
- DAX
- Python
- Azure Data Factory
- Azure DevOps
- Data Modeling
- Revenue Cycle Management
How to get hired
- Tailor your resume: Highlight your 3+ years in BI, Power BI expertise, SQL, DAX, M, and Python skills. Emphasize automation experience with Power Automate and Azure Data Factory.
- Showcase governance experience: Detail your work with Power BI enterprise governance, compliance, and administration processes. Mention Azure DevOps and Git version control.
- Demonstrate collaboration: Provide examples of working with technical and non-technical stakeholders on BI solutions. Highlight problem-solving and innovation.
- Prepare for technical questions: Be ready to discuss Power BI data modeling, DAX, M, SQL query optimization, and Azure Data Factory pipeline design.
- Research Ensemble's culture: Understand their O.N.E Purpose (Customer Obsession, Embracing New Ideas, Striving for Excellence) and award-winning status.
Technical preparation
Master Power BI report development and data modeling.,Practice SQL, DAX, and M for data manipulation.,Build automation solutions with Power Automate.,Familiarize with Azure Data Factory pipelines.
Behavioral questions
Describe a complex BI challenge you solved.,How do you ensure reporting data compliance?,Share an experience automating a business process.,How do you collaborate with non-technical teams?
Frequently asked questions
- What is the salary range for the Business Intelligence Engineer II role at Ensemble Health Partners?
- The Business Intelligence Engineer II position at Ensemble Health Partners offers a salary range of $84,000 to $126,000 per year, depending on your experience and qualifications.
- Is the Business Intelligence Engineer II position fully remote?
- This Business Intelligence Engineer II position is primarily remote, but candidates must be willing and able to travel to and work onsite at client, temporary, or corporate office locations as business needs require.
- What are the key technical skills required for the BI Engineer II role at Ensemble Health Partners?
- Key technical skills for this role include strong Power BI development, data modeling, SQL, DAX, M (Power Query), Python for data processing, Power Automate for automation, Azure Data Factory, and Azure DevOps. Experience with Git-based version control is also essential.
- What kind of experience does Ensemble Health Partners look for in a BI Engineer II candidate?
- Ensemble Health Partners looks for candidates with at least 3 years of professional experience in Business Intelligence, Analytics Engineering, or Data Engineering, along with demonstrated experience in Power BI enterprise governance and compliance.
- How does Ensemble Health Partners approach professional development for its associates?
- Ensemble Health Partners invests in professional development by offering associates opportunities to earn relevant professional certifications and providing tuition reimbursement for further education.
- What is the O.N.E Purpose at Ensemble Health Partners?
- Ensemble Health Partners' O.N.E Purpose encompasses Customer Obsession (exceeding expectations), Embracing New Ideas (innovation and experimentation), and Striving for Excellence (delivering outstanding results).
- Does Ensemble Health Partners offer benefits for this Business Intelligence Engineer II role?
- Yes, Ensemble Health Partners offers a comprehensive benefits package designed to support the physical, emotional, and financial health of associates and their families, including healthcare, time off, retirement, and well-being programs.
- What is expected in terms of travel for this remote Business Intelligence Engineer II position?
- While this position is remote, candidates should be prepared to travel to and work onsite at client, temporary, or corporate office locations as business needs may arise.