"Alerted.org

BUSINESS INTELLIGENCE ANALYST - CDI

Job Summary

BASIC FUNCTION AND RESPONSIBILITY

The Clinical Information 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 Data Warehouse, Revenue Cycle Mid Service, 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.

Responsibilities*

SPECIFIC DUTIES AND RESPONSIBILITES

+ 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 operations related to C.S. Mott & Von Voigtlander Hospitals.

+ Build models and analyze data to identify 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.

+ Independently identifies gaps and opportunities within data sets, interprets results and proposes counter measures to improve those results.

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

+ 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 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, Pediatric Health Information System (PHIS) and Center for Medicare & Medicaid Services (CMS) benchmarking.

Skills You Have

+ 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 and CPT code sets, Elixhauser Diagnoses, risk modeling (ex. Vizient and PHIS) and MS-DRG and APR-DRG grouping logic

+ Strong analytical skills, with the ability to perform complex analysis, identify gaps and opportunities, and make recommendations 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 exceeds internal customers? expectations 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 the 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 within one year from hire date.

+ Certification in the Children?s Hospital Association 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.

+ The ability to work in a fast-paced environment under multiple pressures and deadlines.

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 thework modes (https://hr.umich.edu/working-u-m/my-employment/ways-we-work-resource-center/ways-we-work-implementation-group/modes-work) .

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

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. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.

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.

Job Detail

Job Opening ID

268382

Working Title

BUSINESS INTELLIGENCE ANALYST - CDI

Job Title

BI Analyst Senior

Work Location

Michigan Medicine - Ann Arbor

Ann Arbor, MI

Modes of Work

Mobile/Remote

Full/Part Time

Full-Time

Regular/Temporary

Regular

FLSA Status

Exempt

Organizational Group

Exec Vp Med Affairs

Department

MM Rev Cycle (PTO)

Posting Begin/End Date

9/08/2025 - 9/22/2025

Career Interest

Administration