how2apply

Reporting Analyst (Retail Sales)

How2Apply Talent Network

Cape Town CBD, Western Cape

Internship

Posted 2 hours ago

Internship IT & Software

R45 250 – R69 000/month

Apply for this job

Job Description

You'll turn messy data into reports managers actually use, for a healthcare administrator in Cape Town CBD. Good for someone who wants to build a solid track record they can put on their CV.

This post is Cape Town CBD-based, with most of your time spent at a healthcare administrator. The first two weeks are spent shadowing someone experienced.

What you'll actually do

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
Automate weekly reports that used to take hours in Excel
Build ETL pipelines in SSIS, Azure Data Factory or Python
Mask or remove personal information in data sets under POPIA

You'll need

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

Nice if you have

Python with pandas for data wrangling
Industry knowledge in retail, insurance or credit
Experience with Databricks, Snowflake or Fabric

What you get

Annual bonus tied to company performance
Hybrid work with two office days
Latest laptop with extra screen

Applying, step by step

Make sure the role, the hours and working in Cape Town CBD really suit you before you apply.
Have the following on hand (clear photos on your phone are fine at first): screenshots or a link to a dashboard you built, with real data removed, certification transcripts plus academic record showing statistics or maths modules.
Fill in the short form below with your name and a phone number you actually answer.
Watch for a call or WhatsApp from How2Apply over the next 5 working days.

How2Apply recruits for this position on behalf of hiring employers around Cape Town CBD; applications go into our talent pool and shortlisted candidates are introduced directly.

Applying is free. Nobody from How2Apply will ever ask you to pay for anything to get this job.

Tips to get shortlisted

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.