McKesson Analyst, Systems and Analytics in Quebec, Canada

McKesson is in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. At McKesson Canada, we touch the lives of 12 million Canadians every day. We carry more than 35,000 products in 17 distribution centers and ultimately provide distribution to 6,300 retail pharmacies, 1,350 hospitals, long-term care centers, clinics and institutions all over Canada. But we're so much more than a distribution company. We've automated 2,500 retail pharmacies and dispense over 100 million doses a year through our automation solutions. Manufacturers, healthcare providers and patients count on us for a full range of services that contribute to the quality and safety of care for us all.

At McKesson Canada, you’ll help us carry out our mission to improve lives and advance healthcare. Working here is your opportunity to shape an industry that’s vital to us all.

Job Summary

Reporting to the Manager, Systems and Analytics, the Analyst, Systems and Analytics performs all database, planogram and replenishment system parameter setup, maintenance, and adjustments to assist Procurement Strategy and Procurement Operations with required technical analyses. Responsibilities include designing, programming, testing, implementing and training of end-users. The Analyst, Systems and Analytics collaborates with IT to analyze requirements, document, understand, change, improve, configure, and build applications and systems. The role includes managing reporting processes and providing the management team and Procurement Strategy and Procurement Operations with recommendations, analytics, business intelligence and timely decision-making information and metrics on service level, aged inventory, slow moving and obsolete products, as well as vendor performance. Additionally, the Analyst, Systems and Analytics is responsible for the deployment, maintenance and continuous improvement of technology solutions between suppliers and McKesson Canada. This includes identifying and executing opportunities to further improve information flow efficiency by developing, coordinating and implementing systems using Electronic Data Interchange (EDI) standards and XML-based web solutions, performing business process analyses, identifying gaps, and implementing solutions to streamline procurement procedures utilizing standards and best practices for electronic connectivity.

Section A – Specific Responsibilities

System Development and Configuration (40%)

  • Is responsible for Procurement Operations databases, systems (including replenishment, service level, inventory, returns, product availability, and planogram) and reporting tools.

  • Develops and/or re-engineers databases and parameters to measure appropriate performance metrics, according to the consistency and targets desired.

  • Drives alignment of various systems that impact order suggestions and replenishment plans while collaborating with Information Technology.

  • Analyzes business, functional and technical requirements to choose, upgrade, develop or configure applications and systems.

  • Develops appropriate parameter configuration via economic order quantities (EOQ) to foster the optimal order suggestions and facilitate purchase order management.

  • Maintains roles and authorizations within the different systems and databases and documents all databases and applications developed.

  • Works closely with programmers, power users and other key stakeholders to maintain or improve existing systems and applications, and to build new designs.

  • Performs testing, troubleshooting and resolution of database and data issues.

Analytics (40%)

  • Is responsible for detailed analyses and making recommendations on inventory levels/issues, communicating operational risks and providing recommendations for service and inventory options and initiatives to ensure KPIs stay in line with McKesson targets.

  • Provides procurement teams with decision-making information through consistent reporting, metrics and business intelligence (e. g. service levels, inventory turnover, capacity, conformity, and replacements/substitutes to mitigate loss or drive buy-side revenue) on procurement activities.

  • Analyzes optimal replenishment quantities/economic order quantity (EOQ) and makes recommendations to optimize.

  • Analyzes new items, new vendors, and new parameterizationto support product life cycle management (product selection, phase-in and phase-out).

  • Develops reports on customer returns, warehouse inventory damages and adjustments, as well as losses on returns.

  • Manages data related to vendor performance (global and local agreements) and communicates results in preparation for business reviews with vendors.

  • Measures inventory commitments and buys, overstocks, out-of-stocks, aged inventory, non-compliance, and general vendor performance and supports the realization of expected gains and return-on-capital.

  • Is responsible for providing meaningful insights to capitalize on manufacturer price changes, opportunity buys, inventory transfers, and provincial formulary changes.

Procurement Connectivity (15%)

  • Is responsible for supplier connectivity, including all electronic transactions and resolving supplier non-compliance issues and incidents.

  • Manages new listings setup to conform to connectivity requirements and standards and makes decisions on connectivity parameters.

  • Manages critical information such as EDI details, supplier profile specifications and parameters and makes decisions to accept or reject supplier setup proposals.

  • Ensures Inter-trade web portal data is current and is the primary point of contact for all EDI related issues (supplier side) as well as troubleshoots to resolve.

  • Resolves connectivity issues including communication failures; makes decisions regarding recovery and mitigation strategies to ensure flow of goods to avoid out of stock inventory issues on purchased products. Identifies EDI non-compliant vendors and makes decision regarding penalties.

  • Analyzes reports and metrics, including acknowledgements and ASN error exceptions, with Distribution Center (DC) Operations and suppliers related to controlled substances.

  • Manages the McKesson E-signature process, including roll-out activities with new vendors.

Section B – General Responsibilities

Other (5%)

  • Maintains relevant business knowledge of product categories and stays abreast of market and industry trends and conditions.

  • Acts as a McKesson ambassador of corporate values.

Section C – Position Requirements

Working Experience

  • 3-5 years of experience in database and systems management and/ information technology, the majority in a supply chain and procurement management context.

  • Retail/Wholesale/Life Sciences experience an asset.

  • Application/database development or programming.


  • Bachelor’s degree in Business Administration, Operations Management, Information Technology, Computer Science, Mathematics, Engineering, or equivalent.

Personal Development and Soft Skills

  • Strong analytical skills.

  • Demonstrated leadership.

  • Excellent partnering skills.

  • Excellent communication skills.

  • Ability to collaborate with various levels of management and employees.

Technical Skills

  • Perfectly bilingual, both written and spoken.

  • Proficiency with ERP systems and replenishment systems an asset.

  • Extensive knowledge of MS Office products (Power Point, Excel, Word, Project and Visio).

  • Knowledge with EDI and XML web-based technology.

  • Experience with VBA, VB.NETKnowledge of SQL 2016, SSRS 2016 & Power BI (asset)

  • Knowledge of procurement processes.

Other Skills and Capabilities

  • Ability to work as part of multi-functional teams.

  • Attention to detail, whilst maintaining a strong sense of summary and ability to synthesize.

  • Team player.

  • Ability to identify operational and strategic issues and proactively drive solutions.

Benefits & Company Statement

McKesson believes superior performance – individual and team – that helps us drive innovations and solutions to promote better health should be recognized and rewarded. We provide a competitive compensation program to attract, retain and motivate a high-performance workforce, and it’s flexible enough to meet the different needs of our diverse employee population.

We are in the business of better health and we touch the lives of patients in virtually every aspect of healthcare. We partner with payers, hospitals, physician offices, pharmacies, pharmaceutical companies and others across the spectrum of care to build healthier organizations that deliver better care to patients in every setting.

But we can’t do it without you. Every single McKesson employee contributes to our mission—whatever your title, whatever your role, you act as a catalyst in a chain of events that helps millions of people all over the globe. Talented, compassionate people are the future of our company—and of healthcare. At McKesson, you’ll collaborate on the products and solutions that help us carry out our mission to improve lives and advance healthcare. Working here is your opportunity to shape an industry that’s vital to us all.

Agency Statement

No agencies please.

Recruiting Disclaimer

The material contained herein is provided for informational purpose only. All open jobs offered by McKesson Canada on this recruitment system are subject to specific job skill requirements. The job skill requirements, qualifications, and preferred experience are determined by a subsidiary, office or department within the company which is offering the position, and all positions are subject to local prevailing employment laws and restrictions. This would include immigration laws pertaining to work authorization requirements and any other applicable government permissions or compliance.

The materials on this site are provided without warranties of any kind, either expressed or implied, including but not limited to warranties regarding the completeness of information contained on this site or in any referenced links. While McKesson Canada attempts to update this site on a timely basis, the information is effective only as of the time and date of posting.

By providing your application to McKesson Canada you hereby consent to McKesson Canada obtaining personal information regarding you that is related to the position applied for. You also consent to McKesson Canada transferring your application details to our recruitment partners for their review and assistance. You also consent to McKesson Canada keeping your application on file.

McKesson Canada is an equal opportunity employer and values diversity in its workforce. We encourage applications from all qualified individuals and will accommodate applicants' needs, up to the point of undue hardship, throughout all stages of the recruitment and selection process.

The information on this site is for information purpose only and is not intended to be relied upon with legal consequence.

Job: Customer Care

Organization: McKesson Canada

Title: Analyst, Systems and Analytics

Location: Canada-Quebec-Saint-Laurent

Requisition ID: 18001681