Senior Data Engineer: SQL/ETL & SSIS for Compliance Tech

Praesignis (Pty) Ltd; Gauteng; On-site; ZAR 700,000 - 1,100,000; Full time

Job summary

Praesignis Pty Ltd is seeking an experienced Data Engineer to join a Compliance Technology environment in a leading financial services organisation in South Africa. You will develop SQL scripts, SSIS packages and ETL workflows, while ensuring data quality, governance and reliable production deployments.

The role requires 5+ years in Data Engineering, strong SQL/SSIS skills, and experience with data warehousing, data modelling and data integration across sources.

Qualifications

• 5+ years' experience in Data Engineering / ETL / SQL development.
• Strong hands-on experience with SQL and Microsoft SQL Server.
• Strong SSIS development experience.
• Solid understanding of ETL/ELT processes and data integration.
• Experience with database performance tuning and query optimisation.
• Experience with data warehousing and data modelling.
• Experience troubleshooting production data and ETL issues.
• Experience working with SIT/UAT and production deployments.
• Strong understanding of data quality, validation and reconciliation.
• Excellent analytical and problem-solving skills.

Responsibilities

• Develop and enhance SQL scripts, queries and database logic.
• Develop, modify and maintain SSIS packages and ETL workflows.
• Perform data integration across multiple source systems.
• Optimise SQL queries, ETL processes and database performance.
• Support data modelling, schema enhancements and data transformation.
• Develop and enhance operational reports and dashboards.
• Perform data validation, reconciliation and data quality checks.
• Investigate and resolve data, ETL and production issues.
• Perform root-cause analysis and implement corrective actions.
• Monitor and support batch processes and scheduled jobs.
• Support SIT/UAT, deployments and production releases.
• Assist with data remediation, governance and compliance-related initiatives.
• Contribute to continuous improvement, process automation and optimisation.

Skills

SQL development

ETL/ELT engineering

Data engineering

SIT/UAT readiness

Data quality

Analytical thinking

Tools

SSIS

Microsoft SQL Server

Azure Data Factory

Microsoft Purview

CI/CD

Job description

Praesignis Pty Ltd is seeking an experienced Data Engineer to join a Compliance Technology environment in a leading financial services organisation in South Africa. You will develop SQL scripts, SSIS packages and ETL workflows, while ensuring data quality, governance and reliable production deployments.

The role requires 5+ years in Data Engineering, strong SQL/SSIS skills, and experience with data warehousing, data modelling and data integration across sources.