Purpose 
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.

Roles and Responsibility 

Merchandise Planning & Analysis

• 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

Commercial & Indent Deal Support 

• 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

Reporting & Data Management

• 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

Cross-Functional Collaboration 

• 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

Minimum Requirements

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