Business Intelligence Specialist (Data Warehouse Developer) with minimum 5 years experience in Microsoft Tools.
12 Month Fixed Term Contract, potential extension to 24 Months. R60k to R80k per month.
Work from home and online with a dynamic team. Stable work environment.
Responsible for developing ETL Solutions and Data Marts from various internal and external and external systems in a Microsoft SQL 2012 and 2016 Data Warehouse environment, to deliver the underbuild to reporting requirements to analysts requiring the data to pull into Cliq, PowerBI and MS SSRS.
- Design develop, test, code promotion, version management, quality control, documentation and analysis
- Working with Reporting specialist to understand data warehouse needs and with delivery team members to maintain, enhance and ensure the integrity of data content and relationships within warehouse
- Proficient in DATA Modelling and Datawarehousing according to best practice such as Ralph Kimball/Inmon Modelling
- Provide architecture and design input and develop ETL solutions form various internal and external systems to support reporting according to businesss needs
- Improve existing data warehouse ETL Designs (CI)
- Background in Dimensional Modelling and engineering with experience in :
- Planning , design and architecting a data warehouse
- Strong Structured query Language (SQL) skills
- Experience on Cliqview not essential, but will help.
- Strong database management systems understanding – Experienced on Microsoft SQL Server 2012 or later versions.
- Analytical and problem solving skills
- Certified (MCSA/MCSE) with at least 5 years experience