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

BMC2 is a collaborative consortium dedicated to improving the quality of care and outcomes in patients who undergo cardiovascular procedures across the State of Michigan. BMC2 is developing a new heart failure registry, which will take a population health-based approach to measuring outcomes and improving quality of care for patients with heart failure. The new registry will bring together diverse stakeholders including patients, specialists, primary care physicians, and pharmacists.

Support for BMC2 is provided by Blue Cross and Blue Shield of Michigan and Blue Care Network as part of the BCBSM Value Partnerships Program.

Under general direction, the BI Analyst Senior conceptualizes, designs, and delivers high-impact business intelligence solutions that support cross-functional strategic objectives and drive organizational value. This role focuses on developing interactive, user-centered dashboards and reporting solutions, supported by strong SQL-based data analysis and modeling. BMC2 is transitioning PDF reporting to an interactive platform and this role is integral to providing our consortium with autonomy over their data.

The BI Analyst Senior leads the design and development of data structures, data extracts, and analytical outputs required for complex analyses and decision support. This position operates at a senior technical and analytical level, independently evaluating business problems, identifying data-driven insights, and recommending actionable solutions.

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.

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

• Conceptualize and develop business intelligence solutions aligned with cross-functional strategic objectives
• Design, build, and maintain interactive dashboards and reports using tools such as Tableau and/or Power BI
• Apply strong UX/UI principles to ensure dashboards are intuitive, accessible, and effective for diverse audiences
• Develop and manage SQL queries, views, and extracts to support reporting, analytics, and data visualization
• Design and administer data structures and datasets to enable reliable, repeatable, and scalable analysis
• Translate complex data into clear insights, narratives, and visualizations for technical and non-technical stakeholders
• Participate in strategic assessments to identify current and emerging business issues and opportunities
• Lead and facilitate business process improvement discussions and recommend data-driven solutions
• Develop and present reports, dashboards, metrics definitions, and analytical findings to stakeholders and leadership
• Collaborate with data engineers, application developers, and business partners to ensure data accuracy and consistency
• Lead or manage cross-functional BI initiatives or projects, including planning, task coordination, and status reporting
• Support change management efforts related to new or enhanced BI tools, dashboards, and processes
• Ensure data governance, quality, and documentation standards are followed

• Bachelors degree (BA or BS) in a quantitative field such as Data Analytics, Statistics, Mathematics, Economics, Computer Science, or Information Systems
• Five (5) or more years of professional experience in business intelligence, analytics, or data visualization roles
• Strong experience developing interactive dashboards using Tableau, Power BI, or similar BI tools
• Proficiency in SQL for querying, transforming, and validating data from relational databases
• Strong understanding of data visualization best practices and dashboard design principles
• Experience working directly with…