SQL Developer

PBT Group; Cape Town; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A leading technology firm in Cape Town is looking for a skilled SQL Developer to enhance their Business Intelligence delivery team. The role requires at least 3 years of experience in SQL and ETL development, focusing on building and optimising solutions on AWS. You will collaborate with data engineers and analysts to deliver high-quality data integration and BI solutions, applying best practices within the Microsoft technology stack for optimal results.

Qualifications

• Minimum 3 years of hands-on experience as a SQL / BI / ETL Developer.
• Strong proficiency in Microsoft SQL Server (T-SQL), including performance tuning.
• Proven experience developing ETL solutions using SSIS.

Responsibilities

• Design, develop, optimise, and maintain complex SQL Server queries.
• Build, enhance, and support ETL pipelines using SSIS.
• Deliver trusted datasets for dashboards and reports.

Skills

T-SQL performance tuning

ETL development with SSIS

Data warehousing concepts

Collaboration with analysts and stakeholders

Tools

Microsoft SQL Server

SSIS

Power BI

Job description

Overview

SQL Developer position available in Cape Town. We are seeking a skilled SQL Developer / ETL Developer with at least 3 years of experience to join our Business Intelligence (BI) delivery team. You will work closely with data engineers, analysts, and platform teams to design, build, and optimise scalable solutions on AWS. The successful candidate will play a key role in designing, developing, and maintaining data integration and BI solutions using the Microsoft technology stack.

Key Responsibilities

• Design, develop, optimise, and maintain complex SQL Server queries, views, stored procedures, and functions.
• Build, enhance, and support ETL pipelines using SQL Server Integration Services (SSIS) to ingest, transform, and load data into data warehouses and data marts.
• Participate in BI projects, delivering trusted datasets for dashboards, reports, and analytical models.
• Collaborate with business analysts, data engineers, and stakeholders to translate business requirements into technical solutions.
• Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Design and support dimensional data models (fact and dimension tables).
• Troubleshoot performance issues and optimise SQL Server and SSIS packages.
• Maintain technical documentation, including ETL mappings, data models, and process flows.
• Support deployments and production environments using Azure DevOps or similar tools.
• Apply best practices for version control, change management, and CI/CD within the Microsoft ecosystem.

Required Skills & Experience

• Minimum 3 years of hands-on experience as a SQL / BI / ETL Developer.
• Strong proficiency in Microsoft SQL Server (T-SQL), including performance tuning and query optimisation.
• Proven experience developing ETL solutions using SSIS.
• Solid understanding of data warehousing concepts, including dimensional modelling (Star/Snowflake schemas).
• Experience across the Microsoft BI stack, including:
• SQL Server
• SSIS
• SSRS and/or Power BI (advantageous)