What data analysts do
Data analysts turn raw data into decisions: they pull data from systems, clean and structure it, build reports and dashboards, and explain what the numbers mean for the business. Typical tasks include sales analysis, customer behaviour analysis, fraud detection support, and building the KPI dashboards managers rely on.
The core skills employers test
- Excel — pivot tables, lookups, formulas. Still the most tested skill in South African analyst interviews.
- SQL — querying databases. Essential for any role touching company data.
- Power BI or Tableau — building dashboards and visualisations.
- Statistics basics — averages, distributions, significance. Enough to avoid misleading conclusions.
- Communication — presenting findings to non-technical people is half the job.
Python or R are increasingly expected for more advanced roles, but the fundamentals above are where every analyst starts.
Study routes
- Degree route: BSc or BCom in statistics, mathematics, computer science, economics, actuarial science, or information systems. Actuarial science is the most competitive but opens the widest doors.
- Shorter route: an NQF-registered certificate or diploma in data analytics, plus a portfolio of real projects. Many employers value demonstrated SQL and Power BI skills over the name of the qualification.
- Self-taught route: free and low-cost online courses in SQL and Power BI, then build a portfolio using public datasets. This works when combined with strong evidence of skill.
Getting your first analyst job
The classic entry point is a junior analyst or graduate programme at a bank, insurer or retailer. Many companies run structured graduate programmes that teach their specific tools. Alternative entry points include data capturer, reporting assistant, or business support roles where you can start producing reports and grow into the analyst title. A portfolio — even dashboards built on public data — makes a real difference at junior level.
Career progression
- Junior / graduate analyst → Data Analyst → Senior Analyst
- Specialise: Data Scientist (more statistics and machine learning), Data Engineer (building data pipelines), or Analytics Manager (leading teams)
- Industry moves: banking, insurance, retail, telecoms, healthcare, consulting
Salary expectations
Junior analysts typically start in the R15,000–R25,000 per month range depending on the employer and qualifications. Experienced analysts earn R30,000–R50,000+, and data scientists or specialists earn more. Finance and consulting pay at the top of the range.