Senior Data Warehouse Engineer

DeARX; Pretoria; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading data solutions provider in Pretoria seeks a Senior Data Warehouse Engineer for a 12-month contract. This role focuses on stabilizing, optimizing, and governing high-volume data warehouse environments. Candidates should have significant experience with data governance and ETL processes using SSIS. Your expertise will have a direct impact on stability and efficiency. Apply now to leverage your skills in a mission-critical environment.

Qualifications

• Proven experience in complex, high-volume warehouse environments.
• Background in banking or financial services preferred.
• Technical strength in MS SQL and ETL using SSIS.

Responsibilities

• Design, build, and maintain scalable, stable warehouse environments.
• Manage ingestion, transformation, storage, archival, and retrieval processes.
• Establish strong data governance practices.

Skills

Data governance expertise

ETL using SSIS

MS SQL (Mongo, Postgres, Open Query)

Experience in high-volume warehouse environments

Job description

Overview

Duration: 12-month contract with possibility to convert to perm

Location: Pretoria

Are you the go-to expert when it comes to stabilising, optimising, and governing busy data warehouse environments? Do you thrive under pressure in high-volume, highly regulated industries and know how to keep things running smoothly while driving improvements?

We're looking for a Senior Data Warehouse Engineer to take charge of a mission-critical environment on a 12-month contract, based full-time onsite in Pretoria. This is a role where your expertise will directly impact stability, efficiency, and compliance and where you'll be seen as the Subject Matter Expert.

Role Responsibilities

• Architect & Optimise: Design, build, and maintain scalable, stable warehouse environments that support business growth.
• ETL Leadership: Develop and optimise SSIS pipelines with robust controls for accuracy, reliability, and automation.
• Full Data Lifecycle: Manage ingestion, transformation, storage, archival, and retrieval processes end-to-end.
• Governance & Compliance: Establish strong data governance practices, ensuring segregation, cataloguing, and audit readiness.
• Continuous Improvement: Simplify, centralise, and streamline operations to ensure stability and scalability.
• Audit Champion: Partner with auditors and consultants to ensure smooth reviews and compliance checks.

Role Requirements

• Proven experience in complex, high-volume warehouse environments.
• Background in banking or financial services (preferred), with exposure to regulatory and audit-heavy environments.
• Strong expertise in data governance, frameworks, and control processes.
• Technical strength in:
• MS SQL (on-prem, heterogeneous environment: Mongo, Postgres, Open Query)
• ETL using SSIS, automated control environments, and SQLM Control integrated with SSMS.
• Demonstrated ability to stabilise and scale existing data ecosystems.
• Comfortable engaging with auditors, consultants, and both technical and business stakeholders.

Why This Role?

• Impact: Your work will directly stabilise and improve a warehouse that underpins critical operations.
• Challenge: An opportunity to tackle high-volume, high-stakes data environments.
• Recognition: Be the trusted SME in a role where your skills are highly visible and valued.
• Contract with Purpose: A 12-month engagement that could open doors to further opportunities.

If you're a seasoned Data Warehouse Engineer ready to bring stability, governance, and efficiency to a busy environment, we'd love to hear from you.

Apply now and put your expertise where it really matters.