McKesson Analyst, Business Intelligence, Retail Pharmacy 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:

The Retail Banner Group (GDN/IDA/RRx/MSC/Uniprix/Proxim) BI Analyst responsibilities include the development of data warehousing and reporting capabilities. The Analyst is responsible for supporting the analytical needs of the Retail Banner Group, supporting Operations, Category Management, Pharmacy Services, Marketing and other departments with data related requirements. He/She will be required to meet with different levels of the Retail Banner Group to receive and interpret reporting requirements and transform their needs into meaningful, actionable reporting and insights. The analyst will be required to design, develop, execute and distribute reports and complex scorecards from various data sources both internal to McKesson, such as distribution data, dispense, point of sale, loyalty, marketing data, as well as external data such as IQVIA, Nielsen, Stats Can, etc. In addition, the analyst will be required to create and automate new data sources, as well as develop a clear understanding of existing information and processes in order to enhance and streamline their production. The Analyst will report to the Supervisor, BI and Data Aggregation.

Key Responsibilities

The Analyst:

Data aggregation

  • Acquire data from primary or secondary data sources and maintain databases/data systems

  • Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems

  • Locate and define new process improvement opportunities

  • Track and document data sources, validation practices and utilization across the Retail Banner

  • Investigate problems and inconsistencies with information provided to clients and coordinates correction

  • Design new BI solutions incorporating multiple data sets in order to automate queries

  • Identify, standardize and automate new data sources

BI and Scorecarding

  • Identify, analyze, and interpret trends or patterns in complex data using advanced analytics and statistical techniques to inform business strategies

  • Work with preferred external partners on data management, development and score card implementation

  • Implement reporting automation

  • Maintain and execute standardized / automated data base score cards

  • Assist in the identification, selection and business case preparation for new tools or resources required to continue to advance dashboard, scorecard, report and data usage

  • Create and maintain customer specific business review dashboards

  • Execute the analytical reporting plan establishing appropriate due dates, formats, frequency, audience etc.

  • Drive adoption of BI and data analytics culture throughout the Retail Banner Group

  • Mine and interpret data in order to provide insights.

Capacity Building

  • Support Supervisor in the development and implementation of databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality

  • Work with management to prioritize business and information needs

  • Ensure the automation and streamlining of all processes

  • Takes part in cross functional teams on data driven projects

  • Trains and supports user community

  • Ensures reporting best practices across RBG and with top tier external peers

  • Executes processes and solutions that meet ethical and legal obligations when providing information internally and externally and flags breaches when required Competency Development

  • Design, develop and distribute reports and dashboards to track business performance indicators

  • Provides support and training to internal clients on new tools and data sources


  • 3-5 years working experience as a data analyst or business data analyst

  • BS in Mathematics, Economics, Computer Science, Information Management or Statistics

  • Technical expertise regarding data models, database design development, data mining and segmentation techniques

  • Strong knowledge of and experience with analytics and reporting packages (Business Objects, Tableau, Alteryx, PowerBI, Birst, etc.), databases (SQL etc.), programming (XML, Javascript, or ETL frameworks)

  • Knowledge of statistics and experience using statistical packages (SAS, etc.)


  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

  • Strong communication skills in French and English

  • Adept at queries, report writing and presenting findings

  • Strong collaboration skills

  • Strong attention to detail

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.

Qualified applicants will not be disqualified from consideration for employment based upon criminal history.

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: Sales/Client Management

Organization: McKesson Canada

Title: Analyst, Business Intelligence, Retail Pharmacy

Location: Canada-Quebec-Montreal

Requisition ID: 18007939