Summary

BASIC FUNCTION AND RESPONSIBILITY

The Business Intelligence Analyst provides advanced technical and analytic support for strategic and clinical initiatives in the adult and pediatric clinical documentation improvement (CDI) space.  Utilizing numerous types of data, both modeled and disparate, this analyst will produce relevant, timely analytics for presentation to management that is essential for strategic decision-making related to clinical documentation improvement.

The analyst applies 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 Revenue Cycle, Data Warehouse, Clinical, and Finance to provide insights for adult and pediatric hospital financial 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.

Mission Statement

Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally.  Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.

Responsibilities*

SPECIFIC DUTIES AND 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 develops 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 owners/stewards to improve data quality where possible.
• Develops 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 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, PHIS and CMS benchmarking

Skills You Have

COMPETENCIES

• Advanced SQL skills (coding language)
• Advanced Microsoft Office Skills including Excel, Access and PowerPoint
• Excellent written and oral communication skills
• Ability to synthesize large sets of data from multiple, seemingly unrelated sources
• General understanding of ICD-10, CPT, EM, and MS-DRG and APR-DRG grouping logic
• Strong analytical skills, with the ability to perform complex analysis and make recommendations (identify opportunities) based on statistical inferences and document and present to leadership
• Ability to complete projects on or ahead of schedule with an outcome that meets or exceedsinternal customers with minimal guidance from manager
• Able to multi-task, and work effectively under pressure
• Understand clinical and financial concepts necessary to manage department information sources
• Ability to extract internal customer’s requirements while assessing if the requested criteria will lead to the expected outcome. This demonstrates an analyst’s ability to see the bigger picture and ask relevant, strategic questions.
• Effective presentation of reporting and analytic results using a variety of tools to all levels of staff and management
• Detail-oriented with passion to understand data to ensure accuracy
• Self-motivated and resourceful, with a demonstrated ability to think and work independently
• High level of integrity as demonstrated by 1) ability to maintain confidentiality as appropriate, 2) adherence to policies, procedures, rules, and regulations, 3) professional behavior in workplace interactions/relationships, and 4) strong work ethic and pursuit of excellence in all assignments completed

Required Qualifications*

• A Bachelor’s degree in Finance, Health Informatics, Statistics, Mathematics or related field.
• At least five years’ experience in data analysis and modeling of Healthcare or Population Health data. 
• Experience using data visualization methods such as Tableau
• Clarity Proficiency/ Certified with Epic and certification in the Children’s Hospital Association Pediatric Health Information System (PHIS) Report Writing within one year from hire date.
• Exceptional analytical, verbal and written communication, computer, and interpersonal skills.
• Strong presentation skills and a track record of ability to present to senior leadership.
• Proficient analysis tools for extraction and manipulation of data.
• Ability to interpret clinical data, write reports, and effectively present data and analyses.
• Knowledge of business and management principles as it relates to finance and strategic planning.
• Demonstrated customer focus and the knowledge and skill to identify, meet, and evaluate customer expectations. Broad customer service experience.
• Logical, analytical, and organized with the ability to direct and reprioritize work quickly and efficiently.
• Ability to work in a fast-paced environment under multiple pressures and deadlines.

Additional Information

• The mission of Michigan Medicine is to improve the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally.  With annual revenues of over $3 billion, Michigan Medicine ranks as one of the top academic health centers in the country, and is committed to providing exceptional patient care, facilitating groundbreaking research and developing the next generation of physicians and scientists.  Michigan Medicine consists of the University of Michigan Health System (UMHS), the University of Michigan Medical School and its Medical Group, and the Michigan Health Corporation.
• Michigan Medicine generates nearly $3.0 billion in annual patient care revenue from over 1,000 licensed beds and 130+ clinics. In the most recent fiscal year, patient activity totaled 46,000 inpatient discharges and almost 2 million outpatient visits.  The UMHS and Medical School operate 80+ accredited GME programs which combined represents the 3rd largest program in the country based on number of residents and fellows.  Michigan Medicine also receives nearly $550 million in annual research awards including several hundred projects each year in clinical and translational research.
• Michigan Medicine Finance serves as the central finance group for Michigan Medicine and is comprised of six functional areas:  Clinical Financial Planning & Analysis, Enterprise Financial Reporting & Forecasting, Academic Financial Planning & Analysis, Reimbursement, Medical School Finance, and Financial Systems. 
• Administrative supervision from Director of Inpatient Facility Coding, CDI, and Cancer Registry, functional supervision from Medical Director of CDI and the C.S. Mott & Von Voitlander Medical Director for Revenue Integrity.

Background Screening

• Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings.  Background screenings are performed in compliance with the Fair Credit Report Act.

Application Deadline

• Job openings are posted for a minimum of seven calendar days. This job may be removed from posting boards and filled any time after the minimum posting period has ended.

Vaccine Requirements

COVID-19 vaccinations are required for all students, faculty and staff working in the following areas: Michigan Medicine including the Medical School, Dental School, University Health Service or the Mary A. Rackham Institute.  This includes those working remotely and temporary workers.   More information on this new policy is available on the U-M Health Response.

U-M EEO/AA Statement

• The University of Michigan is an equal opportunity/affirmative action employer,