ASSORTMENT PLANNER- 12M Contract

The Home Depot

1d•CA$62,200 - CA$70,100•Onsite

About The Position

As an Assortment Planner at The Home Depot Canada, you serve as a critical business partner and trusted advisor to our Merchandising Team. You aren't just running reports; you are translating raw data into the strategic insights that determine which products we carry, how we price them, and how we win in a competitive market. In this role, you provide ongoing, high-impact financial and assortment analysis. You will lead Product Line Reviews (PLRs) and Continuous Business Reviews (CBRs), acting as a subject matter expert who possesses a deep curiosity for your assigned category. You will bridge the gap between merchandising strategy and operational execution, collaborating with cross-functional teams and vendors to ensure our customers always find the right product at the right value.

Requirements

3-5 years of merchandising category management, assortment planning or retail analytical experience
Microsoft Excel
Microsoft Power Point
Tableau
Comfortable with AI tools: Gemini, Copilot

Nice To Haves

University and/or college degree in Business, Retail Management, or a related field of study preferred.
Master of Business Administration is an asset
Experience in Home Improvement retail is an asset

Responsibilities

Craft strategic category and assortment plans that align with overall business goals that is executed through Product Line Reviews (PLRs) and other projects.
Advise Merchants on the ideal product assortments to maximize store and online performance.
Develop executive-level presentations that summarize analysis including historical category performance, strategic rationale underpinning assortment decisions and expected financial impact. Report out to all levels of management.
Turn raw performance data into high-quality financial reporting and effectively communicate "actionable recommendations". Typical analysis will include the following for both Store and Online: a) marketplace and macroeconomic trends impacting the category including competitive assessment, b) vendor portfolio strengths and weaknesses including private brand, c) line structure, d) store clustering, e) customer and store feedback, f) identifying key product attributes and g) regional performance.
Advise Merchants on specific item selection by explaining why products should be added or dropped based on data.
Act as the expert for a specific category, obsessing over trends and opportunities within that department.
Utilize tools like Excel and Tableau to visualize data and explain complex results to stakeholders.
Accountable for accuracy, thoroughness, thought process, timeliness and viability of recommendations.
Partner with cross-functional teams to ensure flawless execution.
Work directly with vendors to support Merchant assortment selections and negotiations that will provide exceptional value to customers.
Develop leadership and strategic business skills by acting as the primary analytical business partner for the merchant team. Ability to influence peers and business partners without authority.
Manage concurrent timelines and multiple project milestones (like PLRs or CBRs) in a fast paced environment. Proactively escalate issues when delays put projects at risk.
Conduct occasional travel to stores and vendor facilities to gain first-hand product and operational knowledge.