CENTRAL TRADE & MARKET INSIGHT ANALYST

Woolworths; Cape Town; On-site; ZAR 400 000 - 600 000; Full time

Job summary

A leading retail company in Cape Town is seeking a candidate to deliver actionable insights for Foods trade performance. The ideal candidate will have strong analytical skills, at least 5 years of experience in FMCG, and advanced proficiency in Excel. This role includes responsibilities such as market analysis and stakeholder engagement. A relevant degree is essential, along with experience in trade analytics and research.

Qualifications

• Minimum of 5 years working experience in FMCG, 3 years' experience in analytics.
• Proven experience analysing commercial levers to develop recommendations.
• Demonstrated financial mindset and commercial acumen skills.

Responsibilities

• Deliver actionable commercial and market insights to optimise Foods trade performance.
• Conduct detailed market share and commercial analysis.
• Support integration of Foods business onto Discover platform.

Skills

Retail analytics

Advanced MS suite proficiency

Strong communication skills

Project leadership

Trade analytics experience

Research skills

Education

Relevant commercial diploma/degree (BSc, BBusSci, BComm, BEcon)

Tools

Microsoft Excel

Powerpoint

Qlik

Job description

Job category: Other: FMCG, Retail, Wholesale and Supply Chain

Location: Cape Town

Contract: Permanent

Remuneration: Market Related

EE position: No

Introduction

To deliver actionable commercial and market insights that optimise Foods trade performance and support strategic decision-making. This includes analysing market share, competitor and promotional activity, and developing trade models that inform divisional and category opportunities. The role ensures reporting accuracy, data integrity, and stakeholder alignment across the Foods business.

• Monitor micro & macro-economic market trends locally & globally impacting retail.
• Deliver Monday Foods reporting, ensuring accurate reports and insights derived.
• Deliver monthly promotional and PIR reporting into Finance.
• Optimising and efficiency of business and reporting process.
• Conduct detailed market share and commercial analysis to identify opportunities, risks, and competitive shifts across Foods/ Campaigns/ Categories.
• Maintain supplier coding and ensure data integrity across Cat & Gap and Buyer reports.
• Support integration of Foods business onto the Discover platform and enable functional teams to extract insights
• Proactively track and evaluate market and competitor trade activity to support tactical and operational decisions.
• Develop and maintain Trade modelling per phase, with guidance from Lead, to identify category and regional opportunities.
• Implementing and maintaining PIR methodologies provided across commercial analysis – to deliver actionable insights by collaborating with all relevant stakeholders.
• Leverage external and internal data sources to develop actionable insights for category and divisional teams.
• Collaborate with Store Analyst/ Divisional Teams/ Customer/ Marketing and Trade Planning teams to identify Trade challenges and opportunities.
• Maintain stakeholder relationships within operational forums to support business delivery.
• Relevant commercial diploma/degree or equivalent (BSc, BBusSci, BComm, BEcon)
• A background in Retail analytics, Actuarial Science, Finance or Mathematics is preferable
• Minimum of 5 years working experience in FMCG, 3 years' experience in analytics
• Proven experience analysing commercial levers to develop recommendations to sustainably grow a Foods/FMCG category (i.e. market share, sales growth, margin, ROS, COGS, availability)
• Advanced MS suite proficiency – Microsoft, Excel (VLOOKUP, Index Match, Advanced conditional formatting, Pivot tables and reporting, Macros and VBA, Data Simulations) and Powerpoint.
• Qlik experience beneficial
• Self-starter that is driven to deliver, can work independently and inter-dependently
• Strong inter-personal skills and can interact at senior level
• Strong communication skills (verbal and written)
• Team player, integrator and collaborator
• Commitment to high performance
• Specific experience in trade analytics is compulsory
• Research experience is critical
• Demonstrated financial mindset and commercial acumen skills.
• Strong ability to select relevant data sources, prepare data for analysis, translate analytics into insights, connecting the dots to construct and visualise a data-driven compelling story with clear and actionable recommendations.
• Project leadership skills with ability to deliver to the required standards and timelines.
• Strong integrator, collaborator with the ability to flex between leading teams, managing others and working as a contributor within a matrix structure and with external suppliers.
• Flexibility with ability to work productively under tight timelines.
• Passionate Foodie, with a solid understanding and demonstrated alignment to the Woolies' Values