Data Warehouse Manager Centurion - R1.3mil to R1.5mil per annum

Join a team of dynamic experts within a consultancy known for leading a world class data analytics/warehouse capability and specialising in AI and applications and helping enterprise clients to extract business value by implementing AI solutions has a vacancy for a Data Warehouse Manager who will be responsible for enabling future needs for advanced analytics and AI. You will also develop, test, deploy, maintain and support new databases, reporting, data warehouse and business intelligence applications from high-level business requirements and designs.

Responsibilities:

Develop, implement and document Business Intelligence Solutions

Contribute to the overall data warehouse architecture and data base designs

Maintain and oversee the administration and maintenance of the data warehouse

Develop and maintain Business Intelligence and reporting technologies and processes

Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications

Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications

Develop feasible technical specifications and process flows for data provision

Within user specifications extract, transform and load (ELT) data using the relevant tools

Verify and quality assure of data provided

Translate business requirements into workable solutions and document solutions into technical specifications

Qualifications and Experience:

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

Training/qualifications, Microsoft SQL Server, Oracle, Power BI, Advanced MS Excel, Star quest, Python, Scala Spark, AWS Sagemaker

Experience on AWS /Azure SQL elastic instance, Data factory, Power BI

Solid understanding of Metadata constructs

Clear understanding of EDW

Must be familiar with the concept of Data Marts

Proven data modelling techniques (3 years)

Experience in Ralph Kimball data warehouse modelling (3 years)

Advanced knowledge of T-SQL, SSIS, SSAS, Visual Studio

The Reference Number for this position is NG59229 which is a Permanent Hybrid position based in Centurion, Johannesburg offering a salary of R1.3mil to R1.5mil cost to company per annum