how2apply

Junior Data Analyst (Graduate Programme)

How2Apply Talent Network

Cape Town CBD, Western Cape

Internship

Posted 1 hour ago

Internship IT & Software

Apply for this job

Job Description

A short-term insurer in Cape Town CBD needs dashboards people trust and numbers that add up. Bring a calm head on busy days and you'll be fine.

This post is in Cape Town CBD (Western Cape). Please only apply if you can travel there daily. There's a probation period of three months before the contract is confirmed.

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 and maintain Power BI dashboards and data models
Build simple forecasting and segmentation models in Python or R
Write SQL to pull, join and clean data from several sources
Meet business users to turn their questions into report requirements
Automate weekly reports that used to take hours in Excel

You'll need

Hands-on Power BI, Tableau or a similar tool
Strong SQL, including joins, window functions and CTEs
Careful with sensitive customer data
Able to explain what the numbers mean, not just show them
Advanced Excel
Degree in statistics, maths, computer science, economics or a related field

Helpful, not essential

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

What you get

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

Applying, step by step

Read the "What you need" list above. If you tick most of it, go ahead and 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, academic record showing statistics or maths modules plus certification transcripts.
Use the form on this page. It takes about two minutes and you don't need to upload anything yet.
Keep your phone on. Shortlisted applicants are contacted by call, SMS or WhatsApp within 5 working days.

Your application joins the How2Apply talent pool for this role, and we put shortlisted people forward to employers hiring in and around Cape Town CBD.

How2Apply never charges you to apply, for training, for uniforms or for a "placement fee". If anyone asks you for money, it is a scam.

How to stand out

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.