Experience and QualificationsRelevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - EssentialDimensional modelling and/or relevant Microsoft certification Advantageous3 5 years of management experience taking care of teams between 5 8 people - EssentialSome experience in predictive analytic platforms will be advantageous. These include:PythonScalaSparkAWS Sagemaker Some experience in Azure / AWS platform services will be advantageous. These include:Azure SQL elastic instanceData factoryPowerBIAWS RDS Minimum ExperienceMethodologiesThe candidate must have ability to elicit data requirements from stakeholdersThe candidate must have clear documentation skillsPrinciplesThe candidate must be familiar with design patterns in data development industry.The candidate must have solid understanding of Metadata constructs.The candidate must have clear understanding of EDWKnowledge of Domain driven design would be an advantageThe candidate must be familiar with the concept of Data MartsThe candidate must be familiar with abstraction techniquesModellingThe candidate must have proven data modelling techniques (3 years)The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years)Knowledge of Immon data warehouse modelling techniques would add an advantageThe candidate must have data normalization skills most especially the 2nd Normal formData TransportationThe candidate must have solid experience of ETL systemsThe candidate must have solid experience of sourcing, staging and loadingThe candidate must be familiar with parallel loading principlesThe candidate must be familiar with source to target mappingDevelopment SoftwareThe candidate must have advanced knowledge of T-SQL (4 years) and the following conceptsDynamic T-SQLMulti-threadingPerformance optimisation and tuningThe candidate must have practical experience of SQL Server Database Engine (4 years)The candidate must have practical experience of MS SSIS ETL software (4 years)The candidate must have practical experience of MS SSAS OLAP software (4 years)The candidate must have practical experience of MS Visual Studio Data Tools (4 years)Knowledge of Database Administration would add an advantageExpert knowledge in configuration of database hardware resourcesRepository typeThe candidate must be able to source data from different repositoriesThe candidate must be fully acquainted with Microsoft SQL Server repositoryKnowledge of Data Lake would be an advantageKnowledge of Oracle would be an advantageKnowledge of Hadoop is not essential but will also be an
