Data Engineer

Cape Town - South Africa

Monthly Salary: Not Disclosed

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

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

Required Skills:

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

Location: Cape Town Work Type: Hybrid Job ID: J107087About 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...

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

About our client:

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.