Senior Business Intelligence & Automation Analyst
AI summary of the role
Senior individual contributor in McKesson's Finance organization, building and scaling analytics, reporting, and automation for AIM28, an AI-enabled transformation program.
What you’ll do
- Design, build, and maintain AIM28 program-level and Big Bet-level dashboards tracking KPIs, benefits, investments, milestones, and value realization.
- Automate recurring benefit and program reporting end to end, replacing manual file-based processes with scheduled, monitored data flows.
- Build and maintain scalable ETL/ELT pipelines to extract, transform, and clean large multi-dimensional datasets from multiple sources.
- Codify KPI definitions and benefit methodologies into governed data models, ensuring one version of the truth across the program.
What you’ll bring
- 7+ years of experience as a Business Intelligence Engineer, Data Analyst, Analytics Engineer, or related role delivering BI, analytics, and reporting solutions.
- Expert SQL proficiency including complex queries, window functions, and performance tuning on large datasets.
- Expert-level dashboard development in Power BI (or equivalent) for executive audiences.
- Experience programming to extract, transform, and clean large datasets from multiple disparate sources, including raw and manually maintained data.
Technologies
SQL · Power BI · Tableau · DAX · ETL/ELT · Databricks · Microsoft Fabric · Azure Data Factory · Snowflake · Python · Power Automate · Power Apps
About McKesson
Distributes pharmaceuticals and medical supplies to 40,000+ customers including pharmacies, hospitals, and providers; offers specialty oncology, clinical trial, and pharmacy technology solutions globally.
Public · 5000+ people
Source and classification
Internal deployment & tooling · Evidence for this classification:
end-to-end data models, ETL pipelines, dashboards, and automation solutions that transform complex, fragmented data into trusted insights for executives and program leaders. In addition, this role will support other strategic projects as required. The ideal candidate combines deep technical expertise in SQL, data modeling, BI visualization, automation, and AI-enabled analytics with strong business and finance acumen. Operating as the sole analytics builder within the AIM28 Finance team, this person will create the program's single source of truth for KPI, benefit, investment, and value-realization reporting while driving self-service analytics, reporting automation, and AI-powered insights across the AIM28 portfolio. The Senior Business Intelligence Analyst will lead the development of business intelligence, data visualization, analytics, and reporting automation for the AIM28 program
More from the job description
McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve – we care. What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow’s health today, we want to hear from you. The Senior Business Intelligence Analyst is a highly visible, hands-on individual contributor responsible for building and scaling AIM28's analytics, reporting, and value-realization measurement capabilities. Reporting to the AIM28 Finance Lead, this role will design and own end-to-end data models, ETL pipelines, dashboards, and automation solutions that transform complex, fragmented data into trusted insights for executives and program leaders. In addition, this role will support other strategic projects as required. The ideal candidate combines deep technical expertise in SQL, data modeling, BI visualization, automation, and AI-enabled analytics with strong business and finance acumen. Operating as the sole analytics builder within the AIM28 Finance team, this person will [... source excerpt omitted ...] a arrives raw and needs business logic before anyone can use it, some lives in manual files, and some is already visualized in dashboards the business teams built for themselves. You will architect an AI-ready analytics and reporting model that pairs traditional dashboards with AI capabilities such as automated narratives and conversational agents, so stakeholders can self-serve and get to insight faster. Where data is raw, you will establish the transformation logic that makes it consumable. Where reporting lives in manual files or scattered dashboards, you will integrate and standardize it into Big Bet and AIM28 program-level solutions. This is a highly visible individual cont [... source excerpt omitted ...] tion Enable governed self-service analytics for program and Big Bet stakeholders, so fewer questions turn into ad hoc requests or one-off analyses. Own delivery end to end, from requirements and solution design through build, UAT, and adoption. Work with business stakeholders, data engineering, and IT to keep solutions compliant with enterprise data standards. Continuous improvement & influence Prioritize the reporting and automation backlog by business impact and effort. Keep stakeholders current on the roadmap and the trade-offs behind it. Set the standard for analytics practice (data integrity, documentation, versioning) across Big Bet teams, and coach business analysts who b
Employer postings · Data from · Sources