Senior Data Engineer

Parvana; Cape Town; On-site; ZAR 550,000 - 750,000; Full time

Benefits offered by this job

Generous salaries

Industry-leading benefits

Career development opportunities

Job summary

A leading investment advisory firm in Cape Town is seeking a Data Engineer to develop and maintain scalable data architectures and monitor complex ETL/ELT workflows. The ideal candidate will have proficiency in SQL Server and experience in data design. This role offers opportunities to work with advanced tools in a hybrid environment, ensuring a dynamic and collaborative culture that invests significantly in employee wellness and development.

Qualifications

• Proficiency in SQL Server and performance-oriented SQL queries.
• Experience with data design and implementing data models.

Responsibilities

• Develop and maintain scalable data architectures.
• Monitor ETL/ELT workflows and data pipelines.
• Implement transformation and validation for data integrity.

Skills

SQL queries tuning

Data architecture development

ETL/ELT workflows

Data pipelines

Data quality assurance

Tools

Azure Data Factory

SQL Server

Job description

Cape Town, South Africa | Posted on 16/03/2026

Location: Cape Town | Work Type: Hybrid | Job ID: J107087

About our client:

Our client is a global investment advisory firm focusing on long-term value creation through investment strategies. They work with a diverse group of institutional partners and pride themselves on their collaborative, sustainable, inclusive culture and performance. You are welcome to go into the office daily or to take advantage of their hybrid in-office / remote benefit. This company places significant investment in employee wellness, their benefits which are on top of generous basic salaries, are industry leading in their generosity. Our client is large, offering fantastic career development opportunities but also very dynamic, they track as many metrics as possible in order to continuously improve - they spare no expense on the tools to do so. Automation, AI and R&D are pillars of their business framework which ensures you should never be at risk of falling behind or getting stuck working with old legacy software. Culturally they are very cosmopolitan and diverse, you will be working with the best globally.

What you will be doing:

• Assist in developing and maintaining scalable data architectures and designing efficient data models for reporting / analytics.
  
• Develop, support, and monitor complex ETL/ELT workflows and data pipelines, primarily using Azure Data Factory (ADF).
  
• Write and fine-tune complex, performance-oriented SQL queries, stored procedures, and views, solving intermediate to advanced SQL challenges.
  
• Implement transformation and validation scenarios to ensure high data quality and integrity.
  
• Work closely with data engineering and BI teams to deliver reliable, production-grade data solutions.
  

What our client is looking for:

• Proficiency in writing, tuning, and optimising complex SQL queries, stored procedures, and views, particularly within SQL Server, with a focus on performance.
  
• Proven expertise in effective data design and implementing robust data models.
  

Requirements

Data Engineer, Azure Data Factory (ADF), ETL/ELT, Data Pipelines, SQL Queries, SQL Server, Data Modelling, BI Teams, Investment Advisory