Microsoft Data Engineers - Stellenbosch Verfied

Salary Negotiable Stellenbosch, Western Cape Stellenbosch, Western Cape more than 14 days ago 28-06-2019 9:37:13 AM
23-08-2019 9:37:13 AM
PBT Group has an opportunity for Microsoft ETL Developers in with at least 2 years relevant experience, preferably in the financial industry.

Duties:
- Develop and maintain SSIS packages
- Create required database structures
- Develop and maintain T-SQL code
- Version control of developed solutions
- Improving robustness and stability of ETL batches
- Scheduling business processes via ETL tools
- Create Metadata repositories
- Dynamic SQL

Experience:
- 2+ years’ experience in BI Development in SQL Server
- Preferably in the Financial / Risk Industry

Knowledge:
- Solid knowledge of SDLC, Data Warehouse principles and practises and Kimball Methodology
- Solid technical skills required: T-SQL, SQL, SQL Server BI Stack (SSIS)
- SSAS, SSRS, SSMS experience would be an advantage
- Solid technical skills required: Dimensional Modelling
- MDX and DAX experience would be a huge plus

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

Qualifications/ Certification:
- National Diploma / bachelor’s degree in information technology
- Advantageous:
:: Kimball related courses (dimensional modelling)
:: Certification on Microsoft or other ETL Tools