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 an experienced Data Analyst with 10–12 years of data analytics experience. The role involves designing and automating reports, conducting in-depth analyses, and mentoring junior analysts. The ideal candidate will have advanced skills in Power BI, SQL, and Excel, along with experience in ERP and CRM systems. Strong communication and analytical skills are essential for engaging with senior stakeholders and driving actionable insights.

Qualifications

• 6–10 years of proven experience in data analytics.
• Advanced skills in Power BI (DAX, data modeling), SQL, and Excel.
• Strong understanding of FMCG sales, marketing, trade, and supply chain dynamics.

Responsibilities

• Design, automate, and maintain dashboards and reports for various departments.
• Conduct trend, variance, and root-cause analysis.
• Provide demand forecasting and supply chain planning support.

Skills

Data analytics

Power BI

SQL

Excel

Statistical modeling

Data storytelling

Education

Bachelor’s/Master’s Degree in Statistics, Data Science, Economics, Computer Science, or a related field

Tools

ERP systems (SAP, Oracle, MS Dynamics)

CRM tools

Python

R

SAS

Job description

Who are we

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

Who are we looking for

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.

What will you do

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

What do you need

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