Senior ETL Developer – Discovery Health | Johannesburg, Gauteng | High-Paying BI Jobs in South Africa
Company: Discovery Health
Location: Johannesburg, Gauteng
Business Unit: Discovery Health
Function: Business Intelligence
Date Posted: 15 May 2025
Contract Type: Permanent
Application Closing Date: 31 May 2025
About Discovery
Discovery is a globally renowned financial services group focused on making people healthier and enhancing and protecting their lives. Built on innovation, Discovery thrives in a high-performance, fast-paced environment where driven professionals can achieve their full potential. As a company that leads with purpose, Discovery is committed to transforming industries and societies by investing in talent, innovation, and shared value.
Role Overview: Senior ETL Developer
Discovery Health is seeking a highly skilled Senior ETL Developer with extensive experience in data warehouse development to join its Business Intelligence division. This is a high-impact role responsible for building, optimizing, and managing complex ETL solutions that support decision-making across the organization. The ideal candidate will also serve as a mentor to junior developers and ensure alignment with enterprise data architecture standards.
This is a senior-level technical position suitable for an individual with deep experience in T-SQL, PL/SQL, SSIS, SSAS, and star-schema modeling, capable of translating intricate business requirements into scalable and maintainable ETL pipelines.
Key Purpose of the Role
To construct high-quality, robust business intelligence solutions by translating BI specifications into efficient and error-free ETL code. The role also includes mentoring junior developers, ensuring code quality, and resolving production data issues in line with the organization’s SLAs.
Key Responsibilities
-
Translate Source-to-Target Mappings (STTM) into executable, optimized ETL code
-
Identify and resolve software and data pipeline issues efficiently
-
Ensure ETL code meets business requirements and performs at scale
-
Release defect-free source code into production environments
-
Lead and support code reviews while coaching junior team members
-
Conduct thorough unit testing and implement fixes for any identified defects
-
Collaborate with BI Analysts to review and refine technical specifications
-
Maintain and monitor production batch executions and resolve failures within SLA
-
Enhance existing ETL architecture and manage changes through to production
-
Participate in design and code reviews, and maintain all code documentation
Technical Knowledge and Tools
-
Deep understanding of SDLC, ITIL processes, and agile methodologies
-
Strong command of SQL Server, Oracle, T/SQL, and PL/SQL
-
Proficiency in Microsoft SSIS, SSAS, and SSRS
-
Familiarity with software architecture and data modeling best practices
-
Experience with Type 2 and Type 3 slowly changing dimensions, waterline handling, and metadata integration
-
Understanding of production system archiving strategies and performance optimization
-
Hands-on experience with hardware resource management, solution architecture, and QA environments
Required Skills and Competencies
Technical Skills:
-
Expert-level SQL development and stored procedure optimization
-
Proficiency in data warehouse solutions on SQL Server and Oracle platforms
-
Dimension modeling, particularly star-schema design
-
Extensive experience with Microsoft BI stack (SSIS, SSAS, SSRS)
-
Strong software testing and debugging capabilities
-
Familiarity with metadata management and batch scheduling
Behavioural Competencies:
-
Results-driven and performance-oriented
-
Strong time management and organizational abilities
-
Excellent communication (verbal and written)
-
Innovative and proactive approach to problem-solving
-
Adaptability to change and fast-moving project environments
-
Ability to mentor, lead, and collaborate with cross-functional teams
Educational Qualifications
-
Essential: Bachelor’s Degree in Engineering, Commerce, Computer Science, or related field
-
Exposure to MOF or other modern development methodologies is advantageous
Experience Required
-
10 to 15 years in software and ETL development within large-scale enterprise environments
-
At least 10 years’ experience in Data Warehouse code development
-
In-depth experience working with integrated star schemas and performance tuning in BI systems
What Discovery Offers
-
A dynamic, innovative work environment
-
Access to cutting-edge BI technologies and platforms
-
Opportunities for ongoing skills development and training
-
A culture that values innovation, ownership, and collaboration
-
Competitive remuneration and benefits tailored to professionals in tech
Employment Equity Statement
Discovery is an equal opportunity employer. The company’s approved Employment Equity Plan and Targets will be considered as part of the recruitment process. We actively encourage people with various disabilities to apply.
How to Apply
If you’re a seasoned ETL Developer looking to make a real impact in South Africa’s most innovative health insurer, apply via the Discovery careers portal. Reference the role: Senior ETL Developer – Business Intelligence.
Leave a Reply