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:

Some experience in predictive analytic platforms will be advantageous.
These include:

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

Minimum Experience
Methodologies

Principles

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 techniques

Modelling

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 form

Data Transportation

Development 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