Data Administrator

An authorised financial services provider, operating within the Life insurance industry in South Africa, requires the services of a **Data Administrator**.

**Job Summary**:
Join our dynamic data department, where we drive the company's transformation into a data-centric business. We are committed to delivering timely, precise, and comprehensive data to various stakeholders, including regulatory bodies, decision-makers, actuarial teams, and fraud management. As a vital member of our team, your role will be instrumental in helping us achieve our objectives and ensure the seamless flow of data for analysis and reporting purposes.

**Tasks and responsibilities will include, but not be limited to**:

- Data Submission Management
- Monitor data submission channels for incoming data from binder holders, covering both claims and policyholder data.
- Proactively follow up with binder holders to ensure data is submitted on time.
- Extract member data directly from various administration systems.
- Record extracted and submitted data on the binder holder dashboard/tracking report for monitoring purposes.
- Process member data and prepare it for import into the database.
- Policyholder data quality
- Review member data of binder holders against minimum requirements, identifying any shortcomings.
- Assess member data against applicable master policies, highlighting areas of non-compliance.
- Generate formal data assessments to communicate findings to the scheme.
- Claims Data Quality
- Monitor data submission channels for incoming claims data from binder holders.
- Ensure timely submission of claims data.
- Prepare claims data for import into the claims database.
- Driving Change and Improvement in Data
- Collaborate with Data Analysts to drive improvement in binder holder data quality through effective communication.
- Focus on quality improvement across policy and claims data, including regulatory and non-regulatory template data.

**Requirements**:
Qualifications:

- Matric
- Diploma in Data analysis / Information sciences / IT

**Experience**:

- 2 or more years in data processing / cleaning / analysis
- 2 or more years in Insurance industry (or at least the financial services industry)

Knowledge:

- Manipulation and cleaning of data to fit a defined template.
- Recognition of the necessity for implementing controls and standard procedures, coupled with the ability to execute them effectively.
- Advanced analytical skills to discern anomalies and potential risks within datasets at a macro level.
- Capability to conduct in-depth data analysis in areas where risks have been pinpointed.
- Proficiency in cultivating and nurturing client relationships.
- Skilled in developing streamlined processes for data consumption, utilizing tools such as SQL, VBA, and PowerQuery to optimize efficiency and accuracy.

Skills and Abilities
- Meticulously detail-oriented with a keen eye for accuracy.
- Strong communication skills, both verbal and written.
- Proficient analytical capabilities to effectively interpret and derive insights from data.
- Advanced proficiency in Microsoft software, including indispensable skills in Excel, advantageous knowledge in VBA for Excel and with PowerBI.
- Fundamental understanding of SQL for efficient data manipulation and querying.
- Strong time management skills with a focus on delivering results promptly.
- Skilled in prioritizing and managing stakeholder expectations on a daily basis.
- Driven by deadlines, ensuring tasks are completed in a timely manner.

African Unity Life upholds a commitment to employment equity (EE), and appointments will align with the company's EE Plan.

**Job Type**: Temporary
Contract length: 6 months

Application Question(s):

- Do you have advanced proficiency in Microsoft software, including indispensable skills in Excel, advantageous knowledge in VBA for Excel and with PowerBI?
- If the answer to the above question is yes, please specify the amount of years years experience you have
- Provide a summary of your Excel experience
- What is your fundamental understanding of SQL for efficient data manipulation and querying?

**Education**:

- Diploma (required)

**Experience**:

- in data processing / cleaning / analysis: 2 years (required)
- financial services industry: 2 years (required)
- Advance Excel with VBA: 2 years (required)