2,292,754open jobs
145,640companies
270,928added this week
Browse all
Location
Hybrid (Cape Town, South Africa)
Seniority
Senior · 6+ years exp
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Sep 10, 2026.

Overview
Company
Impact
Profile match
Looking for top IT talent? Parvana is a leading IT Recruitment Agency connecting tech pros with top companies in Cape Town, South Africa, and the UK. Get expert hiring solutions today.

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:

  • Design, develop, and optimize complex SQL Server database solutions, writing efficient, scalable, and maintainable T-SQL code, including stored procedures, views, functions, and queries.
  • Analyse execution plans, troubleshoot performance issues, and implement indexing, partitioning, and optimization strategies to resolve bottlenecks related to large datasets and high-volume workloads.
  • Design scalable relational and analytical data models, building structures optimised for both operational and reporting workloads.
  • Build and maintain data ingestion and transformation processes, developing reliable ETL/ELT pipelines and integrating data from internal and external systems.
  • Ensure solutions are scalable, reliable, and maintainable, optimising data access patterns and reducing the impact on transactional systems.
  • Define standards for naming conventions, database design, and documentation; contribute to code reviews and enforce SQL/database best practices.
  • Mentor developers and engineers on SQL optimization and data engineering practices, and work closely with application developers, BI teams, analysts, and stakeholders.
  • Support backend application data requirements and reporting needs, promote high-quality, testable solutions, and contribute to ongoing improvements in data architecture and engineering practices.

What our client is looking for:

  • 6+ years of hands-on experience in complex query development, stored procedures, execution plan analysis, and comprehensive query optimization and troubleshooting.
  • Deep expertise in indexing strategies, partitioning, transaction management, and resolving performance bottlenecks related to locking, blocking, deadlocks, and IO/memory optimization, especially with large-scale data.
  • Strong experience designing both normalised relational models (3NF/OLTP) and dimensional models (star/snowflake schemas), with a focus on data integrity, scalability, and historical data tracking.
  • Proven ability to design solutions separating transactional and reporting workloads, diagnose and resolve performance issues through index tuning, query refactoring, and data access optimization.
  • Experience in ETL/ELT processes and data pipeline design, utilising tools like Azure Data Factory (ADF), SSIS, dbt, Informatica, and integrating various data sources (APIs, flat files, JSON/XML).
  • Familiarity with Azure SQL, Synapse Analytics, Microsoft Fabric, Data Lake architectures, Git, Azure DevOps, CI/CD pipelines, engineering standards, and beneficial familiarity with BI tools like Power BI/Tableau.

For a more comprehensive list of opportunities that we have on offer, do visit our website - https://www.parvana.co.uk/careers

Requirements

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

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,292,754 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Similar stack
Same company
Cape Town
Data Engineer 13 days ago
Hybrid · Full-Time · 4+ years exp · Cape Town
Python
SQL
Python
pySpark
Databases
Snowflake
MS SQL
AI/ML
Spark
Airflow
Dagster
dbt
DevOps
Terraform
AWS CDK
CloudFormation
CI/CD
AWS
AWS Lambda
GitHub
Amazon S3
AWS Step Functions
Analytics
Power BI
SSIS
Fivetran
Dimensional Modeling
Apply
Data Engineer 5 days ago
Hybrid · Full-Time · 3+ years exp · Cape Town
Python
Java
SQL
Scala
Databases
MySQL
PostgreSQL
Databricks
MS SQL
DevOps
GCP
Azure
CI/CD
Git
AWS
AWS Lambda
Linux
Analytics
Power BI
ETL/ELT
SSIS
Apply
Hybrid · Full-Time · Cape Town
Python
SQL
Databases
Snowflake
Amazon Redshift
AI/ML
NLP
Amazon SageMaker
Machine Learning
DevOps
AWS
AWS Lambda
Amazon S3
Analytics
Power BI
Apply
In office · Freelance · 5+ years exp · Bachelor's Degree · Randburg
SQL
Bash
Databases
MySQL
PostgreSQL
Oracle
DevOps
Red Hat
Linux
Management
Agile
ITIL
Apply
In office · 8+ years exp · PhD · Cape Town
Python
SQL
AI/ML
AI Agents
Apply
In office · 8+ years exp · PhD · Cape Town
Python
SQL
AI/ML
AI Agents
Apply
$25k – $28k per year (gross) · Remote (South Africa) · Full-Time · Cape Town
Apply
$11k – $13k per year (gross) · In office · Full-Time · Cape Town
Apply
Website Editor 1 day ago
In office · 3+ years exp · Cape Town
Apply
Product Designer 1 day ago
Hybrid · 3+ years exp · Cape Town
Design
Figma
Management
Agile
Apply
See all jobs
This is one of many
2,292,754 more open roles from verified company boards, updated every day.