how2apply

BI Developer (SQL Server and SSIS)

How2Apply Talent Network

Pietermaritzburg, KwaZulu-Natal

Full-time

Posted 1 hour ago

Full-time IT & Software

Apply for this job

Job Description

You'll turn messy data into reports managers actually use, for a retail chain analytics team in Pietermaritzburg. Bring a calm head on busy days and you'll be fine.

The site is in Pietermaritzburg; early starts mean public transport timing matters, so check your route before applying.

What your day looks like

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

What you need

Strong SQL, including joins, window functions and CTEs
Advanced Excel
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
Careful with sensitive customer data

Extra points for

Microsoft PL-300 Power BI Data Analyst certification
Industry knowledge in retail, insurance or credit

What you get

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

How to apply for this job

Check you meet the must-haves first; recruiters filter on those before anything else.
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 plus academic record showing statistics or maths modules.
Use the form on this page. It takes about two minutes and you don't need to upload anything yet.
If you're shortlisted you'll hear from us within 10 working days, usually by phone.

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

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.

Before you hit apply

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.