Senior Engineer, Business Intelligence

Ensemble Health Partners; Ohio; Hybrid; USD 91,000 - 175,000; Full time

Job summary

Ensemble Health Partners is seeking a Senior Business Intelligence Engineer to translate complex data into actionable insights for decision-makers. The role emphasizes Power BI report development, data modeling, and collaboration with stakeholders across health systems.

Responsibilities include optimizing data workflows, mentoring developers, and aligning data capabilities with business objectives. This remote role may involve travel to client sites as needed, and requires strong experience in

Qualifications

• 3-5 years experience with relational databases and advanced T-SQL.
• 3-5 years experience developing Power BI reports (with M, SQL, DAX language proficiency).
• 5+ years of healthcare revenue cycle experience required.
• 1+ years of knowledge and/or experience with ETL and Azure data warehouse concepts and processes.

Responsibilities

• Develop internal and external partnerships to provide opportunity for efficient solutions to various data, system and application uses.
• Lead the evaluation of what current and future data needs are and translates needs to stakeholders and product owners to support all lines of business.
• Leads high level discussions with a focus on making recommendation and identifying how data can support key business decisions.
• Collect, organize, and disseminate significant amounts of information with attention to detail and accuracy through Power BI report development.
• Responsible for the data mining, manipulation and delivery to key stakeholders and executives in accordance with priorities and deadlines.
• Presenting and/or publishing completed reports in accordance with publishing guidelines.

Skills

Relational Databases

SQL Queries

Power BI

DAX

Azure Data Warehouse

M Language

Dax Studio

Performance Analyzer

Vertipaq

Tabular Editor

Azure Databricks

API Integration

Power Apps integration

Tools

Azure Databricks

Power BI

Job description

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

The Senior Business Intelligence Engineer solves complex business problems and issues using data from internal and external sources to provide insight to decision-makers. The Senior Business Intelligence Engineer works assignments involve moderately complex to complex issues where the analysis of situations or data requires an in-depth evaluation of variable factors.

Essential Job Functions

• Ability to manage big data and creating solutions for reporting requirements provided by stakeholders.


• Problem solving and completing root cause analysis on production bugs.


• Following standard SDLC process and agile practices within a team.


• Develop internal and external partnerships to provide opportunity for efficient solutions to various data, system and application uses.


• Serves as a technical resource and mentor to other developers / Engineers and aids in trouble shooting and resolving issues.


• Actively review new bugs reported and complete grooming and sprint planning.


• Complete bug root cause analysis and work with other teams as needed to resolve issues and completes documentation and notification to the bug reporter at least twice per week.


• Subject matter expert (SME) of report data modeling as well as being knowledgeable about what each field is used for and is able to determine appropriate uses of data fields to create reporting.


• Advanced knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, Visual Studio, etc.


• Has advanced programming and optimizing skills in DAX, Dax Studio, Performance Analyzer, Vertipaq, SQL and M Languages.


• Collect, organize, and disseminate significant amounts of information with attention to detail and accuracy through Power BI report development.


• Responsible for the data mining, manipulation and delivery to key stakeholders and executives in accordance with priorities and deadlines.


• Ability to form key relationships with and deliver professional, customer focused service to key stakeholders and executives.


• Leads the evaluation of what current and future data needs are and translates needs to stakeholders and product owners to support all lines of business.


• Leads high level discussions with a focus on making recommendation and identifying how data can support key business decisions.


• Identifies report requirements and determine how the desired results can be achieved.


• Responsible for developing and maintaining strategic reports out of multiple databases and systems.


• Completing systems validation for client data which identifies discrepancies in data totals or PK’s.


• Works with team members as mentor and provides opportunities of open collaboration to problem solve or optimize reports.


• Practical application experience with Dax Studio and Performance Analyzer and can optimize reporting based on analysis findings.


• Completing code review / peer review of completed work by co-developers and providing feedback identifying issues or required report updates to meet the requirements ahead of the report moving to UAT.


• Presenting and/or publishing completed reports in accordance with publishing guidelines.

Required Experience

• 3-5 years experience with relational databases and advanced T-SQL.


• Experience – must have the ability to write complex, highly-optimized queries for data cleansing across large volumes of data.


• 3-5 years experience developing Power BI reports (with M, SQL, DAX language proficiency).


• 5+ years of healthcare revenue cycle experience required.


• 1+ years of knowledge and/or experience with ETL and Azure data warehouse concepts and processes (Experience with Azure Databricks is a plus.).


• Building and maintaining API’s.


• Advanced Vertipaq, Dax Studio, Tabular editor experience.


• Advanced SQL concepts and validation review between data source and report output.


• Power Apps integration.


• Excellent communication, organizational, planning, problem solving, analytical, judgment, and research skills.


• Ability to own and resolve problems.


• 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.

Wage

This position pays between $91,400 - $175,200 based on experience.

Location

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.

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.

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.

Culture & Values

Bottom line, we believe in empowering people and giving them the tools and resources needed to thrive. A few of those include: invest in your professional development, earn a professional certification relevant to your field and 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.

Eligibility & Accommodations

Due to business, operational, payroll, and regulatory requirements, this position is limited to individuals who reside and are authorized to work within the United States. Applications generated from outside the United States will not be considered. Individuals may reapply when located within the United States. 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 [e-mail].

Equal Employment Opportunity

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.

Application Closing

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.

We believe that our core values of trust, integrity, loyalty and service married with the belief that our work is worthwhile helps us build and sustain sincere relationships with our associates and clients. If you are a passionate, dedicated and experienced revenue cycle, consulting or finance professional and seek career and personal growth, we would love to hear from you. We believe we foster an environment where talented individuals can excel and shine. Our team believes that people are the most important part of our success and that when we take care of our people, they pay it forward by providing our clients with excellent results and world-class service.