Analyst, Promotion Optimization

Loblaw Companies Limited; Toronto; On-site; CAD 60,000 - 82,500; Full time

Benefits offered by this job

Purchase discount program

Competitive pay

Online learning through Academy

Job summary

Shoppers Drug Mart Inc. is seeking an analytics-focused professional in Toronto to join the Forecasting and Promo Optimization team. You will partner with Category Managers and senior leaders to optimize flyer promotions, forecast sales and margin, and deliver data-driven insights.

The role involves using Excel and PowerBI, collaborating with cross-functional teams, and influencing merchandising decisions within Canada’s leading retailer.

Qualifications

• 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).
• Advanced Excel skills; 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 clearly.
• Strong interpersonal skills to lead discussions, build relationships, and collaborate across cross-functional teams.
• Proficiency in Microsoft Office including Excel and PowerPoint.
• Attention to detail and a proactive approach to solving problems.
• Curiosity, intellectual agility, and willingness to challenge assumptions.

Responsibilities

• 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 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 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 and identify opportunities for continuous improvement.

Skills

Analytical skills

Advanced Excel

PowerBI

SQL

VBA

Education

University degree

Tools

PowerBI

SQL

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

At Shoppers Drug Mart Inc., we seek 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,

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.

Hiring Range / Échelle Salariale à L’embauche

$60,000.00 - $82,500.00 / 60.000,00$ - 82.500,00$ (per year / par an)

A candidate’s experience and knowledge as well as the geographical region in which the position is located may be factored into the pay a candidate receives for this position. This posting is for an existing vacancy. The Company uses artificial intelligence for the purpose of screening, assessing and/or selecting applicants for this position. / L’expérience et les connaissances d’un candidat ainsi que la région géographique dans laquelle le poste est situé peuvent être prises en compte dans la rémunération qu’un candidat reçoit pour ce poste. Cette offre d’emploi concerne un poste vacant existant. L’entreprise utilise l’intelligence artificielle dans le but de filtrer, d’évaluer et/ou de sélectionner les candidats à ce poste.