Analyst, Promotion Optimization

Shoppers Drug Mart; Toronto; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Purchase discount program

Online learning through Academy

Competitive pay

Job summary

Shoppers Drug Mart in Toronto seeks a data‑driven Forecasting & Promo Analytics professional to support flyer planning and margin optimization. You will partner with Category Managers and senior leaders to deliver actionable insights and drive promotional value across the business.

The role emphasizes real‑time forecasting, variance analysis, and clear communication of results to cross‑functional teams for strategic decision making. Strong Excel, Power BI, and SQL skills are essential.

Qualifications

• Strong analytical and technical capabilities; capable of synthesizing large data sets into actionable insights.
• Excellent communication and presentation abilities with a clear business impact.
• Experience collaborating with cross‑functional teams and senior stakeholders.

Responsibilities

• Partner with Category Managers and VPs to optimize promotional tactics and provide actionable recommendations to maximize incremental sales and margin.
• Own the real‑time, consolidated forecast for flyer sales and margin with timely reporting to stakeholders.
• Monitor promotional performance, investigate variances, and communicate insights to the business.
• Analyze baseline sales and margin to estimate incremental impact of promotions across categories.
• Conduct ad‑hoc analyses to evaluate promotional response and category elasticity.
• Develop presentations that clearly communicate analytical findings to technical and non‑technical audiences.
• Collaborate with cross‑functional teams to support promotional planning and continuous improvement.

Skills

Analytical mindset

Communication skills

Cross-functional collaboration

Presentation skills

Education

University degree in Business, Statistics, Economics, Computer Science, or Engineering

Tools

PowerBI

SQL

Excel

Access

VBA

Job description

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.

Why this role is important?

The Forecasting and Promo Optimization team at Shoppers Drug Mart provides critical analytical support for flyer and promotional planning across the business. We partner closely with Category Managers and senior leadership to optimize promotional strategies, deliver value‑added insights, and drive incremental sales and margin. Through continuous innovation and data‑driven decision making, we help shape more customer‑centric promotional programs and improve business performance.

This role offers the opportunity to influence high‑impact merchandising decisions, collaborate directly with senior leaders, and apply advanced analytics to improve promotional effectiveness across one of Canada’s leading retailers.

What you’ll do:

• Partner directly with Category Managers and Vice Presidents to optimize promotional tactics and provide actionable recommendations that maximize incremental sales and margin.
• Own the real‑time, consolidated forecast for flyer sales and margin, ensuring timely and accurate reporting to stakeholders.
• Monitor promotional performance against forecast, investigate variances, identify emerging trends, and communicate actionable insights to the business.
• Analyze baseline sales and margin to estimate the incremental impact of promotional events across assigned categories.
• Conduct ad‑hoc analyses to evaluate promotional response, category elasticity, and emerging business opportunities.
• Develop clear, insightful presentations that communicate analytical findings and recommendations to both technical and non‑technical audiences.
• Collaborate with cross‑functional teams to support promotional planning, identify opportunities for continuous improvement, and influence key business decisions.

What you bring:

• Post‑secondary education equivalent to a university degree in Business, Statistics, Economics, Computer Science, or Engineering.
• 1–3 years of work experience in an analytical setting (including retail, manufacturing, consulting, or banking).
• Strong analytical and technical skills (advanced Excel skills; experience in PowerBI/SQL/Access/VBA programming is preferred).
• Knowledge of forecasting techniques and processes.
• Ability to synthesize large volumes of data into meaningful insights and business recommendations.
• Strong presentation and communication skills, with the ability to explain complex concepts in a clear, concise, and compelling manner.
• Strong interpersonal skills with the ability to lead discussions, build relationships, and collaborate effectively across cross‑functional teams.
• Demonstrated business acumen and a proactive approach to identifying opportunities and solving problems.
• Strong skills in the Microsoft Office suite, including Excel and PowerPoint.
• Excellent attention to detail and a commitment to delivering high‑quality work.
• Curiosity, intellectual agility, and a willingness to ask questions and challenge assumptions.

Why work at Shoppers Drug Mart?

Acting as consultants, supporting internal customers and the Associate‑Owners, you will get experience unique to the retail industry while working for an award‑winning national brand. Benefit from a purchase discount program, competitive pay and online learning through Academy.

Take ownership of your work and find more ways to care about your work, co‑workers, customers and community.

How You’ll Succeed:

Shoppers Drug Mart Inc. seeks great people to continually strengthen our culture. We believe great people model our values, are authentic, build trust and make connections.

If that sounds like you, and you are open‑minded, responsive to change and up to the challenges provided in a fast‑paced retail environment, apply today.

Employment Type

Full time

Type of Role

Regular

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.