Merchandise Planner

Key Responsibilities

• Support in providing weekly, monthly and yearly sales reporting and summary of key performance indicators relating to sales, sell through, stock, profit, and markdown versus budget and last year
• Support with maintaining key files (Master Orders, OTB templates) that drive the planning and trading process throughout the season
• Providing crucial support to the Merchandising team taking an active role by analysing sales trends, monitoring deliveries, and maintaining stock levels
• Work with the Senior Coordinators, Merchandisers and Buyers to control deliveries, allocations, and replenishment
• Responsible for ensuring that the markdown master file is aligned to the markdown calendar and integral data is kept updated with the brands carryover and markdown lists
• Responsible for running a daily sales report communicating vital sales and stock information vs budget
• Support the Merchandising team to identifying products for promotional and markdown activities
• Support the Merchandising team during the planning and OTB process including Basics forecasting and EOS lessons learnt
• Support the Merchandising and Buying team with pre market analysis packs
• Work closely with the team to manage data integrity such as seasonality and pricing
• Key contact for merchandise reporting and all aspects of merchandising processes and system use
• Supporting with any other ad hoc administration required within the merchandising function

Qualification

• Proven experience as a Retail Merchandiser or similar role in the retail industry, preferably in home furnishings or housewares.
• **Strong analytical skills with proficiency in Microsoft Excel(VLOOKUP, pivot table)**
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
• Proficiency in using computerized systems and software relevant to merchandising and inventory management.
• Ability to prioritize tasks, work independently, and manage time effectively in a dynamic retail environment.

Job Type: Full-time

Application Question(s)

• Can you describe your proficiency with Excel? What are some advanced functions or features you regularly use?
• What methods do you use to forecast sales and plan inventory levels?