Data Engineer – SQL/SSIS & ETL

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

Our client in the banking industry is looking for a hands‑on Data Engineer to develop, maintain and support data integration, ETL and data processing solutions.

The ideal candidate will have strong practical experience in SQL, SSIS/ETL, batch processing and data warehousing, with the ability to investigate technical and data‑quality issues and engage effectively with business and technical stakeholders. Successful candidates must be based in Gauteng.

Key Responsibilities

• Develop and support SQL and SSIS/ETL solutions from source extraction through transformation, validation and loading.
• Develop and maintain scheduled batch data‑processing pipelines.
• Perform data cleansing, transformation, validation and source‑to‑target reconciliation.
• Investigate and resolve SQL, ETL, data‑quality and batch‑processing issues.
• Implement appropriate error handling, logging, monitoring and recovery processes.
• Work with business users, source‑system owners, developers, DBAs and project managers to understand requirements and resolve data issues.
• Document source‑to‑target data mappings and communicate technical issues, risks and dependencies.
• Contribute to data architecture discussions and work effectively within an Agile environment.

Essential Requirements

• Strong practical SQL development experience, including complex queries, joins, CTEs, subqueries, stored procedures, functions, aggregations and window functions.
• Strong SSIS / ETL experience, including Control Flow, Data Flow, transformations, Lookups, error handling, logging and incremental/full data loads.
• Experience with batch processing and scheduled data pipelines, including job dependencies, file processing, failure recovery and large data volumes.
• Understanding of data warehousing and data integration concepts, including OLTP/OLAP, staging, data warehouses, data marts, source‑to‑target flows and multiple source systems.
• Strong problem‑solving and analytical skills with the ability to independently investigate root causes.
• Experience working in an Agile environment (Scrum/Kanban).
• Strong communication skills and confidence engaging with clients, business users and technical teams.

Production Support Requirements

This role includes participation in a rotational production support schedule. The successful candidate must be willing and able to:

• Participate in an on‑call roster every third week.
• Respond to after‑hours callouts, including late‑night and early‑morning alerts.
• Support and troubleshoot issues affecting the nightly batch process to ensure successful completion.
• Work collaboratively with operations and infrastructure teams to resolve time‑sensitive issues under pressure.
• Maintain support logs, escalated critical incidents and ensure accurate handovers.
• Support the availability and continuity of enterprise data services required by business users and systems.

Advantageous

• Control‑M or another enterprise scheduling/orchestration tool.
• C# / SSIS Script Task experience.
• Database Administration.
• Cloud data platforms.
• Data quality/profiling.
• Performance tuning.

Key Competencies

• Analytical and logical thinking.
• Strong attention to detail.
• Good communication and documentation skills.
• Ability to work independently and collaboratively.
• Ability to manage competing priorities and deadlines.
• Strong understanding of data quality and integrity.
• Willingness to learn new technologies.

Ideal Candidate

A practical Data Engineer who can take a data requirement, understand the source data, develop the SQL/ETL solution, implement validation and error handling, support batch processing, troubleshoot issues and communicate effectively with stakeholders.