Analyste Principal en Intelligence d'affaires/Senior Business Intelligence Analyst
Apply NowCompany: McKesson
Location: Montreal, QC H1A 0A1
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.
Rsum du poste
Le Analyste principal en intelligence d'affaires Donnes Commerciales, relve du Responsable de la Qualit et de la Gouvernance des Donnes Commerciales et agit en tant que partenaire commercial senior auprs de l'organisation McKesson Canada Data & Analytics Hub. Il veille ce que l'quipe d'Intelligence Commerciale dispose d'analyses avances et d'informations concernant les performances de l'entreprise et des clients, le paysage concurrentiel, les tendances du secteur et la planification financire. Ce rle reprsente le Spoke dans les interactions avec le Canada Data & Analytics Hub et pilote l'intgration des donnes, la modlisation des donnes et la qualit des donnes au sein de l'quipe.
Responsabilits spcifiques
Exigences du poste
Job Summary
The Senior Business Intelligence Analyst, Commercial Data reports to the Manager, Commercial Data Quality & Governance and acts as a senior business partner to the McKesson Canada Data & Analytics Hub organization to ensure the Commercial Intelligence team has advanced analytics and insights pertaining to the business and customer performance, the competitive landscape, industry trends and financial planning. This role represents the Spoke in interactions with the Canada Data & Analytics Hub and drives the data integration, data modelling and data quality within the team.
Specific Responsibilities
A subject matter expert in BI programming language (SQL, R, Phyton, DAX) that will support the entire Marketing & Commercial Operations organization, including internal team
Work with BI Analysts and other stakeholders to gather the data needs to further develop a comprehensible data model
Develops and maintains multiple data models, data flows and data sets for internal team in accordance with governance guidelines and policies
Defines the process, standards, and guidelines for multiple data models, data flows and data sets for internal team
Participates in the Enterprise Data Governance Operating Model as a Data Steward to document all critical data elements
Acts as the primary point of contact between the Spoke and Canada Data & Analytics Hub
Support with consolidating and prioritizing requests submitted to Canada Data & Analytics Hub from the Spoke
Act as a functional data domain expert to contribute to and advise on Data & Analytics decisions and initiatives
Provides input into the enterprise data strategy and shape any business unit specific data strategies
Support Data & Analytics initiatives by validating data sources, calculations, and outputs
Disseminate information and communications between the Canada Data & Analytics Hub and the Spoke
Position Requirements
University degree in relevant discipline
Minimum 5 years of experience in Data and Analytics space in different capacities
Good knowledge of SQL (CTE's, window functions and joins), Python, R and DAX
Knowledge and experience with Snowflake, SQL Server, CRM (Salesforce) and SAP
ETL / Data Warehousing understanding
Hands on experience with Power BI
Advanced knowledge of the MS Office products (Excel, Power BI, PowerPoint, Word)
Strong attention to detail
High sense of urgency with ability to multi-task, work proactively and independently in a fast-paced, dynamic environment
Strong analytical and problem-solving skills with organization and autonomy
Ability to collaborate with various levels of management and employees
Experience with data quality tools is an asset
Strong written and verbal communication skills
Ability to champion change at all levels
Ability to travel when needed
We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. The pay range shown below is aligned with McKesson's pay philosophy, and pay will always be compliant with any applicable regulations. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, please click here.
Our Base Pay Range for this position
$85,400 - $142,400
McKesson is an Equal Opportunity Employer
McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson's full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.
Join us at McKesson!
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.
Rsum du poste
Le Analyste principal en intelligence d'affaires Donnes Commerciales, relve du Responsable de la Qualit et de la Gouvernance des Donnes Commerciales et agit en tant que partenaire commercial senior auprs de l'organisation McKesson Canada Data & Analytics Hub. Il veille ce que l'quipe d'Intelligence Commerciale dispose d'analyses avances et d'informations concernant les performances de l'entreprise et des clients, le paysage concurrentiel, les tendances du secteur et la planification financire. Ce rle reprsente le Spoke dans les interactions avec le Canada Data & Analytics Hub et pilote l'intgration des donnes, la modlisation des donnes et la qualit des donnes au sein de l'quipe.
Responsabilits spcifiques
- tre un expert en langage de programmation BI (SQL, R, Python, DAX) pour soutenir l'ensemble de l'organisation Marketing et Oprations Commerciales, y compris l'quipe interne.
- Travailler avec les analystes BI et d'autres parties prenantes pour rassembler les besoins en donnes afin de dvelopper un modle de donnes comprhensible.
- Dvelopper et maintenir plusieurs modles de donnes, flux de donnes et ensembles de donnes pour l'quipe interne conformment aux directives et politiques de gouvernance.
- Dfinir le processus, les normes et les lignes directrices pour plusieurs modles de donnes, flux de donnes et ensembles de donnes pour l'quipe interne.
- Participer au Modle Oprationnel de Gouvernance des Donnes de l'Entreprise en tant que Data Steward pour documenter tous les lments de donnes critiques.
- Agir en tant que point de contact principal entre le Spoke et le Canada Data & Analytics Hub.
- Soutenir la consolidation et la priorisation des demandes soumises au Canada Data & Analytics Hub par le Spoke.
- Agir en tant qu'expert fonctionnel du domaine des donnes pour contribuer et conseiller sur les dcisions et initiatives en matire de Donnes & Analytique.
- Fournir des contributions la stratgie de donnes de l'entreprise et faonner toute stratgie de donnes spcifique une unit commerciale.
- Soutenir les initiatives de Donnes & Analytique en validant les sources de donnes, les calculs et les rsultats.
- Diffuser les informations et les communications entre le Canada Data & Analytics Hub et le Spoke.
Exigences du poste
- Diplme universitaire dans une discipline pertinente.
- Minimum de 5 ans d'exprience dans le domaine des Donnes et de l'Analytique diffrents postes.
- Bonne connaissance de SQL (CTE, fonctions de fentre et jointures), Python, R et DAX.
- Connaissance et exprience avec Snowflake, SQL Server, CRM (Salesforce) et SAP.
- Comprhension de l'ETL / Data Warehousing.
- Exprience pratique avec Power BI.
- Connaissance avance des produits MS Office (Excel, Power BI, PowerPoint, Word).
- Forte attention aux dtails.
- Sens lev de l'urgence avec capacit grer plusieurs tches, travailler de manire proactive et indpendante dans un environnement dynamique et rapide.
- Comptences analytiques et de rsolution de problmes solides avec organisation et autonomie.
- Capacit collaborer avec diffrents niveaux de gestion et employs.
- L'exprience avec des outils de qualit des donnes est un atout.
- Comptences solides en communication crite et verbale.
- Capacit promouvoir le changement tous les niveaux.
- Capacit voyager au besoin.
Job Summary
The Senior Business Intelligence Analyst, Commercial Data reports to the Manager, Commercial Data Quality & Governance and acts as a senior business partner to the McKesson Canada Data & Analytics Hub organization to ensure the Commercial Intelligence team has advanced analytics and insights pertaining to the business and customer performance, the competitive landscape, industry trends and financial planning. This role represents the Spoke in interactions with the Canada Data & Analytics Hub and drives the data integration, data modelling and data quality within the team.
Specific Responsibilities
A subject matter expert in BI programming language (SQL, R, Phyton, DAX) that will support the entire Marketing & Commercial Operations organization, including internal team
Work with BI Analysts and other stakeholders to gather the data needs to further develop a comprehensible data model
Develops and maintains multiple data models, data flows and data sets for internal team in accordance with governance guidelines and policies
Defines the process, standards, and guidelines for multiple data models, data flows and data sets for internal team
Participates in the Enterprise Data Governance Operating Model as a Data Steward to document all critical data elements
Acts as the primary point of contact between the Spoke and Canada Data & Analytics Hub
Support with consolidating and prioritizing requests submitted to Canada Data & Analytics Hub from the Spoke
Act as a functional data domain expert to contribute to and advise on Data & Analytics decisions and initiatives
Provides input into the enterprise data strategy and shape any business unit specific data strategies
Support Data & Analytics initiatives by validating data sources, calculations, and outputs
Disseminate information and communications between the Canada Data & Analytics Hub and the Spoke
Position Requirements
University degree in relevant discipline
Minimum 5 years of experience in Data and Analytics space in different capacities
Good knowledge of SQL (CTE's, window functions and joins), Python, R and DAX
Knowledge and experience with Snowflake, SQL Server, CRM (Salesforce) and SAP
ETL / Data Warehousing understanding
Hands on experience with Power BI
Advanced knowledge of the MS Office products (Excel, Power BI, PowerPoint, Word)
Strong attention to detail
High sense of urgency with ability to multi-task, work proactively and independently in a fast-paced, dynamic environment
Strong analytical and problem-solving skills with organization and autonomy
Ability to collaborate with various levels of management and employees
Experience with data quality tools is an asset
Strong written and verbal communication skills
Ability to champion change at all levels
Ability to travel when needed
We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. The pay range shown below is aligned with McKesson's pay philosophy, and pay will always be compliant with any applicable regulations. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, please click here.
Our Base Pay Range for this position
$85,400 - $142,400
McKesson is an Equal Opportunity Employer
McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson's full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.
Join us at McKesson!