Job Description

McKesson requires new employees to be fully vaccinated for COVID-19 as defined by Health Canada, subject to applicable, verified accommodation requests.

McKesson touche la vie des patients en A"uvrant dans pratiquement tous les secteurs des soins de sante dans le but daEUR(TM)ameliorer la sante en general. Chez McKesson Canada, nous creons un impact dans la vie de 12 millions de Canadiens, chaque jour. Nous distribuons plus de 35 000 produits a partir de 12 centres de distribution a 6 300 pharmacies de detail, 1 350 hapitaux, centres de sante longue duree, cliniques et etablissements de sante partout au Canada. Toutefois, nous sommes beaucoup plus qu'une entreprise de distribution. Nous avons automatise 2 500 pharmacies de detail et distribuons annuellement plus de 100 millions de doses de medicaments grace a nos solutions d'automatisation. Les fabricants, les fournisseurs de soins de sante et les patients comptent sur nous pour une gamme complate de services qui contribuent a la qualite et l'integrite des soins de sante pour le benefice de tous.

Chez McKesson, vous participerez a la creation de produits et de solutions qui contribuent a la realisation de la mission de laEUR(TM)entreprise, soit ameliorer la qualite de vie et faire progresser les soins de sante. Travailler ici represente une occasion daEUR(TM)edifier une industrie qui est vitale pour nous tous.

Resume de laEUR(TM)emploi

Relevant du directeur - Intelligence des affaires, Centre daEUR(TM)excellence de laEUR(TM)analyse de la chaane daEUR(TM)approvisionnement, laEUR(TM)analyste principal utilisera ses competences pour creer du contenu daEUR(TM)intelligence des affaires a laEUR(TM)appui du plus grand secteur daEUR(TM)activite de McKesson Canada, les secteurs de la distribution pharmaceutique. LaEUR(TM)analyste principal collaborera avec les analystes operationnels et la direction pour creer des rapports de donnees et des tableaux de bord interactifs afin daEUR(TM)evaluer laEUR(TM)etat actuel des activites, de cerner les tendances et de resoudre les problames. Votre rale consistera a saisir les besoins, a interroger les sources de donnees existantes, a creer des modales de donnees et des rapports daEUR(TM)information operationnelle.

Le candidat ideal doit posseder les qualifications suivantes :

• Au moins 3 ans daEUR(TM)experience professionnelle dans le domaine de la Business Intelligence ou dans une fonction hautement analytique

• Rigueur analytique - capacite a structurer des problames mal definis et a les resoudre

• Experience de la generation de requates SQL

• Connaissance des bases de donnees et de laEUR(TM)architecture SQL/Oracle/Snowflake

• Capacite a resoudre les problames de qualite des donnees

• Solide connaissance de Power BI ou daEUR(TM)une plateforme de veille strategique similaire.

Les qualifications suivantes sont considerees comme des atouts :

• Experience de la plateforme MS Power (Power BI, Power Apps et Power Automate)

• Solide connaissance du langage DAX et M Query

• Comprehension des modales de donnees et etablissement de rapports Power BI en mettant laEUR(TM)accent sur laEUR(TM)interphase des utilisateurs.

• Connaissance des outils daEUR(TM)IA comme laEUR(TM)apprentissage automatique et le langage naturel des requates.

• Comprehension des modales statistiques utilises dans laEUR(TM)analyse predictive (p. ex., regressions)

• Connaissance de Python

• Bilingue, tant a laEUR(TM)ecrit quaEUR(TM)a laEUR(TM)oral.

• Capacite a developper des relations et une credibilite au sein de laEUR(TM)organisation, a promouvoir des idees et des propositions de maniare persuasive.

Responsabilites Principales

• Interagir avec la direction et les analystes pour definir les problames commerciaux actuels, saisir les exigences et traduire ces exigences pour construire des modales de donnees et des mesures.

• Utiliser le langage de requate structuree (SQL) pour recueillir et evaluer les donnees de la base de donnees de rapports, de la base de donnees transactionnelle, du magasin de donnees operationnelles et des systames externes afin daEUR(TM)aider le leadership interne et externe dans la prise de decisions.

• Fournir du contenu de veille strategique en creant des modales de donnees et des mesures DAX pour la visualisation des donnees.

• Creer des rapports de visualisation de donnees hautement interactifs et eclairants a laEUR(TM)aide de MS Power BI.

• Mettre en A"uvre laEUR(TM)utilisation de nouvelles technologies daEUR(TM)analyse des donnees pour favoriser laEUR(TM)innovation au sein de la chaane daEUR(TM)approvisionnement de McKesson Canada.

• a?value continuellement la qualite des donnees dans laEUR(TM)ensemble de la base de donnees et coordonne avec les TI la correction des donnees sources ou la creation de sources de traduction, le cas echeant.

• Rechercher et identifier continuellement les meilleures pratiques pour laEUR(TM)analyse des donnees commerciales au moyen de publications, de formations formalisees et daEUR(TM)efforts de developpement professionnel.

• Communiquer et diffuser des informations sur le contenu et la faaon daEUR(TM)utiliser Power BI aux differentes parties prenantes.

Formation Scolaire

Diplame de premier cycle dans un domaine connexe (p. ex., en informatique, en mathematiques, en genie).



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 12 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, youaEUR(TM)ll help us carry out our mission to improve lives and advance healthcare. Working here is your opportunity to shape an industry thataEUR(TM)s vital to us all.

Job Summary

Reporting to the Director - Business Intelligence, Supply Chain Analytics COE, the Senior Analyst will use their skills to create business intelligence content in support of McKesson CanadaaEUR(TM)s largest business segment, the Pharma Distribution businesses. The Senior Analyst will collaborate with business analysts and management to build interactive data reports and dashboards to assess the current state of the business, identify trends and solve problems. Your role will be to capture requirements, query existing data sources, build data models and BI reports.

The ideal candidate will have the following qualifications:

At least 3+ years of related work experience in Business Intelligence or a highly analytical business function

Analytical Rigor - ability to bring structure to ill-defined problems and troubleshoot problems

Experience generating SQL queries

Knowledge of SQL/Oracle/Snowflake databases and architecture is required

Ability to troubleshoot data quality problems

Strong familiarity with Power BI or a similar business intelligence platform.

In addition, the following qualifications are considered assets:

Experience with MS Power Platform (Power BI, Power Apps and Power Automate)

Strong knowledge of DAX and M Query language

Understanding of data models and building Power BI reports with an emphasis on the user interphase.

Knowledge of AI tools such as machine learning and natural query language.

Understanding of statistical models used in predictive analytics (e.g. regressions)

Knowledge of Python

Bilingual, both written and spoken.

Ability to develop rapport and credibility across the organization, promote ideas and proposals persuasively.

Key Responsibilities

Interact with management and analysts to define current business problems, capture requirements, and translate these requirements to build data models and measures.

Use Structured Query Language (SQL) to gather and assess data from the reporting database, transactional database, operational data store, and external systems to assist internal and external leadership in decision making.

Provide business intelligence content by creating data models and DAX measures used for data visualization.

Build highly interactive and insightful data visualization reports using MS Power BI.

Implement the use of emerging data analytics technology to foster innovation within McKesson CanadaaEUR(TM)s supply chain.

Continually assesses data quality throughout the database and coordinates with IT in the correction of source data or creation of translation sources, where applicable.

Continually researches and identify best practices for business data analysis via published literature, formalized training, and professional development efforts.

Communicates and disseminates information about content and how to use Power BI to the various stakeholders.

EDUCATIONAL EXPERIENCE

BachelorsaEUR(TM) degree in a related field (e.g. computer science, mathematics, engineering).

#LI-JT2

Worker Type Regular

McKesson is an Equal Opportunity employer.

The material contained herein is provided for informational purpose only. All open jobs offered by McKesson 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 attempts to update this site on a timely basis, the information is effective only as of the time and date of posting.

McKesson 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.

Current employees must apply through internal career site.

Join us at McKesson!