Senior Data Analytics Specialist in Short Term Insurance Industry

SUMMARY:
Senior Data Analytics Specialist

POSITION INFO:

Centurion

Role Purpose
Maintain and support:
• Existing MIS databases
• Existing reports and dashboards
• Existing data warehouses
Develop, 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.
Responsibilities and work outputs INTERNAL PROCESS
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.
Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
Conduct research and evaluate potential technical solutions to identified business problems.
Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
Design and code new database and analytics functionality using code that is readable, maintainable and re-usable.
Conduct Unit Testing of own code and resolve all issues/queries timeously.
Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.

ROLE-SPECIFIC RESPONSIBILITIES AND OUTPUTS
• 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
• 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 short-term insurance business, in alignment with 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 for driving career development.
FINANCE
Manage financial and other company resources under your control with due respect.

Experience and Qualifications
• Relevant IT and data analytics qualifications, e.g. B.Tech or B.Sc. (Informatics)
• Dimensional modelling and/or relevant Microsoft certification

Minimum Experience

Short Term Insurance industry
The candidate must have proven data modelling techniques (3 years)
The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years)
The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts:
*Dynamic T-SQL
*Multi-threading
* Performance optimisation and tuning
The candidate must have practical experience of SQL Server Database Engine (4 years)
The candidate must have practical experience of MS SSIS ETL software (4 years)
The candidate must have practical experience of MS SSAS OLAP software (4 years)
The candidate must have practical experience of MS Visual Studio Data Tools (4 years)

NB! This job is now closed. You can apply for other jobs by uploading your CV.