ETL Developer at Discovery Limited

Key Purpose

Construction of complex BI Solutions based on specifications produced by the BI Architects and Systems Analysts. (BI Solutions imply ETL / Analytics / Presentation).

Driving Engagement and building relationships with key stakeholders which include Systems Analysts, BI Architects and QA Manager

Key Outputs:

• Develop and maintain SSIS packages
• 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
• Team engagement champion
• Improving robustness and stability of ETL batches
• 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

Technical Skills:

• T-SQL, SQL  Advanced
• SQL Server BI Stack (SSIS, SSMS)   Advanced
• MS Excel     Advanced
• 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

• National Diploma in Information Technology or a Bachelor’s degree
• Certification on Microsoft  or other ETL Tools                  
• Kimball related courses (dimensional modelling)  

Minimum Required Experience

• Minimum of 4 years’ experience in BI Development in SQL Server Integration Services & Management Studio.