Data Administrator (1 year contract)
- Cape Town, Western Cape
- Permanent
- Full-time
- 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.
- 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.
- 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.
- 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.
- Matric
- Diploma in Data analysis / Information sciences / IT
- 2 or more years in data processing / cleaning / analysis
- 2 or more years in Insurance industry (or at least the financial services industry)
- 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 Power Query to optimize efficiency and accuracy.
- 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 daily.
- Driven by deadlines, ensuring tasks are completed in a timely manner.
- Meticulously detail-oriented with a keen eye for accuracy.
- Strong communication skills, both verbal and written.