Reporting Analyst (Retail Sales)

Build the SQL, models and dashboards that run the weekly meeting at a retail chain analytics team in Brackenfell. You don't need to be the loudest person in the room, just the one others can count on.

Location: Brackenfell, Western Cape. Applicants who already live in the area get looked at first.

• Keep a data dictionary so everyone uses the same definitions
• Check data quality and trace odd numbers back to the source
• Build simple forecasting and segmentation models in Python or R
• Build ETL pipelines in SSIS, Azure Data Factory or Python
• Write SQL to pull, join and clean data from several sources
• Build and maintain Power BI dashboards and data models
• Automate weekly reports that used to take hours in Excel

• Degree in statistics, maths, computer science, economics or a related field
• Advanced Excel
• Careful with sensitive customer data
• At least 2 years in a data or reporting role (not needed for graduate posts)
• Strong SQL, including joins, window functions and CTEs

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

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

• Show a before-and-after, like "replaced a 6-hour manual report with an automatic daily dashboard".
• Put SQL and your BI tool in the first line of your CV; these are the keywords every data recruiter searches.