Reporting Analyst (Retail Sales)

A retail chain analytics team in Fourways needs dashboards people trust and numbers that add up. If you learn fast and don't mind being shown things twice, you'll settle in within a few weeks.

The work is in Fourways, Gauteng, so you'll need a reliable way to get there every day. Hours are mostly Monday to Friday, with the odd Saturday in busy months.

• Meet business users to turn their questions into report requirements
• Write SQL to pull, join and clean data from several sources
• Check data quality and trace odd numbers back to the source
• Present findings to managers in plain language with clear charts
• Build simple forecasting and segmentation models in Python or R
• Build and maintain Power BI dashboards and data models
• Build ETL pipelines in SSIS, Azure Data Factory or Python

• Strong SQL, including joins, window functions and CTEs
• At least 2 years in a data or reporting role (not needed for graduate posts)
• Degree in statistics, maths, computer science, economics or a related field
• Careful with sensitive customer data
• Able to explain what the numbers mean, not just show them
• Hands-on Power BI, Tableau or a similar tool

• Industry knowledge in retail, insurance or credit
• Microsoft PL-300 Power BI Data Analyst certification
• Python with pandas for data wrangling

• Annual bonus tied to company performance
• Latest laptop with extra screen
• Hybrid work with two office days
• Paid cloud and BI certifications

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