Job Summary
As a Business Intelligence Analyst Senior, you will help manage and report on key metrics for the Revenue Cycle Mid-Service CDIS team as well as Children?s and Woman?s Hospital at Michigan Medicine. You'll collect, organize, and analyze data to help leaders make informed strategic decisions and improve clinical processes. You'll design dashboards and reports, and ensure data is accurate. You will apply statistical techniques and quantitative methods in reviewing data and modeling to investigate the distribution of various clinical conditions. This includes developing scorecards, benchmarking studies, and integrated ad hoc analyses focused on improving patient outcomes, quality and revenue improvement.
In addition to analytic skills, this role requires experience in integrating and preparing large, varied datasets from multiple data sources and consolidating the data to be able to draw conclusions from the data to support and communicate results with clinical and operational stakeholders. The role contributes and participates with other teams including HIM, Data Warehouse, Revenue, and Finance to provide insights for strategic initiatives to senior leaders across the system. Supports analytic design, data collection, and measure reporting in accordance with national and professional society standards and support various clinical initiatives.
Responsibilities*
- Gathering and integrating data from disparate sources (i.e. cost and claims or clinical data in the electronic health record) in support of revenue cycle and health information management operations.
- Build models and analyze data to unearth health encounter trends and patterns
- Analyze and interpret medical utilization data and costs, identifying new metrics for measuring results as well as monitoring current metrics for trends.
- Ensures that all analysis is actionable for business owners; enabling leaders of key areas to build, implement and identify solutions to address business performance gaps.
- Create measurements and reporting of participation in population health, medical management, and quality programs, and develop strategies to grow and improve results, as appropriate.
- Identifies and addresses expected and unforeseen data issues to ensure the accuracy of analytics, ensuring that resulting business decisions are made from accurate findings. In addition,
- The analyst will work with the data owner/stewards to improve data quality where possible.
- Develop dashboards and visualizations in Tableau for Michigan Medicine leadership.
- Design and summarize conclusions gained from analyzing data using statistical tools like Microsoft Excel and Access, SQL, SAS and others.
- Conduct regression analysis.
- Advanced Reasoning required in order to interpret the variables, driving factors and necessary conclusions as can be gathered from large data outputs
- Effectively communicates and presents all relevant findings to leadership.
- Works with external data sources such as Vizient and CMS benchmarking
Required Qualifications*
- Bachelor's degree in finance, statistics, mathematics, health informatics, computer science, or a similar field, or an equivalent combination of education and experience.
- At least five years' experience in data analysis and modeling of Healthcare or Population Health data.
- Strong skills in analytics, math, statistics, and quantitative methods.
- Excellent communication skills, both written and verbal.
- Experience using data visualization methods such as Tableau
- Clarity Certified with Epic, or able to earn cert within one year of hire
- Strong teamwork and interpersonal skills, working well with leaders, colleagues, and other departments.
- Ability to adapt to changing priorities and work in a fast-paced environment.
- Experience with data manipulation and extraction.
- At least five years of experience writing SQL queries for Oracle databases, and programming with PL/SQL.
- At least five years of experience creating reports or queries using tools like Crystal Reports, Oracle OBIEE, Hyperion Reporting, Business Objects, or similar.
- Experience working with healthcare clinical and financial data.
- Advanced knowledge and experience (1-3 years) with Microsoft Office applications.
Modes of Work
Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
Additional Information
This position may be underfilled at a lower classification depending on the qualifications of the selected candidate
SUPERVISION RECEIVED
Administrative supervision from Director of IP Coding/CDI, functional supervision from Medical Director of CDI and the C.S. Mott & Von Voigtlander Medical Director for Revenue Integrity.
Application Deadline
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
U-M EEO Statement
The University of Michigan is an equal employment opportunity employer.