Job Description

Our client is based in Centurion Gauteng, they are currently seeking a Data Warehousing Manager to join their team.Introduction
Through our client-facing brands, wellness and rewards programme, and our other specialist brands, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings, protect what matters to them and invest for the future. We help companies and organisations care for and reward their employees and members. Through our own network of advisers or via independent brokers and utilising new platforms we provide practical financial solutions for people, communities and businesses.Role Purpose
Data Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Oversees data design and the creation of database architecture and data repositories. The Data Warehouse Manager must also establish and lead a world class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI.Maintain and support:
xc2xb7 Existing MIS databases
xc2xb7 Existing reports and dashboards
xc2xb7 Existing data warehousesDevelop, test, deploy, maintain and support new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.Outputs
Internal Process
xc2xb7 Collaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.
xc2xb7 Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
xc2xb7 Conduct research and evaluate potential technical solutions to identified business problems.
xc2xb7 Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
xc2xb7 Design and code new database and analytics functionality using code that is readable, maintainable and re-usable.
xc2xb7 Conduct Unit Testing of own code and resolve all issues/queries timeously.
xc2xb7 Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.
xc2xb7 Deliver solutions into the applicable production environment once testing has been completed.
xc2xb7 Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
xc2xb7 Maintain existing databases and applications according to change requests approved by business as and when needed.
xc2xb7 Diagnose root causes of issues through problem-solving and recommend potential solutions.
xc2xb7 Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
xc2xb7 Log issues found in existing systems as internal change controls and ensure successful resolution of issues.Role-specific Responsibilities and Outputs
xc2xb7 Develop, implement and document Business Intelligence Solutions (Internal Process):
o Contribute to the overall data warehouse architecture and data base designs
o Maintain and oversee the administration and maintenance of the data warehouse
o Develop and maintain Business Intelligence and reporting technologies and processes
o Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications
o Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications
o Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions
o Ensure the continued maintenance and enhancement to existing business intelligence solutions
o Within user specifications extract, transform and load (ELT) data using the relevant tools
o Verify and quality assure of data provided
o Provide support to business intelligence users on data-related issues
xc2xb7 Future development and planning
o Conduct research and undergo training where appropriate, in order to remain abreast of data enablement trends and understand their application in the short-term insurance industry
o Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture and applications in the company short-term insurance business, in alignment with group standards and the South African financial services regulatory framework.Self-management and Teamwork
xc2xb7 Provide authoritative expertise and advice to colleagues
xc2xb7 Develop and maintain productive and collaborative working relationships with peers and team members.
xc2xb7 Deliver on Service Level Agreements made with colleagues
xc2xb7 Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialisation.
xc2xb7 Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
xc2xb7 Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
xc2xb7 Take ownership for driving career development.Finance
xc2xb7 Manage financial and other company resources under your control with due respect.Competencies required
xc2xb7 Business Acumen
xc2xb7 Client / Stakeholder Commitment
xc2xb7 Drive for Results
xc2xb7 Leads Change and Innovation
xc2xb7 Motivating and Inspiring Team
xc2xb7 Collaboration
xc2xb7 Impact and Influence
xc2xb7 Self-Awareness and Insight
xc2xb7 Diversity and Inclusiveness
xc2xb7 Growing TalentSkills
xc2xb7 Communication - articulating information and challenging ideas
xc2xb7 Analysing and interpreting data
xc2xb7 Problem-solving
xc2xb7 Planning and organising - time and task managementExperience and Qualifications
xc2xb7 Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - Essential
xc2xb7 Dimensional modelling and/or relevant Microsoft certification - Advantageous
xc2xb7 3 - 5 years of management experience taking care of teams between 5 - 8 people - EssentialOn- the-job training/qualifications:
xc2xb7 Microsoft Sql Server
xc2xb7 Oracle
xc2xb7 Power BI
xc2xb7 Advanced MS Excel
xc2xb7 StarquestSome experience in predictive analytic platforms will be advantageous.
These include:
xc2xb7 Python
xc2xb7 Scala
xc2xb7 Spark
xc2xb7 AWS SagemakerSome experience in Azure / AWS platform services will be advantageous. These include:
xc2xb7 Azure SQL elastic instance
xc2xb7 Data factory
xc2xb7 PowerBI
xc2xb7 AWS RDSMinimum Experience
Methodologies
xc2xb7 The candidate must have ability to elicit data requirements from stakeholders
xc2xb7 The candidate must have clear documentation skills
Principles
xc2xb7 The candidate must be familiar with design patterns in data development industry.
xc2xb7 The candidate must have solid understanding of Metadata constructs.
xc2xb7 The candidate must have clear understanding of EDW
xc2xb7 Knowledge of Domain driven design would be an advantage
xc2xb7 The candidate must be familiar with the concept of Data Marts
xc2xb7 The candidate must be familiar with abstraction techniques
Modelling
xc2xb7 The candidate must have proven data modelling techniques (3 years)
xc2xb7 The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years)
xc2xb7 Knowledge of Immon data warehouse modelling techniques would add an advantage
xc2xb7 The candidate must have data normalization skills most especially the 2nd Normal form
Data Transportation
xc2xb7 The candidate must have solid experience of ETL systems
xc2xb7 The candidate must have solid experience of sourcing, staging and loading
xc2xb7 The candidate must be familiar with parallel loading principles
xc2xb7 The candidate must be familiar with source to target mapping
Development Software
xc2xb7 The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts
xc2xb7 Dynamic T-SQL
xc2xb7 Multi-threading
xc2xb7 Performance optimisation and tuning
xc2xb7 The candidate must have practical experience of SQL Server Database Engine (4 years)
xc2xb7 The candidate must have practical experience of MS SSIS ETL software (4 years)
xc2xb7 The candidate must have practical experience of MS SSAS OLAP software (4 years)
xc2xb7 The candidate must have practical experience of MS Visual Studio Data Tools (4 years)
xc2xb7 Knowledge of Database Administration would add an advantage
xc2xb7 Expert knowledge in configuration of database hardware resources
Repository type
xc2xb7 The candidate must be able to source data from different repositories
xc2xb7 The candidate must be fully acquainted with Microsoft SQL Server repository
xc2xb7 Knowledge of Data Lake would be an advantage
xc2xb7 Knowledge of Oracle would be an advantage
xc2xb7 Knowledge of Hadoop is not essential but will also be an advantageIf you do not hear from us within 30 days, kindly consider your application as unsuccessful. Twiga may keep your details for future opportunities.

Twiga Consulting