Analyste principal(e) en intelligence d’affaires/ Senior Analyst, Business Intelligence (contrat 12 mois)
Role Overview
The Senior BI Analyst supports McKesson Canada’s pharmaceutical distribution business by developing business intelligence content.
The role works with analysts and management on interactive reports and dashboards to assess performance, identify trends, and solve problems.
Responsibilities include capturing requirements, querying data sources, building data models, and developing BI reports.
Key Skills for This Role
Full Job Posting
Job summary
The Senior BI Analyst supports McKesson Canada’s pharmaceutical distribution business by developing business intelligence content.
The role works with analysts and management on interactive reports and dashboards to assess performance, identify trends, and solve problems.
Responsibilities include capturing requirements, querying data sources, building data models, and developing BI reports.
Key responsibilities
- Define business problems with management and analysts, capture requirements, and translate them into data models and measures.
- Use SQL to gather and assess data from reporting and transactional databases, operational data stores, and external systems.
- Create data models and DAX measures for data visualization.
- Build interactive reports using Microsoft Power BI.
- Implement emerging data analytics technology to foster supply-chain innovation.
- Assess database data quality and coordinate with IT to correct source data or create translation sources.
- Research business data analysis practices through publications, training, and professional development.
- Communicate BI content and Power BI usage to stakeholders.
Required qualifications
- At least three years of related experience in business intelligence or a highly analytical business function.
- Strong analytical ability to structure ill-defined problems and troubleshoot issues.
- Experience generating SQL queries and knowledge of SQL, Oracle, and Snowflake databases and architecture.
- Ability to troubleshoot data quality problems.
- Experience using Power BI or a similar BI platform.
- Bachelor’s degree in a related field, such as computer science, mathematics, or engineering.
- Proficiency in spoken and written English for daily client support outside Quebec and/or in the United States.
Additional assets
- Experience with Microsoft Power Platform, including Power BI, Power Apps, and Power Automate.
- Strong knowledge of DAX and M Query; understanding of data models and Power BI report design with attention to user experience.
- Knowledge of AI tools, machine learning, natural language processing, and statistical models for predictive analytics.
- Familiarity with Python.
- French and English bilingualism, written and spoken, is listed as an asset.
- Ability to build credibility and rapport across the organization and persuasively promote ideas and proposals.
Compensation
- The employer describes a competitive compensation package; base pay and possible bonus or long-term incentives depend on factors including experience, skills, and market.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at McKesson
Senior Analyst, Business Intelligence (12 month Contract)
Mississauga, CAN
Sr. Analyst, Visualization (RAIB)
Mississauga, CAN
Analyste principal(e) en intelligence d’affaires/ Senior Analyst, Business Intelligence (contrat 12 mois)
, CAN
McKesson is seeking a senior business intelligence analyst to build interactive reports, dashboards, and data models for its pharmaceutical distribution business. The role requires at least three years of relevant experi
Business Process Analyst
, USA
Senior Analyst, Business Intelligence (12 month Contract)
Mississauga, CAN
Sr. Analyst, Visualization (RAIB)
Mississauga, CAN
Analyste principal(e) en intelligence d’affaires/ Senior Analyst, Business Intelligence (contrat 12 mois)
, CAN
Warehouse Worker - Full Time Shift
, USA
Material Handler - Full Time Shifts
, USA
Material Handler - Full Time Shift
, USA
Associate Biomed Technician
, USA