Data Engineer

Penta Consulting; Cape Town; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

Penta Consulting seeks an experienced Data Engineer for a high-profile retail project in Cape Town. The role focuses on designing and maintaining data pipelines, data warehouses, and scalable models to support BI and analytics.

Collaboration with technical and business stakeholders is essential. Ideal candidates have strong Microsoft data platform experience, hands-on ETL/ELT skills, and a proven track record in governance and data quality, including POPIA compliance.

Qualifications

• Minimum 5 years of Data Engineering experience.
• Strong Microsoft data platform expertise and ETL/ELT hands-on experience.
• Experience with data governance, security and POPIA compliance.
• Ability to collaborate with business stakeholders and translate requirements.
• Experience supporting on-premises data workloads.

Responsibilities

• Design, develop, and maintain data pipelines and integration solutions.
• Build and support enterprise data warehouses and scalable data models.
• Develop and maintain ETL/ELT processes using Microsoft data technologies.
• Manage and support on‑premises data workloads and pipeline operations.
• Ensure data quality, integrity, and consistency across data platforms.
• Collaborate with business stakeholders to understand data requirements and deliver effective solutions.
• Support reporting and analytics initiatives by providing clean and reliable datasets.
• Contribute to testing, monitoring, and ongoing optimization of data solutions.

Skills

Data pipelines

Stakeholder engagement

Communication

Data quality

POPIA awareness

Tools

SSAS

ETL/ELT

Data warehousing

Databricks

Python

Power BI

Tableau

Job description

Contract Duration: Initial 6-Month Contract

Start Date: October 2026

Overview

We are seeking an experienced Data Engineer to join a high-profile retail project based in Cape Town. The successful candidate will play a key role in designing, developing, and maintaining data pipelines, data warehouses, and scalable data models that support business intelligence and analytics initiatives.

This position is ideal for a Data Engineer with strong Microsoft data platform expertise, hands‑on ETL/ELT experience, and the ability to collaborate effectively with both technical and business stakeholders.

Key Responsibilities

• Design, develop, and maintain data pipelines and integration solutions.
• Build and support enterprise data warehouses and scalable data models.
• Develop and maintain ETL/ELT processes using Microsoft data technologies.
• Manage and support on‑premises data workloads and pipeline operations.
• Ensure data quality, integrity, and consistency across data platforms.
• Implement data governance, security, and compliance best practices, including POPIA requirements.
• Collaborate with business stakeholders to understand data requirements and deliver effective solutions.
• Support reporting and analytics initiatives by providing clean and reliable datasets.
• Contribute to testing, monitoring, and ongoing optimization of data solutions.

Required Skills & Experience

• Minimum 5 years of Data Engineering experience.

Strong experience with:

• SSAS (SQL Server Analysis Services)
• ETL and ELT development
• Data warehouse design and development
• Experience building and maintaining data pipelines.
• Experience working with Databricks and Python.
• Understanding of data governance, security, testing, and data quality processes.
• Strong stakeholder engagement and communication skills.
• Experience supporting on‑premises environments and workloads.
• Exposure to business intelligence and reporting platforms such as:
• Power BI
• Tableau
• Experience within retail or consumer-focused environments.
• Knowledge of POPIA compliance and data privacy regulations.