Senior Auditor: Data Analytics
Job Purpose
To execute the internal audit methodology and a risk based audit approach when performing start to end internal audit duties across all internal, partner, broker, administrator, binder and underwriting relationships and functions both nationally and internationally with a high focus on data analytics.
Key Objectives
BUSINESS DEVELOPMENT
- Build rapport with process owners and stakeholders.
- Build mutually beneficial relationships with stakeholders.
- Apply your mind to continuous improvement possibilities.
- Establishes a clear set of standards for others to work within and provide the necessary guidance.
- Practice effective communication skills.
FINANCIAL
- Manage time in line with the allocated budget and communicate any potential delays or overruns.
- Identify and communicate overruns and inefficiencies.
- Capture timesheets.
- Monitor and collate timesheets to verify accuracy compared to work performed.
- Identify, monitor and communicate overruns and inefficiencies.
PROCESS
- Conduct audits in accordance with approved Internal Audit methodology.
- Manage client interaction for allocated areas of scope Attend audit team kick-off and close-out meetings.
- Attend audit team kick-off and close-out meetings.
- Prepare process analysis documentation (medium complexity processes).
- Prepare the data analytics audit program that is aligned to the Risk and Control Matrix (RCM) of the audit (high complexity processes).
- Conduct data analytics fieldwork using relevant tools including ACL and SQL.
- Develop data analytics scripts for continuous monitoring purposes.
- Draft business understanding documents and related flow charts of allocated scope area for manager review.
- Conduct fieldwork and testing to the required standard.
- Develop and utilise a sound understanding of business processes, risks and controls including relevant regulatory and accounting issues.
- Identification of process, information and control gaps and seek additional information if necessary.
- Ensure that information generated is accurate, valid and comprehensive prior to review and/or reporting.
- Documenting findings and discussion with client in terms of factual correctness - asks for support where necessary.
- Draft and discuss own findings for inclusion in audit reports.
- Take responsibility to clear and finalise all own reported findings/reporting points.
- Review own working papers for quality and completeness before sending to Senior Auditor for review.
- Ensure all review queries are cleared within reasonable timeframe (expectation 48 hours).
- Focus on problem solving/high risk areas during the audit.
- Communicate any delays or difficulties experienced for corrective action.
- Track audit process status for allocated section and effectively communicate any anticipated challenges, delays, etc.
- Communicates knowledge gained throughout the audit engagement and/or otherwise with the team members.
- Follow-up and update internal audit findings tracking document.
HUMAN RESOURCES
- Attend scheduled training.
- Take responsibility for own career and performance management.
- Contribute to training ideas and/or potential training deficiencies.
- Contribute to the social committee and attend social activities.
- Participate in the on boarding of new team members (specialist level)
Required Qualifications
- BCom/BSc IT degree (Hons degree preferred)
- Data or IT Audit related certifications (would be an advantage)
Required Experience (relevant or in a similar role)
3-5 years related audit experience, of which a minimum of 3 years in data analytics
Required Knowledge and Skills
Knowledge
- Risk based auditing methodology
- Corporate governance (e.g. King III; Companies Act; etc.)
- IIA standards
- General business and financial understanding
- Insurance knowledge - understand processes, risks and controls (an advantage)
- Understanding of IT, data and privacy related legislation and regulation
Skills
- Stakeholder management
- Conflict management
- Resourcing
- Effective written and verbal communication skills (business acumen)
- Risk management
- Process optimisation and workflow analysis
- Report writing
- Audit Planning
- Project management
- Deductive reasoning
- Documentation skills
- Time management
- Root cause analysis
- Basic programming and ability to interpret source code
- Technical audit: audit standards, methodology and risk based approach
Competencies
Core Competencies:
- Resilience
- Drive and autonomy
- Collaboration and knowledge transfer
- Analytical thinking and problem solving
- Numerical and quantitative
- Implementing and executing (completing)
- Continuous self-improvement and learning
- Agility and multi-tasking
Technical Competencies:
- Excel (Advanced)
- Ability to perform analytics using tools such as IDEA and ACL (Advanced)
- Ability to script using analytical tools such as IDEA, ACL, etc. (Intermediate)
- SQL queries (intermediate)
- Continuous Monitoring
- Database structures (intermediate)
- BI architecture, data models and data flows (intermediate)
- Robotics (an advantage)
To execute the internal audit methodology and a risk based audit approach when performing start to end internal audit duties across all internal, partner, broker, administrator, binder and underwriting relationships and functions both nationally and internationally with a high focus on data analytics.
Key Objectives
BUSINESS DEVELOPMENT
- Build rapport with process owners and stakeholders.
- Build mutually beneficial relationships with stakeholders.
- Apply your mind to continuous improvement possibilities.
- Establishes a clear set of standards for others to work within and provide the necessary guidance.
- Practice effective communication skills.
FINANCIAL
- Manage time in line with the allocated budget and communicate any potential delays or overruns.
- Identify and communicate overruns and inefficiencies.
- Capture timesheets.
- Monitor and collate timesheets to verify accuracy compared to work performed.
- Identify, monitor and communicate overruns and inefficiencies.
PROCESS
- Conduct audits in accordance with approved Internal Audit methodology.
- Manage client interaction for allocated areas of scope Attend audit team kick-off and close-out meetings.
- Attend audit team kick-off and close-out meetings.
- Prepare process analysis documentation (medium complexity processes).
- Prepare the data analytics audit program that is aligned to the Risk and Control Matrix (RCM) of the audit (high complexity processes).
- Conduct data analytics fieldwork using relevant tools including ACL and SQL.
- Develop data analytics scripts for continuous monitoring purposes.
- Draft business understanding documents and related flow charts of allocated scope area for manager review.
- Conduct fieldwork and testing to the required standard.
- Develop and utilise a sound understanding of business processes, risks and controls including relevant regulatory and accounting issues.
- Identification of process, information and control gaps and seek additional information if necessary.
- Ensure that information generated is accurate, valid and comprehensive prior to review and/or reporting.
- Documenting findings and discussion with client in terms of factual correctness - asks for support where necessary.
- Draft and discuss own findings for inclusion in audit reports.
- Take responsibility to clear and finalise all own reported findings/reporting points.
- Review own working papers for quality and completeness before sending to Senior Auditor for review.
- Ensure all review queries are cleared within reasonable timeframe (expectation 48 hours).
- Focus on problem solving/high risk areas during the audit.
- Communicate any delays or difficulties experienced for corrective action.
- Track audit process status for allocated section and effectively communicate any anticipated challenges, delays, etc.
- Communicates knowledge gained throughout the audit engagement and/or otherwise with the team members.
- Follow-up and update internal audit findings tracking document.
HUMAN RESOURCES
- Attend scheduled training.
- Take responsibility for own career and performance management.
- Contribute to training ideas and/or potential training deficiencies.
- Contribute to the social committee and attend social activities.
- Participate in the on boarding of new team members (specialist level)
Required Qualifications
- BCom/BSc IT degree (Hons degree preferred)
- Data or IT Audit related certifications (would be an advantage)
Required Experience (relevant or in a similar role)
3-5 years related audit experience, of which a minimum of 3 years in data analytics
Required Knowledge and Skills
Knowledge
- Risk based auditing methodology
- Corporate governance (e.g. King III; Companies Act; etc.)
- IIA standards
- General business and financial understanding
- Insurance knowledge - understand processes, risks and controls (an advantage)
- Understanding of IT, data and privacy related legislation and regulation
Skills
- Stakeholder management
- Conflict management
- Resourcing
- Effective written and verbal communication skills (business acumen)
- Risk management
- Process optimisation and workflow analysis
- Report writing
- Audit Planning
- Project management
- Deductive reasoning
- Documentation skills
- Time management
- Root cause analysis
- Basic programming and ability to interpret source code
- Technical audit: audit standards, methodology and risk based approach
Competencies
Core Competencies:
- Resilience
- Drive and autonomy
- Collaboration and knowledge transfer
- Analytical thinking and problem solving
- Numerical and quantitative
- Implementing and executing (completing)
- Continuous self-improvement and learning
- Agility and multi-tasking
Technical Competencies:
- Excel (Advanced)
- Ability to perform analytics using tools such as IDEA and ACL (Advanced)
- Ability to script using analytical tools such as IDEA, ACL, etc. (Intermediate)
- SQL queries (intermediate)
- Continuous Monitoring
- Database structures (intermediate)
- BI architecture, data models and data flows (intermediate)
- Robotics (an advantage)