Business Intelligence Analyst Senior

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.

Have questions about the role or want to learn more before applying?

Join our informal, open forum Teams session to connect with the hiring team! Drop in at any time during the hour and stay as long as you’d like - whether you have specific questions or just want to listen in.

Friday, November 21 | 12:00 PM - 1:00 PM EST |  to Join Friday’s Team Meeting

A Business Intelligence Analyst Senior for Supply Chain Services plays a pivotal role in designing, developing, and delivering strategic business intelligence solutions that advance a clinically integrated supply chain within University of Michigan Health. This position reports to the Supply Chain Services Applications and Analytics Solutions Manager. Leveraging advanced data analytics, emerging artificial intelligence (AI) tools, and innovative strategies, this position generates actionable insights that optimize supply chain processes, improve patient care, and enhance organizational value.

The ideal candidate exhibits strong technical BI development expertise (with prior experience in Tableau/SQL and a deep focus on Power BI, DAX, and MS Fabric), applies predictive and generative AI‑driven analytics, and leads proactive process improvement ensuring that data‑driven decision‑making is seamlessly embedded throughout the supply chain.

As the organization transitions to Microsoft Fabric, the analyst will harness Fabric’s full capabilities including Power BI, Lakehouse, Data Factory, Warehouse, and Copilot while maintaining knowledge of legacy platforms to support migration and integration efforts. This role is both a champion for innovation and a steward of data quality, governance, and continuous operational excellence.

• Conceptualize and develop cross‑functional strategic objectives, business processes, and supply chain initiatives that drive or maximize organizational value using advanced analytics and AI‑driven solutions across both legacy and Microsoft Fabric platforms.
• Design, build, and maintain interactive, visually compelling dashboards and reports in Power BI, leveraging Fabric for data integration, predictive analytics, machine learning, and other AI‑powered features. Maintain familiarity with Tableau for migration or support as needed.
• Write and optimize complex SQL and DAX queries; manage ETL processes and pipelines with Microsoft Fabric (Data Factory, Lakehouse, Warehouse), exploring opportunities to automate and enhance data preparation with generative AI and Copilot tools. Support and transition from SSIS, Python, and Tableau Prep as appropriate.

• Analyze and compare courses of action by applying advanced quantitative methods, predictive modeling, and analytics using both Fabric’s analytical engines and AI integration, and legacy skillsets as necessary.
• Translate complex supply chain data and AI‑generated insights into clear, actionable recommendations and narratives suited for executive and operational audiences.
• Evaluate and deploy generative AI platforms (such as Microsoft Copilot) to automate business intelligence workflows, including routine report generation and natural language data queries for end‑users.

• Manage or participate in cross‑functional projects and teams, identifying opportunities to pilot and scale AI, ML, and Fabric‑driven process improvements; work collaboratively in migrating from legacy BI environments to modern cloud solutions.
• Assist in identifying, planning, and executing change management processes for new or improved business processes, analytics workflows, and the adoption of Microsoft Fabric BI/AI resources.

• Collaborate with internal partners in procurement, logistics, clinical operations, and IT to understand reporting needs and deliver impactful, AI‑augmented analytic solutions using the Microsoft Fabric ecosystem.
• Provi…