Merchandise and Commercial Analyst

The Merchandise & Commercial Analyst is responsible for providing advanced analytical, planning, and commercial support across the merchandise value chain. The role ensures that the right products arrive at the right time, in the right quantities, and at commercially viable margins. It combines merchandise planning, data analytics, and commercial deal support (indent and non-stock) to drive profitable business outcomes and operational efficiency.

• Analyse sales, stock, margin, ageing, and performance trends to inform decision-making and category plans
• Build and maintain forecasting models, replenishment logic, and inventory recommendations
• Track sell-through, stock turn, promotional performance, and intake alignment to plan
• Support the end-to-end merchandise cycle from product ordering to warehouse delivery

• Prepare, cost, and structure indent and non-stock quotations for Sales
• Evaluate margin, pricing, and profitability implications for special deals and customer projects
• Provide commercial scenarios (cost, landed cost, GM%, selling price) to support deal closure
• Validate commercial viability and ensure alignment to timelines and supply chain capability

• Produce accurate, timely reports (Excel, BI tools) for trade, stock, risk/opportunity, and margin performance
• Maintain large datasets with a high degree of accuracy and analytical interpretation
• Present insights clearly to stakeholders across Merchandising, Sales, Finance, and Supply Chain

• Partner with Merchandising/Buying on range performance, forecasting, and intake schedules
• Work closely with Sales on special deals, pricing rationale, and commercial approvals
• Engage Supply Chain to manage lead times, delivery dates, and stock availability
• Liaise with Finance on margin, pricing, and cost accuracy

• NQF 7 -Finance/ Economics/ Retail Management/ Supply Chain / Logistics
• 3+ years Data Analytics Experience
• 5+ yearsSolid understanding of retail/merchandise math's (margin, mark-up, sell-through, turn, pricing).
• 5+ yearsmerchandise planning cycles, procurement timelines, and demand forecasting.