BI Analyst Senior / Intermediate

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.


The University of Michigan Medical School is seeking a qualified analyst to join the Medical School Data and Analytics team in an embedded role within our Office of Faculty Affairs. Faculty Affairs supports senior leaders in the Medical School and UM-Health across numerous high-priority and high-visibility workstreams. This position will provide important data and analytical capabilities in support of this work and will be exposed to best practices, operational challenges, and data across higher education, academic medicine, and healthcare administration. Faculty Affairs supports a broad range of domains including: faculty/physician compensation, faculty/physician productivity and key performance indicators, faculty/physician wellness, faculty life cycle and demographic analysis, and compliance with institutional, state, and federal policies and regulations. The right candidate will serve as a thought partner and will be encouraged to take an entrepreneurial approach to solving problems and supporting collective learning. The right candidate will also take a slow and methodical approach to validating data logic and will leverage institutional partners to ensure accuracy in reporting and analysis. 

Faculty Affairs supports over 3,000 faculty across 29 Academic Departments and a faculty payroll of over $725 million. This position will focus on meeting the Medical School’s needs around the full complement of faculty data, in coordination with the Medical School Data and Analytics (MSDA) Team. This position will report day-to-day to the Office of Faculty Affairs, who will be responsible for setting priorities and work planning to make sure the most immediate data and information needs are met in the timeframes required. They will also be responsible for advising/advocating how faculty data should be exposed to enable reproducible results and to improve its connectedness to the greater Michigan Medicine data ecosystem. In addition, the role will support Faculty Affairs’ leadership around faculty data governance. They will be supported by MSDA with consultative and technical resources as needed, provided opportunities for professional development, and be expected to participate and potentially take the lead in groups/committees related to improving/connecting the institution's analytic ecosystem.

The direct supervisor in this role will be the UMMS Senior Manager for Analytics and Business Consulting, but as noted above, will be housed in the Office of Faculty Affairs, will attend Faculty Affairs team meetings, and will functionally be a member of the Faculty Affairs team. In this capacity, they will report day-to-day to the Faculty Compensation, Compliance, and Analytics Lead. Candidates for this position will be expected to be comfortable with leveraging various resources (documentation, SMEs, etc.) to learn the primary data environments impacting their typical operational activities, conduct current and new data analysis, create series of standard reports based on analytics, and serve as an innovator in developing new ways to analyze and present data to leadership. Candidates should be able to function independently, deliver projects in a timely and effective manner, and enjoy creating new and novel solutions.

What a Typical Day Will Look Like 

As a Business Intelligence Analyst, a typical day will likely include:

  • A combination of managing and/or administering the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction for complex analyses, as well as doing quality assurance to validate sourced data is correct.

  • At times working collaboratively/proactively with the broader analytics on deliverables that require cross domain involvement.

  • Engaging with the University’s information technology department on data, definitions, and ETL processes. 

  • Working in a variety of reporting and analysis tools creating and maintaining dashboard/reports and deliverables that meet active business needs, as well as exploring new ways of showing data and information to better support actionable decisions.

  • Interacting with your internal customers to discover what their business needs are, how data analytics can assist those needs, and presenting alternative solutions to improve the business and better support strategic goals and decisions.

  • Identifying the needs and implementing the solutions outlined in the prior bullet point.

  • Researching trends in the industry as well as best practices from other academic medical centers in order to move Michigan Medicine into a position of being the leader amongst academic medical centers.

  • Being the lead for answering domain related data questions and supporting the creation/updating domain specific data governance processes/documentation as needed in coordination with the data governance group.

  • Participating on institutional committees/groups as needed as a domain expert.

Is This Job Right for You?

This job might be right for you if…

  • Using data and data analytics to support business decisions and strategic goals sounds exciting.

  • You are skilled in identifying, analyzing, and interpreting trends or patterns in complex data sets.

  • You enjoy problem solving and making new discoveries.

  • Working in ambiguity and creating business solutions that are novel to the organization sounds stimulating.

  • You pay attention to details and do not let anything fall through the cracks – as far as you are concerned, anything worth doing is worth doing right, every time.

  • You can thrive while working in both team and individual settings.

  • You currently use Tableau and/or have a desire to become an expert user of the software.

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.


Reporting and Analysis: (40%)

  • Design report formats and graphical representations of data intended for audiences ranging from senior leaders to front line departmental staff

  • Deliver graphical presentations (dashboards, reports, portal interfaces) of provider, product, program, and service specific data to internal staff, faculty, UMMS leaders, relevant committees, and other constituencies

  • Conceptualize and develop cross-functional client/unit strategic objectives, business processes, and initiatives that drive or increase organizational value

  • Work with other BI 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 and Governance: (30%)

  • Develop and maintain supporting documentation of measurement methods and algorithms, data sources and reporting processes

  • Become the SME for your domain data and provide consultation/advice to the wider institution as needed as well as identifying emerging issues that need to be addressed to support improved decisions/operations

  • Review reports and analyses and test datasets

  • Extract data for reporting from departmental and enterprise 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

  • Provide support and documentation (data/metric definitions, exceptions, common questions, etc.) to facilitate other domains use of your data to support their business needs

  • Participate in the development of communication related to the analysis, interpretation, and dissemination of data

  • Work to identify and automate tools that deliver routine performance information

  • Maintain on-going reporting for the dashboards and reports developed in this role and by others

  • Maintain communication with technical groups inside and outside of the department 

  • Ensure adherence to quality standards and facilitate improvement efforts

  • Follow all appropriate data quality and security guidelines

Problem Framing and Analytics: (20%)

  • Apply knowledge of data analytics, 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 business needs into analytical solutions

  • Validate data quality and reasonableness in reports and/or analyses prior to distribution

  • Communicate and collaborate with other departments to address problems with data quality

  • Evaluating performance to measures against results from peer institutions, external compliance requirements and internal benchmarks

Other Duties as Assigned: (10%)

  • Work with department and wider institution as needed in internal process improvements

  • Support/participate in committees as needed/directed that focus on data governance, data interpretation or 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 or equivalent combination of education and experience.

  • 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

  • Understanding of database 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

  • Demonstrated ongoing ability to function effectively on and across teams

  • 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) or equivalent combination of experience and education.

  • A minimum of 3 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

  • Experience with Data Warehouse and BI systems

  • Strong customer service skills and commitment to excellent customer service

  • Strong analytical and problem-solving skills

  • Demonstrated ongoing ability to function effectively on and across teams

  • 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 (with quantitative elements) with an advanced degree (Business, Biostatistics, Public Health, Computer Science, Economics, Engineering, Informatics) preferred

  • 5 or more years of progressively responsible experience in health care/HR  analysis and data visualizations

  • Ability to incorporate R, Python or other programming languages to enhance reporting through statistical analysis, forecasting and modeling

  • Experience with working with administrative data (HR, Development, Space, Learner, etc.)

Work Locations

Flexible First Work Policy

This position is eligible for the University of Michigan’s Flexible First Work Policy. The selected candidate will be able to work with their manager to establish a flexible work schedule that can range from fully remote to fully on-site. The analyst may need to be on-site from 4-10 days per year.

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.

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.