2,292,754open jobs
145,640companies
270,928added this week
Browse all
Location
Hybrid
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 Oct 14, 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.

This is a remote position.

Location: Cape Town | Work Type: Hybrid / Remote | Job ID: J107208

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. Write highly efficient, scalable, and maintainable T-SQL code, including advanced stored procedures, views, functions, and triggers.
  • Deeply analyse execution plans, troubleshoot complex performance issues, and implement advanced indexing, partitioning, and query refactoring strategies to resolve critical bottlenecks in high-volume workloads.
  • Design robust, scalable relational data models (OLTP/3NF) and analytical structures optimised for data integrity, low-latency data access, and seamless reporting.
  • Ensure solutions reduce impact on transactional systems by optimising data access patterns and separating operational and reporting workloads.
  • Define and enforce strict standards for naming conventions, database design, and documentation; lead code reviews and champion SQL development best practices.
  • Mentor junior developers and engineers on advanced SQL optimization and relational modelling practices. Work closely with backend application developers, BI teams, and business analysts to support data requirements.
  • Assist with and maintain existing data ingestion processes, providing SQL support for ETL/ELT pipelines and integrations where necessary.

What our client is looking for:

  • 6+ years of deep, hands-on experience in complex T-SQL query development, advanced stored procedures, views, user-defined functions, and execution plan analysis.
  • Proven track record of diagnosing and resolving severe performance bottlenecks related to locking, blocking, deadlocks, and IO/memory optimization in large-scale SQL Server environments.
  • Mastery of indexing strategies (clustered, non-clustered, columnstore, filtered) and table partitioning to optimize massive datasets.
  • Deep expertise in designing highly normalised relational models (3NF/OLTP), with a strong understanding of dimensional modelling (star/snowflake schemas) as a secondary benefit.
  • Experience with ETL/ELT processes and data pipeline tools (e.g., SSIS, Azure Data Factory, dbt) is highly advantageous but considered a secondary requirement to core database development.
  • Familiarity with Azure SQL, Git, Azure DevOps, CI/CD pipelines for databases, or BI tools like Power BI/Tableau is a plus.

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
In your city
In office · Leeds
SQL
Databases
Databricks
Delta Lake
AI/ML
AI Agents
DevOps
GCP
Azure
AWS
Analytics
ETL/ELT
Apply
Data Engineer 3 months ago
Hybrid · Full-Time · Cape Town
Python
SQL
Databases
Snowflake
AI/ML
dbt
Analytics
Fivetran
Apply
Senior Data Engineer 2 months ago
Hybrid · Full-Time · 6+ years exp · Cape Town
SQL
Databases
MS SQL
Azure SQL Database
Microsoft Fabric
AI/ML
dbt
DevOps
Azure DevOps
Azure
CI/CD
Git
Analytics
Tableau
Power BI
ETL/ELT
Informatica
SSIS
Azure Data Factory
Dimensional Modeling
Apply
Hybrid · Full-Time · Johannesburg
Python
SQL
Databases
PostgreSQL
Snowflake
MS SQL
Analytics
Power BI
ETL/ELT
Dimensional Modeling
Management
Agile
Scrum
Apply
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
See all jobs
This is one of many
2,292,754 more open roles from verified company boards, updated every day.