Business Intelligence Analyst

Michigan Medicine; Ann Arbor (MI); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Excellent medical, dental and vision

2:1 Retirement match

Job summary

Michigan Medicine seeks a highly motivated BI professional to build and maintain a decision support platform. Responsibilities include end-to-end BI solutions, data mart design, report and visualization development (Tableau), and data analysis to maximize value of care delivery at UMHS.

Ideal candidates will blend operational and technical experience with autonomous work style and opportunities for growth within Michigan Medicine.

Qualifications

• Proficient use of SQL or equivalent for data extraction and reporting.
• Advanced knowledge of data analysis and visualization tools (e.g., Tableau, R).
• Proficiency in Excel for data manipulation and reporting.
• Strong analytical, problem-solving, and communication skills.
• Understanding of BI architecture and ability to tailor tools to user needs.

Responsibilities

• Serve as a technical expert for report writing via SQL and dashboard design.
• Translate business requirements into technical specs with data architecture alignment.
• Interview users to determine data, reports, analytics, metadata, and training needs.
• Collaborate with data warehousing teams to optimize data delivery.

Skills

SQL queries

Data visualization

Excel proficiency

Analytical thinking

Communication skills

BI architecture understanding

Education

Bachelor's degree in Business, Health Administration, Accounting, Finance or related field

Tools

Tableau

R

Data warehousing tools

Job description

Job Summary

The University of Michigan Medical group is seeking a highly motivated professional to build and provide ongoing maintenance of a decision support platform. This individual will be responsible for end-to-end BI solutions, including data mart design and development, creation of reports and visualizations using appropriate Business Intelligence tools (e.g. Tableau), and data analysis. This individual will serve a key role in developing business intelligence tools to drive decision making, ultimately maximizing value of care delivery at UMHS. Ideal candidates should have a blend of operational and technical experience, with demonstrated ability to function with a high degree of autonomy. The position provides the opportunity for development and growth within Michigan Medicine.

Responsibilities*

Technical

• Serve as a technical expert including but not limited to report writing via SQL, design of dashboards utilization visualization tools, conduct validation and user acceptance testing of developed solutions


• Master understanding of BI architecture, functions, features, to be able to customize tool to specific user needs


• Interview end users to determine requirements for data, reports, analytics, metadata, training, service, data quality, and performance


• Work with data warehousing team and data architects to translate business requirements into technical specifications, and ensure that architecture is optimized for data needs

Analytics

• Partner with customers to collect and coordinate business requirements to deliver meaningful and reliable performance analytics


• Lead development of data analytics and business intelligence capabilities to support and fulfill business use cases


• Mine large complex data sets from various sources of data


• Translate abstract business questions into analytic use cases and visual reports/dashboards in Tableau


• Audit and reconcile operational data, patient data, financial data and other statistics and metrics


• Provide data analytics support to clinical programs, performance improvement initiatives, operational leadership, and levels of executive leadership

Required Qualifications*

• Proficient use of SQL or alternative relational database querying software to support business needs


• Advanced knowledge with data analysis & visualization tools (e.g. Tableau, R, etc.)


• Proficiency in Excel


• Demonstrated proficiency in technical, problem solving, and analytical skills


• Has working knowledge in BI architecture, functions, and features


• Ability to translate abstract concepts and business requirements into technical solutions


• Ability to understand complex clinical and business processes and identify relevant data sets


• Have innovative and creative approach to reporting, analytics and data visualization


• Strong interpersonal and communication skills, a proactive service-oriented team player


• Ability to effectively communicate with technical data architects and operational leadership


• Adaptability and flexibility to adjust to fluctuating changes in project needs


• Comfort in navigating ambiguity with a can-do attitude, adaptable and quick learner, willingness to acquire and develop new skills as needed

Intermediate Level Qualifications:

• Bachelor's degree in Business, Health Administration, Accounting, Finance or a related field. Computer Science and Information Systems coursework a plus.

Senior Level Qualifications

• BA or BS in quantitative field with 5+ years of experience.

Desired Qualifications*

• Epic Clarity Proficiency or Certification


• Previous work experience with an academic medical center or in healthcare desired


• Quantitative experience or coursework in healthcare finance


• Background in Computer Science or Health Information Systems a plus

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

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.

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 any time after the minimum posting period has ended.

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.