how2apply

BI Developer (SQL Server and SSIS)

How2Apply Talent Network

Brackenfell, Western Cape

Full-time

Posted 1 day ago

Full-time IT & Software

R45 250 – R59 000/month

Apply for this job

Job Description

You'll turn messy data into reports managers actually use, for a retail chain analytics team in Brackenfell. Good for someone who wants to build a solid track record they can put on their CV.

The work is in Brackenfell, Western Cape, so you'll need a reliable way to get there every day. Overtime comes up in peak season and is paid.

What your day looks like

Write SQL to pull, join and clean data from several sources
Build and maintain Power BI dashboards and data models
Build simple forecasting and segmentation models in Python or R
Mask or remove personal information in data sets under POPIA
Automate weekly reports that used to take hours in Excel
Keep a data dictionary so everyone uses the same definitions

Must-haves

Able to explain what the numbers mean, not just show them
Advanced Excel
At least 2 years in a data or reporting role (not needed for graduate posts)
Strong SQL, including joins, window functions and CTEs

Nice if you have

Python with pandas for data wrangling
Microsoft PL-300 Power BI Data Analyst certification

On offer

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

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): academic record showing statistics or maths modules plus screenshots or a link to a dashboard you built, with real data removed.
Send your details with the form below. Add one or two lines about similar work you've done.
If you're shortlisted you'll hear from us within 5 working days, usually by phone.

How2Apply recruits for this position on behalf of hiring employers around Brackenfell; 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

Show a before-and-after, like "replaced a 6-hour manual report with an automatic daily dashboard".
Build one public portfolio dashboard on a South African open data set if you have no work samples to share.