LOCATION:

243 Consumers Road, Toronto, Ontario, M2J 4W8
At Shoppers Drug Mart, we’re innovating health and wellness in Canada. From prescriptions to walk-in clinics, and a beloved loyalty program, we’re caring and supporting our customers in new ways every day.
With more than 1,300 locally owned and operated stores from coast to coast, the Shoppers Drug Mart network is more than a great place to shop, it’s a great place to work. We’re committed to building our talented team who champion collaboration, kindness and inclusivity. Join our team, and help recognize a healthy future for your career and for all Canadians.

REQUIRED QUALIFICATIONS:

• Bachelor’s or Master’s degree in Data Analytics, Statistics, Health Informatics, Computer Science, Epidemiology, or a related field.
• 5+ years of experience in data analysis, preferably in healthcare, pharmacy, or insurance analytics.
• Advanced SQL programming skills (query optimization, stored procedures, complex joins, CTEs, etc.).
• Expertise in statistics, hypothesis testing, A/B testing, and experimental design is an asset.
• Proficiency in Excel (PivotTables, Power Query, VBA, data visualization tools).
• Ability to translate data into meaningful insights and communicate findings effectively to stakeholders.
• Strong problem-solving skills, attention to detail, and ability to manage multiple projects simultaneously.
• Strong verbal and written communication skills and presentation skills.
• Understanding the healthcare domain, with a passion and desire to make a positive impact is a plus.
• Experience in developing Power BI dashboards and reports is an asset.
• Proficiency in Python programming for data analysis and automation is a plus.

PREFERRED QUALIFICATIONS:

• Experience working with healthcare claims data, pharmacy data, or electronic medical records (EMRs) is an asset.
• Experience in statistical analysis using tools like Python, R, or SAS is an asset.
• Knowledge of machine learning techniques for healthcare analytics is an asset.
• Knowledge of pharmacy industry and health services is an asset.
  Shoppers Drug Mart Inc. recognizes Canada’s diversity as a source of national pride and strength. We have made it a priority to reflect our nation’s evolving diversity in the products we sell, the people we hire, and the culture we create in our organization. Accommodation is available upon request for applicants with disabilities in the recruitment and assessment process and when hired.
  In addition, we believe that compliance with laws is about doing the right thing. Upholding the law is part of our Code of Conduct - it reinforces what our customers and stakeholders expect of us.
  Please Note: If you have Employee Self Service (ESS) on Workday, apply to this job via the Workday application.

WHY THIS ROLE IS IMPORTANT?

Job description
At Shoppers Drug Mart, we’re innovating health and wellness in Canada. From prescriptions to walk-in clinics, and a beloved loyalty program, we’re caring and supporting our customers in new ways every day.
With more than 1,300 locally owned and operated stores from coast to coast, the Shoppers Drug Mart network is more than a great place to shop, it’s a great place to work. We’re committed to building our talented team who champion collaboration, kindness and inclusivity. Join our team, and help recognize a healthy future for your career and for all Canadians.
Please note Loblaw’s Return to Office Policy, effective October 2024, is 4 days in the office located at 243 Consumers Road, Toronto, Ontario, M2J 4W8.
Pharmacy Services Analytics team (HDPS) team at Shoppers Drug Mart is seeking a talented senior analyst to join our team. We are dedicated to leveraging the power of data to improve the health and well-being of Canadians. Your work will directly impact the lives of millions of people by enabling more accessible healthcare services by empowering healthcare practitioners in our network.
Job Summary:
We are seeking a highly skilled and detail-oriented Senior Data Analyst to join our Pharmacy Service Analytics team. This role is critical in the development of key performance indicators (KPIs) and reports that drive insights into patient health outcomes and eligibility. The successful candidate will be responsible for data analysis, report development, and statistical assessments, leveraging expertise in health and pharmacy data.
Reporting to the Senior Manager on Pharmacy Services Analytics team, you will analyze and develop repots on patient eligibility and health outcomes while supporting strategic initiatives. You will identify opportunities and conduct impact analysis to provide supporting documentation and individualized location/customer impact reports.

KEY RESPONSIBILITIES:

• Design, develop, and maintain various KPI dashboards and reports to identify and track pharmacy program eligibility and outcomes following service delivery.
• Write and optimize SQL queries to extract, transform, and analyze large datasets from multiple sources.
• Develop and automate reports, ensuring accuracy, consistency, and timely delivery.
• Conduct statistical analysis and apply data modeling techniques to identify trends, patterns, and correlations in pharmacy and patient data.
• Collaborate with cross-functional teams, including pharmacy operations, finance, and IT, to understand data needs and provide actionable insights.
• Ensure data integrity, quality, and governance by implementing validation processes and best practices.
• Interpret complex health and pharmacy data to inform business decisions and support program development.
• Stay updated on industry trends and best practices related to pharmacy analytics and healthcare data management.

TYPE OF ROLE:

Temporary with Benefits (Fixed Term)
Shoppers Drug Mart Inc. recognizes Canada’s diversity as a source of national pride and strength. We have made it a priority to reflect our nation’s evolving diversity in the products we sell, the people we hire, and the culture we create in our organization. Accommodation is available upon request for applicants with disabilities in the recruitment and assessment process and when hired.
In addition, we believe that compliance with laws is about doing the right thing. Upholding the law is part of our Code of Conduct – it reinforces what our customers and stakeholders expect of us.