Senior Data Engineer — Payments Data Pipelines & Warehouse

Capital H Staffing and Advisory Solutions; Stellenbosch; On-site; ZAR 900,000 - 1,300,000; Full time

Job summary

Capital H Staffing and Advisory Solutions is seeking a Senior Data Engineer for a leading South African payment aggregator. Design, build and maintain scalable data pipelines and warehouses spanning SQL Server, PostgreSQL, Sage One, Xero, and Dataverse to support financial reporting, fraud detection, and analytics.

You will deliver data products, ensure data quality, collaborate with data architects, and implement governance and monitoring for tens of millions of rows monthly.

Qualifications

• Degree in a quantitative field (Information Systems, Computer Science, Mathematics, Statistics or Finance).
• 8+ years relevant experience in data engineering or related roles.
• Proven experience in Python-based data engineering projects.
• Strong proficiency in SQL and Python for data transformation and automation.
• Experience with data orchestration tools (e.g., Airflow).
• Excellent problem-solving and communication skills.

Responsibilities

• Build and maintain robust ETL/ELT pipelines using Python, SQL, and cloud-native tools to ingest and transform data from 40+ payment networks and internal systems.
• Join and harmonize data across diverse sources including transactional databases, accounting systems, and CRM platforms.
• Work closely with developers, analysts, and business stakeholders to ensure data accuracy, security, and accessibility.
• Implement data quality checks, performance tuning, and monitoring for pipelines handling tens of millions of rows monthly.
• Maintain clear documentation and follow best practices for data architecture, version control, and deployment.

Skills

Python

SQL

Airflow

Education

Degree in quantitative field

Tools

SQL Server

PostgreSQL

Sage One

Xero

Microsoft Dataverse

Job description

Capital H Staffing and Advisory Solutions is seeking a Senior Data Engineer for a leading South African payment aggregator. Design, build and maintain scalable data pipelines and warehouses spanning SQL Server, PostgreSQL, Sage One, Xero, and Dataverse to support financial reporting, fraud detection, and analytics.

You will deliver data products, ensure data quality, collaborate with data architects, and implement governance and monitoring for tens of millions of rows monthly.