Data Warehouse Manager

Location:	Centurion
Remote work:	Some remote work allowed
Type:	Permanent
Reference:	#NG59229
Company:	E-Merge IT Recruitment

Join a team of dynamic experts at a leading consultancy known for its world-class data analytics and warehouse capabilities, specialising in AI applications.

Our consultancy helps enterprise clients extract business value by implementing AI solutions.

We have a vacancy for a data warehouse manager who will enable future needs for advanced analytics and AI. In this role, you will develop, test, deploy, maintain, and support new databases, reporting systems, data warehouses, and business intelligence applications based on 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. BTech or BS (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.3m to R1.5m cost to company per annum negotiable on experience and ability. Contact Nokuthula at az.oc.egrem-e@galuhtukon or call her on 011 463 3633 to discuss this and other opportunities.

Are you ready for a change of scenery? E-Merge IT recruitment is a specialist niche recruitment agency. We offer our candidates options so that we can successfully place the right developers with the right companies in the right roles. Check out the E-Merge website www.e-merge.co.za for more great positions.

Do you have a friend who is a developer or technology specialist? We pay cash for successful referrals!

Posted on 23 May 12:35, Closing date 22 Jul