Business Intelligence Analyst

University of Michigan; Michigan; On-site; USD 90,000 - 140,000; Full time

Job summary

The University of Michigan Medical group seeks a motivated professional to build and maintain a decision support platform, delivering end-to-end BI solutions, data marts, reports, and Tableau-based visualizations. The role requires autonomy and strong analytical skills to maximize value of care delivery at UMHS.

Ideal candidates blend operational and technical experience, enabling development within Michigan Medicine and ongoing growth within the organization.

Qualifications

• Proficient in SQL for business needs.
• Advanced knowledge of data analysis and visualization tools (Tableau, R).
• Excel proficiency.
• Strong problem solving and analytical skills.
• Ability to translate abstract concepts and requirements into technical solutions.
• Understanding of BI architecture and data processes.
• Excellent communication and interpersonal skills.
• Adaptable and independent with changing project needs.
• Education: Bachelor's degree in Business/Health Admin/Finance or related field; CS/IS coursework is a plus; 5+ years of experience.

Responsibilities

• Serve as a technical expert for report writing, dashboard design, and validation testing.
• Translate business requirements to technical specifications with data warehousing teams.
• Lead development of analytics and BI capabilities to support business use cases.
• Mine large data sets and deliver meaningful performance analytics for leadership.

Skills

SQL

Data analysis

Data visualization

Tableau

Excel

BI architecture

Communication skills

Problem solving

Interpersonal skills

Analytical thinking

Education

Bachelor's degree in Business/Health Admin/Finance/Accounting

BA/BS in quantitative field

CS/Health Information Systems coursework

Tools

Tableau

R

Excel

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

• TechnicalServe 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 solutionsMaster understanding of BI architecture, functions, features, to be able to customize tool to specific user needsInterview end users to determine requirements for data, reports, analytics, metadata, training, service, data quality, and performanceWork with data warehousing team and data architects to translate business requirements into technical specifications, and ensure that architecture is optimized for data needsAnalyticsPartner with customers to collect and coordinate business requirements to deliver meaningful and reliable performance analyticsLead development of data analytics and business intelligence capabilities to support and fulfill business use casesMine large complex data sets from various sources of dataTranslate abstract business questions into analytic use cases and visual reports/dashboards in TableauAudit and reconcile operational data, patient data, financial data and other statistics and metricsProvide 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 needsAdvanced knowledge with data analysis & visualization tools (e.g. Tableau, R, etc.)Proficiency in ExcelDemonstrated proficiency in technical, problem solving, and analytical skillsHas working knowledge in BI architecture, functions, and featuresAbility to translate abstract concepts and business requirements into technical solutionsAbility to understand complex clinical and business processes and identify relevant data setsHave innovative and creative approach to reporting, analytics and data visualizationStrong interpersonal and communication skills, a proactive service-oriented team playerAbility to effectively communicate with technical data architects and operational leadershipAdaptability and flexibility to adjust to fluctuating changes in project needsComfort in navigating ambiguity with a can-do attitude, adaptable and quick learner, willingness to acquire and develop new skills as neededEducation: 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 CertificationPrevious work experience with an academic medical center or in healthcare desiredQuantitative experience or coursework in healthcare financeBackground in Computer Science or Health Information Systems a plus