Data Analyst

Data Analyst

Cape Town, Northern Suburbs

Permanent

A medium sized financial Services Provider in the long-term insurance sector is rapidly expanding their teams.  With their offices in the Northern Suburbs of Cape Town, the company strives for the inclusion of everyone in their target market.

The company offers affordable insurance products to those who seek superb value & an amazing client experience, their target market is mostly the South African lower and middle income market segments.  Their products include funeral, health, life, credit life and travel financial products.

Job Purpose:

It is the purpose of the data department to enable the company’s strategy to be a data centric business. We provide timeous, accurate and complete data to all stakeholders (regulatory, decisionmakers, actuarial functions, claims and fraud management) for analysis and reporting purposes. The purpose of this role is to drive the department to achieve these goals.

Task and Responsibilities:

Ensure all binder holders provide sufficient data on a monthly basis to allow compliance with regulatory requirements and financial processing – DATA COMPLETENESS

• Monitors data submission channels (company data mail, SFTP) for incoming data from binder holders.
• Follow up with binder holders to ensure data is submitted on a timeous basis.
• Extract member data directly from various administration systems.
• Records extracted and submitted data on binder holder dashboard / tracking report for monitoring.
• Process member data and prepare data for import to the database.

Ensure all binder holders provide sufficient quality data on a monthly basis to allow compliance with regulatory requirements and financial processing – DATA QUALITY

• Reviews member data of binder holders against minimum company requirements and identify shortcomings in binder holder data.
• Reviews member data of binder holders against the applicable master policies and identify areas where policies do not comply with the master policy agreements.
• Reports on the findings of member data reviews, in the shape of a formal data assessment, which will be communicated to the scheme.

Risk Management – The data department is the ideal area to identify risks on client business

• Identify risks in member and claims data.
• Based on the risks identified, assess which is the correct course of action to address risk.
• Log risks and ensure that description and information provided in the risk register is clear and understandable.

Ensure all claims from binder holders, with the claims binder function, are submitted and imported to the claims database on a timeous basis.

• Monitors data submission channels (company data mail, SFTP) for incoming claims data from binder holders.
• Follow up with binder holders to ensure data is submitted on a timeous basis.
• Prepare claims data for import to the claims database.
• Ensure timeous import to claims database (all claims to be imported within 30 days after month end.

Work in conjunction with the call center to ensure data is available on a timeous basis for the launch of each campaign.

• Obtain and prepare the correct data for each call center campaign.
• Analyze the data as part of the preparation to identify anomalies and inaccuracies in the data.
• Import data into call center database in time for the launch of the call center campaign.

Train and onboard clients to the Binder Holder Upload Facility.

• Prepare data and notes for each client according to the client’s unique data structure and challenges.
• Present the system to the client.
• Document the progress of each client through the onboarding process.

Driving change and improvement in binder holder member data.

• The data quality controller should drive improvement in binder holder member data through effective and clear communication.
• Constantly follow up with binder holders where areas of concern have been identified to ensure continuous improvement.

Qualification and Experience

• Diploma in Data analysis/ Information sciences/ IT
• At least Matric
• 2 or more years in data processing / cleaning / analysis
• 2 or more years in Insurance industry (or at least the financial services industry)

Knowledge (what must I know):

• Working knowledge of the regulatory environment which the company operates in.
• Understand the inherent risks of the business and specifically how it can be identified and managed in the data department.
• Understand the need for controls and standard procedures and be able to implement these controls.
• Have the ability to analyze data on a high level to identify anomalies and risks.
• Analyze data on a detailed level in areas where risks have been identified.
• Build and manage client relationships.

Skills and Abilities (what must I be able to do / display)

• Excellent communication skills
• Excellent analytical skills
• Prioritise (and juggle) duties on a daily basis
• Advanced Microsoft Office (especially Excel) skills
• Some SQL knowledge