Data Engineer

DataTech Recruitment; Cape Town; On-site; ZAR 200,000 - 300,000; Full time

Job summary

A data solutions company in Cape Town seeks a Data Engineer to design and maintain ETL pipelines. The role involves automating data ingestion, supporting Finance and Operational BI, and ensuring data governance standards are met. Ideal candidates have 3–6 years of experience, strong SQL skills, and familiarity with ETL tools.

Qualifications

• 3–6 years’ experience in a Data Engineering role.
• Experience with both operational and financial data is a plus.
• Exposure to logistics or asset-heavy industries is advantageous.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines.
• Automate data ingestion from multiple sources.
• Support Finance BI and Operational BI.

Skills

Strong SQL and database expertise

Data modelling skills

Experience with ETL/ELT tools

System integration knowledge

Understanding of Power BI data modelling

Governance or master data management experience

Tools

MS SQL Server

SSIS

Azure Data Factory

Azure Synapse

Job description

Data Engineer position available in Cape Town.

We’re looking for a Data Engineer who can do more than just move data around. This is about shaping the backbone of reporting and analytics – from Finance to Operations – so that decision-making is powered by reliable, well-structured information.

If you know how to build bulletproof pipelines, model data for clarity, and keep systems talking to each other without missing a beat, you’ll fit right in.

Salary: R40 000 – R60 000 per month.

What we’re looking for:

• 3–6 years’ experience in a Data Engineering role.
• Strong SQL and database expertise (MS SQL Server, MS Fabric Onelake).
• Experience with ETL/ELT tools (SSIS, Azure Data Factory, Azure Synapse, MS Fabric).
• Skilled in data modelling and system integration (REST APIs, direct DB access, file processing).
• Understanding of Power BI data modelling (Power Query, DAX).
• Experience with both operational and financial data is a plus.
• Exposure to logistics or asset-heavy industries is advantageous.
• Governance or master data management experience is a bonus.

What you’ll be doing:

• Design, build, and maintain scalable ETL/ELT pipelines.
• Automate data ingestion from multiple sources – APIs, databases, flat files.
• Develop and maintain both relational and dimensional data models.
• Standardise measures and business logic across Finance and Operations.
• Support Finance BI (financial performance, profitability) and Operational BI (transport, warehouse, maintenance KPIs).
• Maintain a single source of truth for shared metrics and dimensions.
• Integrate with ERP, TMS, LMS, and finance systems.
• Enforce governance standards and maintain a centralised data catalogue.
• Own pipeline stability and ensure data availability without downtime.

Why you’ll love it here:

This role sits at the centre of Finance and Operational BI, giving you visibility and influence across the business. Your work will directly shape how leaders see performance, spot opportunities, and make decisions.

If you’re someone who likes being trusted with ownership, thrives on solving complex data puzzles, and wants to see your work make a real impact, we’d like to meet you.