MS BI Developer - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 08-10-2020 8:25:16 AM
03-12-2020 8:25:16 AM
PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS.

DUTIES:
Purely data ETL and provisioning. No analytics, no application development.

REQUIRED SKILLS:

Full Microsoft BI stack: Strong SQL, SSIS, SSAS, SSRS, SSMS
3-4 years relevant experience in a complex environment (banking, retail, etc), with different technologies as input
Past experience must be heavily weighted to MS SQL - large data loads require solid experience in MS SQL to attain acceptable levels of performance in SSAS through proper data engineering
Experience with complex environments and large scale daily ETL is required
Kimball methodology
Using SSIS for job automation
Load from many formats/technologies: Flat files (txt, csv, etc), Legacy DB (Sybase, DB2, etc), Different technologies (Oracle / MS SQL)
Transformation and enrichment in staging with customer and product info
Data provisioning:
Provisioning the data into views, tables (push and pull), SSAS, SSRS (email / SharePoint)
Self-service to end users through OLAP cubes (SSAS)

REQUIRED QUALIFICATIONS / TRAINING:
Relevant data warehouse and BI solution training is essential.
B.Sc. or related degree is advantageous.
5+ years programming experience.