BI Analyst Senior

Apply Now

How to Apply

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

Summary

The Business Intelligence Analyst Senior, designs, develops and maintains reports, graphs, dashboards and portal interfaces appropriate for audiences throughout Michigan Medicine. They manage and/or administer the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction for complex reporting and analyses. As part of this role the BIA gathers, analyzes and interprets data to identify opportunities to display information that will enhance the ability for report recipients to identify issues and improve the quality of care in the inpatient and ambulatory settings. This position works with the analytic and data management staff to mine and manipulate internal and external, clinical and administrative data from a variety of databases for the purpose of measuring processes and outcomes of care, medical and disease management, assessment of physician practice patterns and case management.  With Leads and clients, Senior Analysts design report formats and graphical representations of data to present findings in an actionable manner.  Senior Analysts develop detailed timelines and resource plans, define requirements, identify risks, create project documentation, report status to team and stakeholders, track and escalate issues.  They help to lead and train Intermediate and Associate staff.  Analysts utilize data extraction and reporting tools (SQL, R and Tableau) to analyze information, summarize findings, recommendations and next steps. 

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.

Why Join Michigan Medicine?

Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world’s most distinguished academic health systems.  In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.

What Benefits can you Look Forward to?

  • Excellent medical, dental and vision coverage effective on your very first day
  • 2:1 Match on retirement savings

Responsibilities*

Reporting: (40%)

  • Design report formats and graphical representations of data intended for audiences ranging from senior leaders and clinicians to the general public
  • Deliver graphical presentations (dashboards, reports, portal interfaces) of provider, product, program, and service specific data to internal staff, clinicians, UMHS leaders, relevant committees, and other constituencies.
  • Develop and maintain supporting documentation of measurement methods and algorithms, data sources and reporting processes.
  • Conceptualize and develop cross-functional client/unit strategic objectives, business processes, and initiatives that drive or increase organizational value.
  • Work with the clinical information analysts, data managers and business systems analysts to plan and implement the data management and analysis of products and programs, including definition of data requirements, data capture and storage, analyses required to measure and evaluate performance, and reporting needs.
  • Lead and guide business process improvement discussions leading to advice on potential problem resolutions including gathering the support and resources for BI initiatives.
  • Manage cross functional unit projects and/or teams which include project planning, task management, status reporting, etc.

Data Support: (40%)

  • Review reports and analyses.  Test datasets.
  • Extract data for reporting from departmental and EMR sources.  Administer the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction needed for reporting.
  • Define and help create mechanisms to extract and reorganize data from existing systems for storage and reporting in departmental databases
  • Participate in the development of communication related to the analysis, interpretation, and dissemination of health services data.
  • Work with team members and DM team to identify and automate tools that deliver routine performance information.
  • Automate the data extract and maintenance of dashboards, support other BIAs when they are on PTO
  • Maintain on-going reporting for the dashboards and reports developed in this role and by others.
  • Maintain communication with technical groups inside and outside department. 
  • Ensure adherence to quality standards and facilitate improvement efforts.
  • Follow all appropriate data quality and security guidelines

Analytics: (15%)

  • Apply knowledge of data analytics, population health, clinical information, disease processes, measurement and analysis to the completion of complex assignments.
  • Produce analytic results by creating and applying algorithms to data which are extracted and integrated across multiple sources.
  • ?Translate clinical and business needs into analytical solutions
  • Conduct analysis and reporting of clinical and operational data.
  • Evaluate performance, utilization, quality of care and patient safety measures against results from peer institutions
  • Conduct analyses on cost performance and facilitate assessment of physician practice patterns and medical and disease management
  • Collaborate with physicians, administrators, senior analysts and others to produce metrics to assess and improve performance
  • Validate data quality and reasonableness in reports and/or analyses of health services prior to distribution.
  • Communicate and collaborate with other departments to address problems with data quality.
  • ?Evaluating performance, utilization, quality of care and patient safety measures against results from peer institutions.

Other Duties as Assigned: (5%)

  • Develops detailed timelines and resource plans, define requirements, identify risks, create project documentation, report status to team and stakeholders, track and escalate issues.
  • Work with teammates in internal process improvements
  • Support committees involved with data interpretation and process improvements
  • Documentation of information important to the continued delivery of analytic services
  • Other duties as assigned

 

Required Qualifications*

Required for Senior Level:

  • Bachelor’s Degree in a quantitative field like Business, Computer Science, Informatics, Engineering, biostatistics, public health, Economics.
  • A minimum of 5 years of progressively responsible experience in data analysis and visualizations.
  • Proficiency in the use of data analytic and BI reporting tools such as Tableau, SQL, SAS, Excel or other BI tools.
  • Experience or the ability to gain proficiency in using MiChart and querying EPIC’s Clarity databases.
  • Understanding of data base structures and data architecture relevant to the development of dynamic reporting.
  • Ability to consistently meet deadlines in a fast paced and changing environment with multiple competing tasks and priorities.
  • Experience with Data Warehouse and BI systems.
  • Strong customer service skills and commitment to excellent customer service.
  • Strong analytical and problem-solving skills.
  • Good verbal, written and visual presentation skills.
  • Ability to anticipate requests and needs in advance and plan accordingly.
  • Skills to work effectively across internal functional areas in ambiguous situations.

Required for Intermediate Level:

  • Bachelor’s Degree (Quantitative Field like biostatistics, public health, Computer Science, Economics, Engineering, Informatics)
  • A minimum of 2 years of progressively responsible experience in data analysis.
  • Ability to develop and maintain proficiency in the use of analytic and reporting tools such as SQL, SAS, Microsoft Excel, Tableau or other BI tools.
  • Ability to consistently meet deadlines in a fast paced and changing environment with multiple competing tasks and priorities.
  • Ability to gain proficiency in MiChart (EPIC and Clarity) querying through training.
  • Experience with Data Warehouse and BI systems.
  • Strong analytical and problem-solving skills.
  • Good verbal, written and visual presentation skills.
  • Ability to anticipate requests and needs in advance and plan accordingly.
  • Skills to work effectively across internal functional areas in ambiguous situations.

Desired Qualifications*

  • Bachelor’s Degree (Quantitative Field) with an advanced degree (biostatistics, public health, Computer Science, Economics, Engineering, Informatics) preferred.
  • 10 or more years of progressively responsible experience in health care analysis and data visualizations.
  • Proficiency in the use of data analytic and BI reporting tools such as Tableau, SQL, SAS, Excel and Crystal Reports.
  • Experience in using MiChart and querying EPIC’s Clarity databases.
  • Ability to incorporate R, Python or other programming languages to enhance reporting through statistical analysis, forecasting and modeling.
  • Experience with AI analytic tools like DataRobot
  • Understanding of data base structures and data architecture relevant to the development of dynamic reporting.
  • Experience with Data Warehouse and BI systems.
  • Ability to consistently meet deadlines in a fast paced and changing environment with multiple competing tasks and priorities.
  • Strong customer service skills and commitment to excellent customer service.
  • Strong analytical and problem-solving skills.
  • Good verbal, written and visual presentation skills.
  • Ability to anticipate requests and needs in advance and plan accordingly.
  • Skills to work effectively across internal functional areas in ambiguous situations.

Underfill Statement

This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

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/AA Statement

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


U-M COVID-19 Vaccination Policy

COVID-19 vaccinations, including one booster when eligible, are required for all University of Michigan students, faculty and staff across all campuses, including Michigan Medicine.  This includes those working remotely and temporary workers.   More information on this new policy is available on the U-M Health Response website or the UM-Dearborn and UM-Flint websites.