Retail Analyst

Media24; Gauteng; On-site; ZAR 300 000 - 400 000; Part time

Job summary

A leading media company in Johannesburg is seeking an experienced Retail Analyst to provide insights through data analysis and enhance stock management practices. The role requires a degree in commerce/business and at least 3-4 years in a retail environment, with strong analytical skills. This position offers opportunities to engage with stakeholders and contribute to sales strategies.

Qualifications

• At least 3-4 years’ work experience in a retail environment.
• Strong analytical ability and commercial acumen.
• Retail planning experience is preferred and advantageous.

Responsibilities

• Analyse stock and sales reports weekly to provide insights.
• Formulate strategies for slow moving inventory.
• Support Sales Team with stock management.

Skills

Analytical ability

Commercial acumen

Retail planning

Stakeholder engagement

Team collaboration

Education

Commerce/Business Degree

Tools

Excel

Power BI

Job description

Overview

Job Description: Retail Analyst

Position: Retail Analyst

Department: Sales

Location: Johannesburg

Contract Type: Fixed-term contract 3-months

Reporting to: Key Accounts Executive

Responsibilities

• Analysis and Reporting
  • Understands the retail environment through data analysis of each retailer to provide information on opportunities.
  • Analyse stock and sales reports on a weekly basis to provide insights by door, by brand and by retailer.
  • Analyse retailer stock levels to identify opportunities and challenges to optimise sell-out and stockturn by SKU by store – build recommended actions accordingly.
  • Build sell-out targets by mall, by brand, by retailer annually and manage reforecasts monthly.
  • Assist and support the Key Accounts Executive to deliver all weekly and monthly reports.
• Stock Management - Retail
  • Analyse and interpret sales and stock trends to provide actionable insights and data-driven business decisions.
  • Formulate strategies for slow moving inventory and days stock cover to ensure optimal stock levels that supports business growth.
  • Guide and support the execution of planograms by analysing each brand and the respective stock model requirements.
  • Conduct competitive analysis to refine stock strategies ensuring that PCG remains agile and responsive to market trends.
  • Oversee the management of critical SKUs.
  • Develop centralised reporting frameworks to track core in-stock metrics enabling clear visibility and timely interventions.
  • Collaborate with Brand Team to ensure that promotions are executed with sufficient stock availability reducing missed sales opportunities and ensuring customer satisfaction (saleable and non-saleable stock).
  • Monitor promotional in-stock levels to minimise out-of-stocks during key sales events.
  • Maintain inventory expectations at store level to resolve any discrepancies and maintain operational consistency.
• Sales Team Support
  • Guide the Sales Team on best practices and how to manage stock efficiently at store level.
  • Work with the sales team on store gridding and localisation.
  • Supports KAE where retailer head office escalations are required to help resolve any issues around DI, stock input requests.
  • Partner with the Sales team to ensure optimal usage and allocation of non-saleable stock – drive productivity.
  • Provide insights and guidance on overstocks and understocks ensuring data-driven actions.
  • Builds weekly new product trackers to track new launches versus prior launches.
• Stakeholder Engagement
  • Build and maintain relationships with all internal and external stakeholders.
  • Contribute meaningfully to create a great workplace experience for all team members.
  • Actively engage in all Company culture initiatives.

Competencies

• Deciding and Initiating Action
• Working with People
• Writing and Reporting
• Persuading and Influencing
• Planning and Organising
• Delivering Results & Meeting Customer Expectations
• Adapting and responding to change
• Coping with pressures and setbacks
• Analysing
• Entrepreneurial and commercial thinking

Minimum Requirements / Qualifications

• Commerce/Business Degree
• At least 3-4 years’ work experience in a retail environment
• Strong analytical ability and commercial acumen
• Retail planning experience is preferred and advantageous
• Proven knowledge of MS packages Excel/Word/PowerPoint
• Advanced Excel: Non-negotiable
• Experience using Power BI is advantageous