BI Developer ETL - Sandton Verfied

R 360 per hour Sandton, Gauteng Sandton, Gauteng more than 14 days ago 11-02-2015 8:40:49 AM
11-03-2015 8:40:49 AM
BI Developer ETL
Location: Sandton
Contract Period: 6-12 months (start 01 March 2015)

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
Develop and maintain SSAS models
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
Create Metadata repositories
Dynamic Sql

Competencies:
Knowledge:
Systems Development Life Cycle (SDLC) Advanced level
Data Security and Protection Policies Intermediate
Data Warehouse principles and practises Advanced
Kimball Methodology Advanced
Health Insurance industry knowledge Intermediate

Technical Skills:
T-SQL, SQL Advanced
SQL Server BI Stack (SSIS, SSAS, SSRS, SSMS) Advanced
MS Excel Advanced
MDX Advantageous
DAX Advantageous
Dimensional Modelling Intermediate
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 Experience:
Qualifications:
Matric
National Diploma in Information Technology or a Bachelor’s degree (Essential)
Kimball related courses (dimensional modelling) (Advantageous)
Certification on Microsoft or other ETL Tools (Advantageous)
Minimum Required
Experience: Type of Industry
INDUSTRY
NO. OF YEARS*
ESSENTIAL / ADVANTAGEOUS*
BI Development in SQL Server Finance / Risk 4 Essential

Certification on Microsoft or other ETL Tools (Advantageous)
Minimum Required Experience: TYPE OF EXPERIENCE INDUSTRY NO. OF YEARS* ESSENTIAL / ADVANTAGEOUS*
BI Development in SQL Server Finance / Risk 4 Essential

Recruiter: O2 Placements