Specialist: Audit Data Analysis at Road Accident Fund

Key Performance Areas 

Collation, Interrogation, Analysis and Compilation of Accurate Statistical Reports

• Interpret data, identify trends and patterns, and create reports that provide insights to support potential areas of risk or non-compliance.
• Develop dashboards and visualizations to communicate findings to stakeholders.
• Develop and implement data analytics procedures to support continuous monitoring and risk assessment activities.
• Communicate data-driven insights, findings, and recommendations to management and stakeholders through clear and concise written and verbal reports.
• Perform analysis on all qualitative and quantitative data.
• Develop various templates and reporting automation processes and prepare reports for systems.
• Provide relevant statistical reports for forecasting purposes.  

Data Integration

• Ensure data accuracy, completeness and consistency.
• Collect, clean, and analyse large data sets from various sources to support internal audit objectives.
• Participate in special projects, investigations, and process improvement initiatives as required.
• Prepare cross systems integration reports from mulitple data sources (integrate various report from all systems reports).
• Maintain a database (department data repository) and perform updates on the data required and report accordingly.

Stakeholder Management

• Collaborate with internal audit team and other stakeholders to understand business requirements and identify areas for improvement.
• Coordinate with stakeholders to determine reporting requirements to confirm data requirements.
• Facilitate and manage communication with relevant internal external stakeholders in relation to proactively and progressively manage the relationships.

Qualifications and Experience

• Bachelor’s Degree/ Advanced Diploma in Data Science/ Information Science/ Informatics/ Statistics/ Computer Science related qualification.
• Certifications in relevant analytics and related tools, e.g., PowerBI, SAP BI, ACL, SQL, Python or VBA will be an added advantage.
• Relevant 5 - 7 years’ experience in data analytics, reporting / analytical reporting or related environment.
• Advanced microsoft excel skills (the use of vlookups, pivot tables, DAX, and VBA).
• Data analytics fieldwork (ACL & SQL) will be highly advantageous.
• Experience working with SAP BI or Microsoft Power BI will be highly advantageous.
• Experience working with VBA and Python programming languages will be highly advantageous.