Engineer II, Business Intelligence jobs in United States
cer-icon
Apply on Employer Site
company-logo

Ensemble Health Partners · 12 hours ago

Engineer II, Business Intelligence

Ensemble Health Partners is a leading provider of technology-enabled revenue cycle management solutions for health systems. The BI Engineer II will design, implement, and maintain systems for collecting and analyzing business intelligence data, creating dashboards and databases to enable efficient data evaluation.

Health CareHospitality

Responsibilities

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
Drive the development and analysis of data, reporting automation, Dashboarding, and business intelligence programs
Develop a deep understanding of systems and processes in order to extract insights from existing data leveraging agile practices to ensure the highest possible quality of delivery
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
Explain reports to team members regarding the subject matter of each report as well as the architecture used to put it together
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
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
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

Qualification

Power BIT-SQLData analysisETL processesAzure data warehouseHealthcare experienceData miningAnalytical skillsProblem solvingCommunication skillsOrganizational skills

Required

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
Drive the development and analysis of data, reporting automation, Dashboarding, and business intelligence programs
Develop a deep understanding of systems and processes in order to extract insights from existing data leveraging agile practices to ensure the highest possible quality of delivery
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
Explain reports to team members regarding the subject matter of each report as well as the architecture used to put it together
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
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

Preferred

3-5 Years of related experience
Bachelors Degree or Equivalent Experience
3+ 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+ years experience developing Power BI reports (with M, SQL, DAX language proficiency)
3+ years of healthcare experience required, Revenue Cycle experience preferred
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
Advanced SQL concepts and validation review between data source and report output

Benefits

Healthcare
Time off
Retirement
Well-being programs
Professional certification relevant to their field
Tuition reimbursement
Quarterly and annual incentive programs

Company

Ensemble Health Partners

company-logo
Ensemble Health Partners is the leading revenue cycle management company for hospitals, health systems and physician practices.

Funding

Current Stage
Late Stage
Total Funding
unknown
2022-03-25Private Equity
2019-05-30Acquired

Leadership Team

leader-logo
Judson Ivy
Founder and CEO
linkedin
leader-logo
Matt Tormey
EVP Compliance and Risk
linkedin
Company data provided by crunchbase