Data Engineer: SQL/ETL & SSIS Specialist

Praesignis (Pty) Ltd; Gauteng; On-site; ZAR 660,000 - 900,000; Full time

Job summary

Praesignis (Pty) Ltd in Gauteng seeks a hands-on Data Engineer to develop, maintain and support data integration, ETL and data processing solutions. The role emphasizes strong SQL and SSIS/ETL capabilities and batch processing within a data warehousing context.

The ideal candidate will investigate data-quality issues, engage with business and technical stakeholders, and operate in an Agile environment with production support duties including on-call rotations.

Qualifications

• Strong SQL development experience with complex queries, joins and window functions.
• Proven SSIS/ETL experience including data flows, error handling and incremental loads.
• Experience with batch processing, job dependencies and large data volumes.
• Understanding of OLTP/OLAP, staging areas and data marts within data warehousing.

Responsibilities

• Develop and support SQL/SSIS ETL solutions from source to target.
• Build and maintain scheduled batch data pipelines.
• Perform data cleansing, transformation and reconciliation across systems.
• Investigate and resolve SQL/ETL/data quality issues.
• Implement error handling, logging, and recovery processes.
• Collaborate with business users, developers and project managers to translate requirements.
• Document data mappings and data lineage; communicate risks and dependencies.
• Contribute to data architecture discussions in an Agile environment.

Skills

SQL development

ETL & SSIS

Batch processing

Data warehousing

Analytical thinking

Agile collaboration

Tools

SSIS

Control-M

SQL Server

Job description

Praesignis (Pty) Ltd in Gauteng seeks a hands-on Data Engineer to develop, maintain and support data integration, ETL and data processing solutions. The role emphasizes strong SQL and SSIS/ETL capabilities and batch processing within a data warehousing context.

The ideal candidate will investigate data-quality issues, engage with business and technical stakeholders, and operate in an Agile environment with production support duties including on-call rotations.