Job Description

BI Engineer
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.


Required Experience
3+ years\xe2\x80\x99 experience with relational databases and advanced T-SQL Experience \xe2\x80\x93 must have the ability to write complex, highly-optimized queries for data cleansing across large volumes of data.
3+ years\xe2\x80\x99 experience developing Power BI reports (with M, SQL, DAX language proficiency)
3+ 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.)
Strong communication, organizational, planning, problem solving, analytical, judgment, and research skills


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.
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\xe2\x80\x99s.
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.
Numbers of Positions:
2