DCM - ETL Developer - 1DP at Discovery Limited

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)
• Data Security and Protection Policies
• Data Warehouse principles and practises
• Kimball Methodology 
• Financial Services industry knowledge         
• BI Reporting (front-end)                                      

Technical Skills:

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

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