Senior Specialist: Data Warehouse & MI Expert at Liberty Group South Africa

Purpose

The purpose of the role is to work collaboratively within your team and across other teams in the business to deliver exceptional customer experiences. The purpose of the role is to work collaboratively within your team and across other teams in the business to deliver exceptional customer experiences.

Key Responsibilities

• Interpreting BI requirements and technical specification documents
• Developing reports using SSIS, SSRS and / or SQL Server
• Developing ETL tools using a variety of methods including SSIS
• Combining all elements of the program design and the testing thereof
• BI Database and application/systems designer/architect
• Designing and developing database models
• Developing Database Views, Functions, User Defined Types and Stored Procedures in line with Business Requirements
• Developing SQL server reporting models
• Developing data warehousing
• Developing complex reporting and data extract requirements
• Designing and developing advanced ETL processes
• Review SQL code and ensure compliance with best practices and ensure optimal performance when released to the production environments
• Data analysis for internal and external users
• Support and maintain existing database and BI systems

Experience

• Experience in a Financial Adviser firm or Investment Platform business.
• Experience in delivering exceptional customer service.
• Experience in solving complex problems for customers (internal or external).
• Experience in building successful relationships and working collaboratively across departmental teams.
• Experience at working in a fast paced, proactive and delivery focused environments.
• A deep understanding of investment and life products (to subject matter expert level) in order to talk about investments confidently.
• An understanding of financial services regulation as it relates to investment platform providers.
• An in depth understanding of providing solutions and experiences which delights financial advisers.
• A clear understanding of how an adviser’s business works.
• A clear understanding of the competitive landscape for our platform.
• A strong understanding of change management processes.
• A broad enterprise-wide view of the end to end business and a relevant degree of appreciation for strategy, processes and capability, enabling technologies and governance.

The successful candidate will demonstrate knowledge of:

• Microsoft SQL Server (T-SQL)
• SQL server Management Studio
• Database Warehouse and Data Optimisation
• SSAS, DTS/ SSIS, SSMS, SSRS,
• Javascript, HTML, CSS
• SQL Server Business Intelligence Development Studio
• Microsoft SQL server Report Builder
• Microsoft SQL Reporting services

Qualifications

• Relevant Commerce degree in Finance, Economics, Statistics, Investment Management or Business Management.
• Higher grade Maths (or equivalent)