Data Warehouse Manager - JHB

Experienced Data Warehouse Manager Urgently Needed

POSITION INFO :

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

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 skills

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

• 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 mapping

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

• 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