DCM - ETL Developer - 1DP

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.