Data Warehouse Manager

Experience and Qualifications

Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - Essential

Dimensional modelling and/or relevant Microsoft certification Advantageous

3 5 years of management experience taking care of teams between 5 8 people - Essential

On- the-job training/qualifications:

Microsoft Sql Server

Oracle

Power BI

Advanced MS Excel

Starquest

Some experience in predictive analytic platforms will be advantageous.

These include:

Python

Scala

Spark

AWS Sagemaker

Some experience in Azure / AWS platform services will be advantageous. These include:

Azure SQL elastic instance

Data factory

PowerBI

AWS RDS

Minimum Experience

Methodologies

The candidate must have ability to elicit data requirements from stakeholders

The candidate must have clear documentation skillsPrinciples

The 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 EDW

Knowledge of Domain driven design would be an advantage

The candidate must be familiar with the concept of Data Marts

The candidate must be familiar with abstraction techniquesModelling

The 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 advantage

The candidate must have data normalization skills most especially the 2nd Normal formData Transportation

The candidate must have solid experience of ETL systems

The candidate must have solid experience of sourcing, staging and loading

The candidate must be familiar with parallel loading principles

The candidate must be familiar with source to target mappingDevelopment Software

The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts

Dynamic T-SQL

Multi-threading

Performance optimisation and tuning

The 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 advantage

Expert knowledge in configuration of database hardware resources

Repository type

The candidate must be able to source data from different repositories

The candidate must be fully acquainted with Microsoft SQL Server repository

Knowledge of Data Lake would be an advantage

Knowledge of Oracle would be an advantage

Knowledge of Hadoop is not essential but will also be an advantage