BI Analyst Senior

University Of Michigan

Ann Arbor (MI)

Hybrid

USD 85,000 - 120,000

Full time

23 hours ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Excellent medical, dental, and vision

2:1 retirement matching

Job summary

University of Michigan is seeking a BI Analyst Senior to join the Cost Analytic and Decision Intelligence (CAnDI) team. You will own end-to-end BI solutions, including SQL programming, data warehousing, and Tableau visualizations to support cost analysis and clinical operations.

The role requires a blend of technical and healthcare operations experience, with strong problem-solving and analytical skills, and the ability to work with autonomy in a hybrid environment.

Qualifications

Bachelor's degree or higher in Health Information Systems, CS, Data Science/Analytics, Business, Finance, or related field
Proficient use of Excel, SQL, or equivalent DB querying software
Experience in assessing/debugging system performance, failures, and results
Knowledge of BI architecture and data visualization tools (Tableau)
Ability to translate business rules into technical solutions
Strong problem-solving and analytical skills
Curiosity about data and ability to translate findings into actionable insights
Ability to work independently with minimal supervision
Collaborative team player
Experience levels: Associate 0-2, Intermediate 3-5, Senior 5+

Responsibilities

Design, develop, and maintain costing logic and systems ensuring data integrity
Design, develop, and test changes in data structures and SQL components
Mine large data sets from multiple sources to understand data flow and root causes
Monitor month-end costing cycle and resolve technical issues
Collaborate with vendor to improve delivery of costing information
Analyze complex data sets to inform decision making
Develop new data-driven decision-making approaches and tools
Provide analytic support to finance and clinical teams
Perform ad hoc analyses as needed

Skills

SQL

Excel

Data analysis

Problem-solving

Self-motivated

Communication

Ambiguity navigation

Education

Bachelor's degree or higher

Tools

Tableau

Relational databases

Job description

Michigan Medicine Finance is seeking a Business Intelligence Analyst to join its Cost Analytic and Decision Intelligence (CAnDI) team. Michigan Medicine Finance serves as the central finance group for Michigan Medicine and is comprised of multiple functional areas.The CAnDI team plays a key role in helping leadership make data-driven strategy through the deployment of activity-based costing system/data that's generated using multiple data sources from across the enterprise, creating/maintaining analytic tools, and performing ad hoc financial analysis.

This Business Intelligence Analyst will be responsible for end-to-end BI solutions, including SQL programming, Database/Datamart architecture design and development, creation of reports and visualizations using appropriate Business Intelligence tools (e.g., Tableau), and data analysis. Ideal candidates should have a blend of technical and health care operational experience, with demonstrated proficiency in technical, problem-solving, and analytical skills and the ability to function with a high degree of autonomy.

Responsibilities*

Participate in the design, development, and maintenance of costing logic and systems. Serve as a technical expert, including but not limited to SQL programming, assessing system performance/application results, troubleshooting programming/system failures, and costing errors to maintain costing database integrity.
Designing, developing and testing changes in data structures, application configuration and programmed components (e.g., SQL)
Mining large complex data sets from various data sources to understand data flow, identify root cause, find solutions to known issues as well as identify opportunities for management
Monitor month-end costing cycle and resolve any technical issues arisen in time. Partner with others in the month-end costing validation process
Work directly with our vendor partner to improve the delivery of the costing information across the organization.
Work with complex data sets, synthesize and summarize financial/operational findings effectively, allowing for the identification of key issues, decision-making criteria, and the determination of strategies and plans
Design, develop and recommend new approaches, methodologies, and tools for data-driven decision-making and planning.
Provide data analytic support to other finance teams and clinical areas
Perform ad hoc analyses and other duties as assigned

Required Qualifications*

A Bachelor's degree or higher in Health Information Systems, Computer Science, Data Science/Analytics, Business, Finance, Economics or a related field
Proficient use of Excel, SQL, or alternative relational database querying software to support business needs
Experience in assessing and/or debugging system performance, failures, and application results
Working knowledge in BI architecture and function, as well as data analysis & visualization tools (e.g., Tableau, etc.) to customize tools to specific user needs in a creative fashion.
Ability to understand complex clinical and business processes and identify relevant data sets, and to translate business rules/requirements into technical solutions
Problem-solving capabilities including root cause analysis, process comprehension, development of alternative solutions, and recommended course of action
A natural curiosity to data. Be self-driven in questioning data, investigating system/data issues, and finding the root cause; able to translate the findings into actionable information for decision-making
Comfort in navigating ambiguity with a can-do attitude, adaptable and quick learner, willingness to acquire and develop new skills as needed
Ability to function independently and require minimal day-to-day supervision to deliver projects in a timely and effective manner
Works well in a collaborative environment as part of a team
Associate: 0 - 2 years of professional experience
Intermediate: 3 - 5 years of professional experience
Senior: 5+ years of professional experience

Desired Qualifications*

What will make you stand out?

Epic Clarity Proficiency or Certification, or the ability to earn certification within one year of hire
Experience working with clinical/healthcare and financial data
Work experience in a healthcare and/or academic medical center setting desired
Strong communication skills both verbal and written. Ability to analyze large amounts of complex information to present simple and concise material to the appropriate audience
Demonstrated innovative/creative critical thinking skills

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,000employees, 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.

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

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.

Job Opening ID

281926

Working Title

Job Title

BI Analyst Senior

Work Location

Michigan Medicine - Ann Arbor

Modes of Work

Hybrid

Full/Part Time

Full-Time

Regular/Temporary