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.
About The Role
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 directly to the AIM28 Finance Lead, this role involves designing and owning end-to-end data models, ETL pipelines, dashboards, and automation solutions that convert complex, fragmented data into trusted insights for executives and program leaders. The role also entails supporting strategic projects as needed.
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 individual will establish the program's single source of truth for KPIs, benefits, investments, and value-realization reporting. Additionally, they will drive self-service analytics, reporting automation, and AI-powered insights across the AIM28 portfolio.
This role involves architecting an AI-ready analytics and reporting model that pairs traditional dashboards with AI capabilities such as automated narratives and conversational agents, enabling stakeholders to self-serve and access insights faster. The candidate will transform raw data into usable formats, integrate scattered reporting into standardized solutions, and ensure the reliability and accuracy of all outputs. As a standalone technical contributor embedded in Finance, the role requires full ownership of the analytics stack, from requirements gathering to solution deployment and adoption.
The position works closely with the AIM28 Finance Lead, Big Bet teams, the transformation office, and McKesson Technology to formalize KPI definitions and benefit methodologies into governed data models, ensuring consistency and accuracy across the program. The role demands a proactive problem-solver capable of turning ambiguous data challenges into clear, reliable insights.
Qualifications
- A builder's mindset with the ability to translate loosely defined problems into comprehensive, end-to-end solutions.
- Comfort with ambiguity and working with imperfect data, including raw extracts, manual spreadsheets, and shifting requirements.
- Strong business acumen and financial literacy, with experience in finance concepts such as ROI, forecasting, variance analysis, and business-case logic.
- Proven ability to work independently as a technical individual contributor, owning the full analytics stack without reliance on a dedicated team.
- Demonstrated experience developing and monitoring KPIs that influence business decisions, along with building automated reporting systems.
- Excellent communication skills, capable of presenting complex analytical results to senior leadership clearly and convincingly.
- Strong ownership, judgment, and validation skills to ensure data integrity and trustworthiness of outputs.
- Effective organization and prioritization skills to manage multiple concurrent projects efficiently.
- Curiosity and interest in AI applications, including experimentation with GenAI and conversational agents in reporting contexts.
- Expert proficiency in SQL, including complex query development, window functions, and performance tuning on large datasets.
- Solid understanding of data modeling and design principles to create scalable, maintainable data architectures.
- Experience with BI visualization tools and storytelling to communicate insights effectively.
- Design, develop, and maintain comprehensive dashboards tracking KPIs, benefits, investments, milestones, and value realization at the program and Big Bet levels, serving as the single source of truth for performance metrics.
- Create executive-facing reports for monthly leadership meetings, translating complex data into actionable insights.
- Automate recurring benefit and program reporting processes, replacing manual workflows with scheduled, validated data flows.
- Identify and implement automation opportunities, including AI-driven narratives and summaries to surface insights proactively.
- Build and maintain scalable ETL/ELT pipelines to extract, transform, and load large, multi-source datasets, ensuring data quality and consistency.
- Integrate data from various sources, including raw operational data, manual files, and self-built dashboards, into harmonized, consumable datasets and models.
- Develop and document business logic and data lineage to ensure transparency and maintainability of reports and models.
- Partner with finance and program teams to codify KPI definitions and benefit methodologies into governed data models, ensuring measurement consistency.
- Conduct in-depth analyses of KPI trends, variances, and program performance, providing insights and recommendations to senior leadership.
- Respond to ad hoc analytical requests, triangulating data sources to validate findings and ensure accuracy.
- Enable governed self-service analytics for stakeholders, reducing reliance on ad hoc requests and fostering data-driven decision-making.
- Lead end-to-end delivery of analytics solutions, from requirements gathering and design to build, testing, and adoption.
- Prioritize reporting and automation initiatives based on business impact, managing stakeholder expectations and project timelines.
- Set standards for data integrity, documentation, and version control across the analytics ecosystem,
