how2apply

BI Developer (SQL Server and SSIS)

How2Apply Talent Network

Somerset West, Western Cape

Full-time

Posted 1 day ago

Full-time IT & Software

Apply for this job

Job Description

A healthcare administrator in Somerset West needs dashboards people trust and numbers that add up. You'll work with a small crew, so being easy to work with matters as much as skill.

The work is in Somerset West, Western Cape, so you'll need a reliable way to get there every day.

What you'll actually do

Write SQL to pull, join and clean data from several sources
Automate weekly reports that used to take hours in Excel
Check data quality and trace odd numbers back to the source
Build ETL pipelines in SSIS, Azure Data Factory or Python
Build simple forecasting and segmentation models in Python or R
Build and maintain Power BI dashboards and data models
Meet business users to turn their questions into report requirements

What you need

Careful with sensitive customer data
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)
Hands-on Power BI, Tableau or a similar tool
Degree in statistics, maths, computer science, economics or a related field

Extra points for

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

What's in it for you

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

How to apply for this job

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): academic record showing statistics or maths modules, screenshots or a link to a dashboard you built, with real data removed plus certification transcripts.
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.

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

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

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.