Data Analyst

Ad Talent Africa; Johannesburg; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading FMCG company in Johannesburg is seeking a Data Analyst with 10-12 years of experience in data analytics. The ideal candidate will possess strong skills in Power BI, Excel, and SQL, and have a background in engaging with senior stakeholders. Responsibilities include designing dashboards, conducting analysis, and mentoring junior analysts. This role offers an opportunity to drive insights and strategic decision-making in a dynamic environment.

Qualifications

• 10-12 years’ experience in data analytics, ideally within FMCG, retail, or manufacturing.
• 6-10 years proven experience in data analytics.
• Experience in mentoring junior analysts.

Responsibilities

• Design, automate, and maintain dashboards and reports.
• Conduct trend, variance, and root-cause analysis.
• Deliver insights on customer profitability and market trends.

Skills

Power BI

Excel

SQL

Analytical mindset

Commercial acumen

Data storytelling

Education

Bachelor’s or Master’s Degree in Statistics, Data Science, Economics, Computer Science

Tools

ERP systems (SAP, Oracle, MS Dynamics)

CRM tools

Python

R

SAS

Job description

Overview

We are a leading player in the fast-moving consumer goods (FMCG) industry, committed to driving growth, innovation, and efficiency.

Role

We are seeking an experienced Data Analyst with 10–12 years’ experience in data analytics, ideally within FMCG, retail, or manufacturing. This individual should have advanced expertise in Power BI, Excel, and SQL, with strong exposure to ERP and CRM systems. A strategic thinker with exceptional analytical skills and the ability to translate data into actionable insights, the right candidate will be comfortable engaging with senior stakeholders and mentoring junior team members.

Responsibilities

• Design, automate, and maintain dashboards and reports for sales, marketing, finance, and operations.
• Ensure accuracy, timeliness, and reliability of business performance reporting.
• Conduct trend, variance, and root-cause analysis across pricing, trade promotions, and sales performance.
• Provide demand forecasting and supply chain planning support.
• Deliver insights on customer profitability, market trends, and consumer behaviour.
• Build predictive models to guide commercial strategy and category management.
• Partner with cross-functional teams to evaluate ROI of marketing campaigns and promotions.
• Present clear, visual, and impactful insights to senior leadership.
• Mentor and guide junior analysts in data handling and visualization best practices.

Qualifications

• Bachelor’s/Master’s Degree in Statistics, Data Science, Economics, Computer Science, or a related field.
• 6 - 10 years of proven experience in data analytics.
• Advanced skills in Power BI (DAX, data modeling), SQL, and Excel.
• Familiarity with ERP systems (SAP, Oracle, MS Dynamics) and CRM tools.
• Experience with Python, R, or SAS for statistical modeling (advantageous).
• Strong understanding of FMCG sales, marketing, trade, and supply chain dynamics.
• Excellent communication and executive presentation skills.
• Key strengths: analytical mindset, commercial acumen, attention to detail, data storytelling, and leadership.