SQL Developer – Remote in South Africa

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

Job summary

A leading data solutions provider is seeking an experienced SQL Developer in Durban to enhance data pipelines for their BPO operations. The role requires 2–3 years of experience, strong T-SQL skills, and familiarity with ETL processes. Ideal candidates will tackle data issues, ensure high performance of SQL solutions, and collaborate with various teams for effective reporting. Join the team to make data actionable and impactful.

Qualifications

• 2–3 years in an SQL Developer / Data Engineer role with Microsoft SQL Server.
• Strong T-SQL skills including complex joins and dynamic SQL.
• Experience with data modeling and normalization.

Responsibilities

• Design and develop SQL solutions for data processing.
• Build and maintain ETL processes for data ingestion.
• Monitor daily data loads and troubleshoot issues.

Skills

T-SQL

ETL

Data Quality

Data Governance

Performance Tuning

Tools

Power BI

Azure SQL

SSIS

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!