Merchandise Planning Analyst

We are currently looking for a Merchandise Planning Analyst with at least 1 to 2 years of retail replenishment and or allocations experience to join our Store Support Centre team in Brampton, ON. Our Merchandise Planning Analysts perform allocation of products to stores using various complex allocation methods to achieve sales targets, balance inventory and minimize stock outages. Using historical data, forecasts, sales trends, sell-through and lifecycles, they derive the best possible methods of allocation. In addition, they utilize technical skills and systems to perform their duties including advanced Excel formulas, pivot tables, data organization, Access queries, creating / editing Python scripts, and ERP systems.

Merchandise Planning Analysts provide analysis, reports, and recommendations for several inventory management functions in a timely manner. Monitoring and analyzing store sales and seasonal catalog inventory cycles, they regulate ERP replenishment practices. They support store level trends and opportunities while minimizing inventory costs. They provide inventory support for marketing and sales events leading up to, during and after the event. Following the event, they track results, communicate findings, and collaborate with Buying and Distribution to take appropriate actions. They develop the best possible means of correction or redistribution for any identified inventory overages, and shortages by category or item. They collaborate with all affected stakeholders (i.e. Field Management, Distribution, Reclamation and Buyer) to initiate a solution, monitor, and respond to the results. Working very closely with the Buying and Distribution teams, they provide our stores with the support they need to give our customers the best shopping experience.

As a Merchandise Planning Analyst, your analytical and problem-solving skills must be advanced with a proven track record of successfully working with a team to accomplish your objectives. Advanced Excel skills are required for this role. Experience with SQL and Python are an asset.

To learn more about this opportunity, please submit your current resume with your application.