SQL Developer – Remote in South Africa

Custom Connect; Cape Town; Remote; ZAR 300,000 - 400,000; Full time

Job summary

A dynamic data solutions provider in Cape Town is seeking an experienced SQL Developer to optimize data processes and support operational tasks in a BPO environment. The ideal candidate will have 2–3 years of SQL Developer experience, strong T-SQL skills, and familiarity with data quality governance. This role involves developing SQL solutions, building ETL pipelines, and collaborating with stakeholders to deliver actionable insights.

Qualifications

• Experience with high volume BPO/collections datasets is preferred.
• Comfortable with source control (Git) and basic CI/CD concepts.
• Experience creating and optimizing stored procedures, views, functions, and indexes.

Responsibilities

• Build and maintain data pipelines and optimize T-SQL.
• Implement validation and reconciliation aligned to internal controls.
• Prepare curated tables/views for BI and ensure semantic consistency.

Skills

Strong T-SQL skills

Attention to detail

Collaboration

Data Quality & Governance

Performance Tuning

Education

2–3 years in an SQL Developer / Data Engineer role

Tools

Microsoft SQL Server

SSIS

Azure Data Factory

Power BI

Git

Job description

Overview

Hi there! We’re looking for a hands-on SQL Developer with 2–3 years of experience to join our Data team. You’ll help build and maintain reliable data pipelines, optimize complex T SQL, and turn raw operational data into accurate, actionable insights for our contact centre and collections lines of business.

If you’ve worked with high volume BPO/collections datasets, care about performance and data quality, and enjoy partnering with stakeholders to solve problems fast, we’d love to meet you.

Skills & Knowledge

• Design & Develop SQL Solutions: Write clean, well-documented T SQL (stored procedures, functions, views, triggers) for data processing and reporting.
• ETL / Data Pipelines: Build and maintain ingestion and transformation jobs (e.g., SSIS, SQL Agent jobs, Azure Data Factory advantageous).
• Performance Tuning: Analyze execution plans, index strategies, and query patterns to improve reliability and speed.
• Data Quality & Governance: Implement validation, reconciliation, lineage, and auditing aligned to POPIA and internal controls.
• Operational Support: Monitor daily loads, troubleshoot failures, and resolve data issues with urgency and root cause mindset.
• Reporting Enablement: Prepare curated tables/views for BI (e.g., Power BI) and ensure semantic consistency across teams.
• Collaboration: Work closely with Ops, Finance, and Client Services to understand requirements and deliver pragmatic solutions.

Qualifications

• 2–3 years in an SQL Developer / Data Engineer role with Microsoft SQL Server (2016+ preferred).
• Strong T-SQL skills: complex joins, window functions, CTEs, pivots, dynamic SQL, error handling.
• Experience creating and optimizing stored procedures, views, functions, and indexes.
• Working knowledge of ETL (SSIS or equivalent) and scheduling (SQL Agent).
• Solid understanding of data modelling (OLTP vs. reporting), normalization/denormalization, and query optimization.
• Comfortable with source control (Git) and basic CI/CD concepts.
• Attention to detail, ownership mindset, and clear communication with non-technical stakeholders.

The ideal candidate should possess

• Industry experience in BPO / Contact Centre / Debt Collections (dialer data, agent performance, campaigns, dispositions, promise-to-pay, etc.).
• Exposure to Azure SQL / Azure Data Factory / Synapse.
• Familiarity with Power BI data modelling and DAX fundamentals.
• Experience with data privacy & compliance (POPIA/GDPR) and secure data handling.
• Conduct weekly room audits and ensure training facilities are ready

Does this vacancy appeal to you? Apply now!