Sql Developer – Remote In South Africa

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

Job summary

A dynamic data solutions company in Cape Town is looking for a hands-on SQL Developer with 2–3 years of experience. You'll build and maintain data pipelines, optimize T-SQL, and ensure data quality. The ideal candidate will have strong T-SQL skills, ETL experience, and familiarity with Power BI. Join us to enhance our contact centre's data capabilities!

Qualifications

• 2–3 years in an SQL Developer / Data Engineer role with Microsoft SQL Server preferred.
• Experience creating and optimizing stored procedures, views, functions, and indexes.
• Working knowledge of ETL (SSIS or equivalent) and scheduling (SQL Agent).

Responsibilities

• Build and maintain reliable data pipelines.
• Optimize complex T-SQL for operational insights.
• Implement validation and auditing aligned to POPIA.

Skills

Strong T-SQL skills

ETL / Data Pipelines

Data Quality & Governance

Performance Tuning

Data Modelling

Attention to detail

Tools

Microsoft SQL Server

Power BI

Azure Data Factory

Job description

Hi thereWe'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 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).

Data Modelling & Control

Solid understanding of data modelling (OLTP vs. reporting), normalization / denormalization, and query optimization for table performance with source control (Git) and basic CI / CD concepts.

Attention to detail, ownership mindset, and clear communication with non‑technical stakeholders.

Industry Experience

BPO / Contact Centre / Debt Collections (dialer data, agent performance, campaigns, dispositions, promise‑to‑pay, etc.).

Azure & Power BI Exposure

Exposure to Azure SQL / Azure Data Factory / Synapse. Familiarity with Power BI data modelling and DAX fundamentals.

Data Privacy & Compliance

Experience with data privacy & compliance (POPIA / GDPR) and secure data handling.

Other Requirements

Conduct weekly room audits and ensure training facilities are ready.

Does this vacancy appeal to you?

Apply now