Sr. Workforce Intelligence Analyst

McKesson; Mississauga; On-site; CAD 90,000 - 120,000; Full time

Job summary

McKesson, a Fortune 10 company, is seeking a Senior Workforce Intelligence Analyst to design and deliver visualization, reporting solutions, and data products that translate workforce data into actionable insights. You will work across data preparation, modeling, and governance to enable responsible self-service for defined workloads.

You will partner with data science, privacy, legal, and governance teams to ensure trusted analytics, governance, and clear business rules while delivering

Qualifications

• Strong experience with BI reporting and visualization platforms.
• Ability to translate business needs into analytical requirements and data models.
• Proficiency in SQL and data preparation for reporting and analysis.

Responsibilities

• Design, develop, and maintain dashboards, reports, scorecards, and data products.
• Translate business questions into analytical requirements, data models, measures, and visuals.
• Build scalable reporting solutions balancing enterprise consistency with stakeholder needs.
• Analyze workforce data to identify trends, patterns, relationships, and opportunities.
• Develop narratives and recommendations linking analytics to business actions.
• Continuously improve reporting based on user feedback and changing priorities.

Skills

Power BI

SQL

Data modeling

Data governance

Analytics

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.

Sr. Workforce Intelligence Analyst
Business Intelligence and AI-Enabled Self-Service

About the Role

McKesson's Workforce Intelligence team transforms workforce data into clear, trusted insights that help leaders make better decisions. We combine high-quality business intelligence, thoughtful analysis, and practical technology enablement to make workforce information easier to access, understand, and use.

As a Senior Workforce Intelligence Analyst, you will design and deliver visualization, reporting solutions, data products, and decision-ready insights across key workforce topics. You will translate business needs into intuitive analytical experiences, connect and model data, define meaningful metrics, and help stakeholders confidently interpret and act on workforce information.

You will use approved AI capabilities to improve the speed, quality, and accessibility of BI work, and you will help build agentic and conversational solutions that enable responsible self-service for defined Workforce Intelligence use cases. When advanced data science is appropriate, you will partner with data science, technology, privacy, legal, and governance teams.

Key Responsibilities

Business Intelligence and Reporting

• Design, develop, and maintain intuitive dashboards, reports, scorecards, and data products using Power BI or similar business intelligence platforms.
• Translate business questions into clear analytical requirements, data models, measures, visualizations, and user experiences.
• Build scalable, reusable reporting solutions that balance enterprise consistency with the needs of specific stakeholder groups.
• Analyze workforce data to identify meaningful trends, patterns, relationships, and opportunities across topics such as workforce composition, talent movement, retention, recruiting, engagement, and organizational health.
• Develop concise narratives and recommendations that connect analytical findings to business decisions and actions.
• Continuously improve reporting solutions based on user feedback, adoption, changing priorities, and evolving business needs.

Data Preparation, Modeling, and Quality

• Combine and transform data from multiple HR and business sources into reliable datasets for analysis and reporting.
• Develop and maintain semantic models, calculations, metric definitions, and reporting logic that support consistent interpretation of workforce information.
• Write and optimize SQL queries and use appropriate data preparation tools to support reporting and analysis.
• Validate data, investigate discrepancies, document business rules, and partner with data owners to resolve quality issues.
• Apply data governance, privacy, security, and access requirements throughout the design and delivery of workforce intelligence products.
• Maintain clear documentation for data sources, definitions, transformations, assumptions, and known limitations.

AI-Enabled Productivity and Self-Service

• Use approved AI assistants to support activities such as requirements synthesis, code development, documentation, quality checks, insight summarization, and content refinement, with appropriate human review.
• Design and help build agentic, conversational, or natural-language solutions that enable users to access and navigate approved Workforce Intelligence content and use cases through self-service.
• Ground AI-enabled experiences in governed data, approved metrics, curated knowledge, role-based access, and clear business rules.
• Partner with product, data, technology, security, privacy, legal, and governance teams to test and operationalize AI-enabled self-service solutions responsibly.
• Evaluate AI-enabled experiences for usefulness, accuracy, transparency, adoption, and appropriate escalation to human experts.
• Help users understand the appropriate application and limitations of AI-supported insights. Advanced modeling and machine learning development will be completed in partnership with specialized teams when needed.

Stakeholder Partnership and Insight Delivery

• Partner with Workforce Intelligence consultants, HR partners, and business stakeholders to clarify needs, frame business questions, and prioritize analytical work.
• Facilitate discovery sessions, define success criteria, and convert broad requests into practical BI solutions.
• Present complex information in a clear, concise, and actionable