Data Scientist (Customer Analytics)

Build the SQL, models and dashboards that run the weekly meeting at a retail chain analytics team in Kempton Park. It's a practical job: you'll see what you got done before you go home.

This post is Kempton Park-based, with most of your time spent at a retail chain analytics team. There's a probation period of three months before the contract is confirmed.

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

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

• Experience with Databricks, Snowflake or Fabric
• Python with pandas for data wrangling

• Annual bonus tied to company performance
• Paid cloud and BI certifications
• Latest laptop with extra screen

• Put SQL and your BI tool in the first line of your CV; these are the keywords every data recruiter searches.
• Build one public portfolio dashboard on a South African open data set if you have no work samples to share.