Junior Data Analyst (Graduate Programme)

Questions come to you at a healthcare administrator in Cape Town CBD, and you answer them with data. You don't need to be the loudest person in the room, just the one others can count on.

This post is Cape Town CBD-based, with most of your time spent at a healthcare administrator. Hours are mostly Monday to Friday, with the odd Saturday in busy months.

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

• Advanced Excel
• 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)
• Degree in statistics, maths, computer science, economics or a related field
• Able to explain what the numbers mean, not just show them

• Hybrid work with two office days
• Latest laptop with extra screen
• Annual bonus tied to company performance
• 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.
• Put SQL and your BI tool in the first line of your CV; these are the keywords every data recruiter searches.