Data Warehousing Specialist

Data Warehouse Specialist with formal tertiary qualification (IT and/or data analytics) and previous experience with MIS databases, reports, dashboards and data warehouses, required to support, enhance and develop such and to enhance BI solutions to management .Minimum requirements:Tertiary qualification IT and Data Analytics essentialMethodologies experience essential elicit data requirements, clear documentation skillsPrinciple experience required design patters, understanding of Metadata construction, EDW, Domain driven design, Data Marts, abstraction techniquesMinimum 3 years data modelling requiredMinimum 3 years Ralph Kimball data warehouse modelling experience requiredImmon data warehouse modelling technique knowledge requiredData normalisation skills (2nd Normal form) essentialData Transportation experience and knowledge ETL systems, solid experience of sourcing, staging and uploading, parallel uploading principles, source to target mappingAdvanced knowledge (minimum 4 years) of T-SQL experience essential Dynamics T-SQL, Multi-threading, Performance optimisation and tuningMinimum 4 years practical experience of MS SSIS ETL software, MS SSAS OLAP software and MS Virtual Studio Data Tools essentialKnowledge of Database Administration advantageousExpert knowledge in configuration of database hardware resourcesRepository type experience source data from different repositories, MS SQL Server repository experience essential, knowledge of Data Lake, Hadoop and Oracle advantageous Responsibilities:Support and enhance existing MIS databases, existing reports and dashboards and existing data warehousesDevelop, test, deploy, maintain and support new databases and reporting, data warehouses and BI applications from requirements and design through to the Software Development Life CycleKeep data analytics and management capabilities up to date
Pretoria, GT, ZA