Job Description

Business Unit:

DCM Distribution

Function:

Data Analysis

Date:

19 Jan 2026

Key Purpose

The ETL/BI Developer is responsible for designing, developing, and maintaining robust data integration pipelines and business intelligence solutions that support analytical, operational, and strategic decision-making, as specified by the BI Architect and Systems Analysts. The role involves transforming raw data into clean, reliable datasets and developing dashboards, reports, and data models that deliver actionable insights to stakeholders across the organization. The developer is also responsible for driving engagement and building relationships with key stakeholders which include Systems Analysts, BI Architects and Data Scientists/Actuaries.

Key Outputs:

Develop and maintain SSIS packages Develop and maintain packages created in other ETL tools (such as Datastage and Cloud Technologies) Design data models, create and manage data marts (including basic warehousing) Create required database structures Develop and maintain T-SQL code Analyse SQL execution plan to optimise performance Version control of developed solutions within a code repository Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications Contribute to the development of architectural guidelines and standards Prototyping, Research and Development of new techniques and solutions Peer review of code and solutions developed Improving robustness and stability of ETL batches Implement data quality checks, validation processes, and automated monitoring Scheduling business processes via ETL tools Experience in developing and maintaining an ETL Framework e.g. ETL controller Create and maintain Metadata and Code repositories Dynamic SQL Develop and maintain SSAS models

Competencies

Knowledge:

Systems Development Life Cycle (SDLC) Advanced level Data Security and Protection Policies Intermediate/Advanced Data Warehouse principles and practises Intermediate/Advanced Kimball Methodology Intermediate/Advanced Financial Services industry knowledge Advantageous BI Reporting (front-end) Advantageous

Technical Skills:

T-SQL, SQL Advanced SQL Server BI Stack (SSIS, SSMS) Advanced MS Excel Advanced Competence with Cloud Platforms Advantageous Experience in GCP Advantageous Power BI Advantageous IBM Datastage Advantageous Python Advantageous MDX Advantageous DAX Advantageous Dimensional Modelling Basic Data Mining Basic

Competencies:

Creating and Innovating Applying Expertise and Technology Analysing Persuading and Influencing Deciding and initiating action Adapting and Responding to Change Learning and Researching Presenting and Communicating Information

Qualification and Skills

Bachelor's degree in computer science/National Diploma in Information Technology/Or similar Certification on Microsoft or other ETL Tools Kimball related courses (dimensional modelling)

Minimum Required Experience

Minimum of 3 years' experience in BI Development using ETL tools such as SSIS (or similar).


EMPLOYMENT EQUITY



The Company's approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.