Data Warehouse Manager

Our client in the financial services space seeks a Data Warehouse Manager to join their team. The role is hybrid (3 days in office).

Role Purpose

As the Data Warehouse Manager, you will manage the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. You will oversee 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 our client in the insurance sector, to enable future needs for advanced analytics and AI.

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 to 8 people - Essential
• Some experience in predictive analytic platforms will be advantageous.
• Advantageous to have experience in:
• Python | Scala | Spark | AWS Sagemaker
• Azure / AWS platform services
• Azure SQL elastic instance | Data factory | PowerBI | AWS RDS
• Modelling experience:
• Proven data modelling techniques (3 years)
• Ralph Kimball data warehouse modelling (3 years)
• Development software:
• Advanced knowledge of T-SQL (4 years), including the following concepts:
• Dynamic T-SQL
• Multi-threading
• Performance optimisation and tuning
• Practical experience of SQL Server Database Engine (4 years)
• Practical experience of MS SSIS ETL software (4 years)
• Practical experience with MS SSAS OLAP software (4 years)
• Practical experience of MS Visual Studio Data Tools (4 years)
• Knowledge of Database Administration would add an advantage
• Expert knowledge in the configuration of database hardware resources

Role-specific Responsibilities and Outputs

• Develop, implement and document Business Intelligence Solutions (Internal Process).
• Contribute to the overall data warehouse architecture and database 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 activities in support of the development of business intelligence solutions.
• Ensure the continued maintenance and enhancement of existing business intelligence solutions.
• Within user specifications, extract, transform and load (ELT) data using the relevant tools.
• Verify and quality assure the data provided.
• Provide support to business intelligence users on data-related issues.

Future Development and Planning

• Conduct research and undergo training where appropriate, to remain abreast of data enablement trends and understand their application in the short-term insurance industry.
• Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture and applications in the Client's short-term insurance business, in alignment with their group standards and the South African financial services regulatory framework.

Self-management and Teamwork

• Provide authoritative expertise and advice to colleagues.
• Develop and maintain productive and collaborative working relationships with peers and team members.
• Deliver on Service Level Agreements made with colleagues.
• Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialisation.
• Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
• Take ownership of driving career development.

Finance

Manage financial and other company resources under your control with due respect.