Analyste en intelligence d'affaires (hybride)/ Business Intelligence Analyst (Hybrid)

McKesson; Canada; On-site; CAD 66,000 - 111,000; Full time

Job summary

This innovative firm is seeking a BI Analyst who will play a crucial role in managing and optimizing reporting processes. You will be responsible for delivering insights that support informed decision-making in healthcare, impacting millions of lives across Canada. With a focus on continuous improvement, you'll analyze customer needs, manage report requests, and utilize tools like SQL and Power BI. Join a team that values growth and collaboration, where your contributions will help shape the future of health. If you're passionate about making a difference and thrive in a dynamic environment, this opportunity is perfect for you.

Benefits

Comprehensive benefits

Annual bonus opportunities

Long-term incentive opportunities

Qualifications

• 4+ years in Business Intelligence and Advanced Analytics.
• Proficient in SQL, Power BI, and MS Access.

Responsibilities

• Manage report portal inbox and fulfill report requests efficiently.
• Analyze customer needs and optimize reporting processes.

Skills

SQL

Power BI

MS Access

Data Warehousing

Bilingual (French and English)

Attention to Detail

Education

Bachelor’s Degree in Business Intelligence

Bachelor’s Degree in Computer Science

Bachelor’s Degree in Engineering

Bachelor’s Degree in Statistics

Tools

SSRS Portal

Databricks

R

Python

Excel

Word

PowerPoint

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

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

The BI Analyst is responsible for efficiently managing and supporting the production and delivery of reports in accordance with established schedules. He/she will oversee the McKesson report portal inbox, addressing both scheduled and adhoc report requests. The BI Analyst will analyze customer needs, document reporting processes and requirements, and optimize them for enhanced efficiency. He/she will develop and maintain information tools and reports, making recommendations for enhancements when necessary. Managing the SSRS Portal reports, including creating, modifying, and deleting them. The BI Analyst plays a vital role in ensuring accurate and timely reporting, optimizing reporting processes, and providing valuable insights to support informed decision-making.

Section A – Specific Responsibilities

1. Efficiently manage the McKesson report portal inbox through proactive communication, prompt response, and effective expectation setting
2. Support of scheduled report production and delivery (daily, weekly, monthly, yearly, etc.)
3. Process, prioritize, and fulfill on-demand/adhoc report requests efficiently
4. Manage external data requests and ensure accurate information is provided
5. Analyze and identify customer requirements for reports
6. Document and optimize reporting processes
7. Ensure consistent data quality standards for information tools and reports by conducting regular audits and implementing corrective measures when necessary
8. Create, edit, and delete reports within the SSRS Portal, effectively overseeing their management
9. Mentors and trains internal stakeholders in SSRS/ Cube reporting

Section B – Position Requirements

• Minimum 4 years’ experience in Business Intelligence and/or Advanced Analytics
• Bachelor’s Degree in Business Intelligence, Computer Science, Engineering, Statistics, or related field required
• Proficient in SQL to query off databases such as Oracle and Snowflake
• Minimum 2 year's experience with Power BI
• Good knowledge of MS Access and some knowledge of Databricks, R and/or Python. Proficient in the use of PC based office software (Access, Excel, Word, PowerPoint, etc.) ETL / Data Warehousing understanding
• Willingness to learn in an environment in constant evolution and transformation
• Details oriented and very organized
• Bilingual (French and English)
• Hands on experience with multiple data sources including structured and unstructured data sources
• Experience or knowledge of datascience techniques and advanced analytics approaches. Experience working in agile team/Scrum

The incumbent of this position will provide daily support to internal and/or external clients outside Quebec and/or in the United States. Therefore, he/she must be proficient in spoken and written English.

Career Level – IC – Professional – P3

At McKesson, we care about the well-being of the patients and communities we serve, and that starts with caring for our people. That’s why we have a Total Rewards package that includes comprehensive benefits to support physical, mental, and financial well-being. Our Total Rewards offerings serve the different needs of our diverse employee population and ensure they are the healthiest versions of themselves. For more information regarding benefits at McKesson, please click here.

As part of Total Rewards, we are proud to offer a competitive compensation package at McKesson. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered.

Our Base Pay Range for this position

$66,400 - $110,600

McKesson is an Equal Opportunity employer.