
SQL Developer – Remote in South Africa
- Remote, Hybrid
- Kaapstad, Western Cape, South Africa
Job description
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!
or
All done!
Your application has been successfully submitted!