Reporting Analyst (Retail Sales)

Questions come to you at a healthcare administrator in Randburg, and you answer them with data. This is a good step for someone who wants proper routine and a manager who notices good work.

You'll report in Randburg. Relocation is not covered for this one. There's a probation period of three months before the contract is confirmed.

• Keep a data dictionary so everyone uses the same definitions
• Mask or remove personal information in data sets under POPIA
• Check data quality and trace odd numbers back to the source
• Build simple forecasting and segmentation models in Python or R
• Present findings to managers in plain language with clear charts
• Automate weekly reports that used to take hours in Excel
• Write SQL to pull, join and clean data from several sources

• Strong SQL, including joins, window functions and CTEs
• Careful with sensitive customer data
• Advanced Excel
• At least 2 years in a data or reporting role (not needed for graduate posts)
• Hands-on Power BI, Tableau or a similar tool

• Python with pandas for data wrangling
• Microsoft PL-300 Power BI Data Analyst certification
• Experience with Databricks, Snowflake or Fabric

• Latest laptop with extra screen
• Paid cloud and BI certifications
• Hybrid work with two office days

• Build one public portfolio dashboard on a South African open data set if you have no work samples to share.
• Show a before-and-after, like "replaced a 6-hour manual report with an automatic daily dashboard".