Senior ETL Developer & DBA: Build Scalable Data Pipelines

ATS Client; Johannesburg; On-site; ZAR 900,000 - 1,600,000; Full time

Job summary

ATS Client in Johannesburg is seeking a Senior ETL Developer & Database Administrator to build robust data solutions and oversee SQL Server databases. You will develop ETL processes, optimise performance, and ensure security and availability across BI initiatives.

Collaborate with analysts and developers to drive data excellence, improve data quality, and support reporting and analytics across the business. Strong communication and documentation skills are essential.

Qualifications

• 7+ years of ETL development experience.
• 4+ years of SQL Server Database Administration experience.
• Experience with ETL tools such as Qlik, Airbyte, Talend, SSIS, DataStage or similar.

Responsibilities

• Design, develop, and maintain scalable ETL processes and data pipelines.
• Translate business requirements into data integration solutions.
• Optimise ETL workflows for performance, reliability, and scalability.
• Support migrations to new ETL platforms and technologies.
• Manage SQL Server databases to ensure high availability and performance.
• Perform backups, recovery procedures, maintenance, patching, and upgrades.
• Implement database security, permissions, and audit controls.
• Optimise SQL queries and database structures.
• Ensure data quality through validation, cleansing, and transformation.

Skills

ETL development

Database administration

SQL

Data warehousing

Agile/Scrum

Documentation

Education

Bachelor's Degree in Computer Science/Information Systems

Tools

Qlik

Airbyte

Talend

SSIS

DataStage

Git

Job description

ATS Client in Johannesburg is seeking a Senior ETL Developer & Database Administrator to build robust data solutions and oversee SQL Server databases. You will develop ETL processes, optimise performance, and ensure security and availability across BI initiatives.

Collaborate with analysts and developers to drive data excellence, improve data quality, and support reporting and analytics across the business. Strong communication and documentation skills are essential.