Data Analyst

Ad Talent; Johannesburg; On-site; ZAR 600 000 - 850 000; Full time

Job summary

A leading FMCG company in Johannesburg is looking for a Data Analyst with 10-12 years of experience. The ideal candidate will have advanced skills in Power BI, SQL, and Excel, and familiarity with ERP and CRM systems. This role involves designing and maintaining reports, conducting analysis, and providing insights that drive business strategies. Candidates should possess strong communication skills and have experience engaging with senior stakeholders, along with a passion for mentoring junior team members.

Qualifications

• 10-12 years’ experience in data analytics, particularly in FMCG.
• Proven experience in designing and automating dashboards and reports.
• Ability to engage with senior stakeholders and mentor teams.

Responsibilities

• Design, automate, and maintain dashboards and reports for key business areas.
• Ensure accuracy and timeliness of business performance reporting.
• Conduct trend analysis and provide forecasting support.
• Deliver actionable insights to guide commercial strategy.
• Mentor junior analysts in data handling best practices.

Skills

Advanced Power BI

SQL

Excel

Data analysis

Statistical modeling

Data storytelling

Education

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

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.