Trade Insight Analyst

The first Woolworths store opened its doors to the public in Cape Town in October 1931. And it was founder Max Sonnenberg who captured the public’s imagination with dynamic store policies that set Woolworths apart from its competitors. Three years later, a second branch opened in Durban, with another two in Port Elizabeth and Johannesburg a year later. And since then we’ve been building on our reputation for superior quality, exciting innovation and excellent value. At Woolworths we take our business values seriously. They aren’t just words in an annual report - they are the foundation of our business. They give us direction and guide our behaviour, actions and choices. In fact, our values are so important to us that we’re measured not only on our performance, but also by how well we live up to them.Introduction To support the Trade Insights & Analytics team in delivering accurate, timely and commercially relevant reporting and analysis across Foods promotional performance and trade activity. This role plays a key part in the weekly and monthly trade reporting cycle, ensuring high quality data and reporting outputs are delivered to support category trade reviews, post-promotional reviews (PIRs), commercial analysis and executive decision-making. The analyst will support the team by consolidating and preparing data for effective analysis, identifying key performance signals and contributing toward meaningful commercial insights and recommendations. The successful candidate will be highly analytical, detail-oriented and commercially curious, with strong ambition to grow within trade analytics, promotional effectiveness analysis and commercial insight generation. Job description Weekly & Monthly Trade Reporting Own and deliver accurate and timely weekly and monthly reporting outputs across Foods trade and promotional performance Pull, validate and consolidate reporting from multiple data sources within strict timelines Ensure consistency, accuracy and completeness of reporting templates and outputs before business distribution Support the preparation of executive-ready reporting packs used in weekly trade and leadership reviews Identify anomalies, inconsistencies and material performance shifts across categories and promotional activity Promotional Reporting & Effectiveness Analysis Support analysis of promotional and trade performance across Foods categories Assist in evaluating promotional effectiveness, including sales uplift, volume growth, customer response and margin impact Consolidate and prepare data inputs required for promotional analysis and post-promotional reviews (PIRs) Support tracking of promotional trends, trade performance and category movements across the business Assist with ad hoc promotional and trade investigations where required Data Preparation & Commercial Analysis Support Prepare and structure data for deeper commercial analysis, viability work and strategic trade reviews Support the team in identifying key trade signals, risks and opportunities emerging from weekly performance Contribute toward cross-category analysis and identification of emerging business trends Assist in translating reporting outputs into concise and actionable business insights Support continuous improvement in reporting quality, usability and analytical value Reporting Optimisation & Automation Drive continuous improvement in reporting processes, accuracy and efficiency Support automation and simplification initiatives within reporting and analytics workflows Assist in leveraging AI and analytical tools to improve reporting quality, insight generation and productivity Maintain strong governance and version control across reporting files and outputs Stakeholder Engagement Engage effectively with internal stakeholders across Commercial, Trade and Analytics teams Support category and trade teams with reporting-related queries and interpretation of outputs Build collaborative working relationships across cross-functional teams Communicate findings clearly and confidently in both written and verbal format Minimum requirements Relevant commercial degree or diploma (BCom, BBusSci, B Econ or equivalent) 3 - 5 years' experience in analytics, reporting or commercial support roles Retail/FMCG experience advantageous Strong commercial curiosity and interest in promotional performance and trade analytics Advanced Excel capability essential Experience with QlikView/QlikSense, Power BI or similar analytical tools advantageous Strong numerical and analytical capability High attention to detail and ability to work accurately under pressure Ability to manage tight deadlines in a fast-paced reporting environment Self-starter with strong ownership mindset and ambition to grow Strong interpersonal and communication skills Ability to translate data into meaningful insights and recommendations Collaborative team player with a proactive and solutions-oriented mindset Thrives in a fast-paced commercial environment highly dependable and delivery-focused Enjoys solving problems and identifying patterns in data Has ambition to grow from reporting execution into commercial analytics and strategic insight generation Brings energy, curiosity and accountability to the team Deadline:22nd May,2026