Data Analyst

Discovery Ltd.; Pretoria; On-site; ZAR 450 000 - 600 000; Full time

Job summary

A leading audit firm in Pretoria seeks an Audit Data Analyst to perform internal audits and data analysis. The ideal candidate should have a B Degree with relevant qualifications, at least 3 years of data analytics experience, and proficiency in SQL and Alteryx. The role requires a proactive approach to auditing with excellent communication skills, commitment to ethics, and the ability to work independently.

Qualifications

• 3+ years data analytics experience.
• Technical knowledge and experience on Windows, Solaris, Linux, Oracle and networks.

Responsibilities

• Perform audits in line with Audit Methodology.
• Prepare Letters of Engagement and Audit Planning Memorandums.
• Communicate findings/control weaknesses identified with business.

Skills

SQL

Data Analysis

PL/SQL programming

Alteryx

Internal Controls

Education

B Degree or equivalent qualification

CISA / CISM / CRISC / CGIT

Tools

SQL

Alteryx

Job description

Business Unit: Discovery Central Services

Function : Data Analysis

Date : 16 Oct

• Discovery- Group Internal Audit
• Audit Data Analyst
• About Discovery
• Discovery's core purpose is to make people healthier and to enhance and protect their lives.

We seek out and invest in exceptional individuals who understand and support our core purpose, and whose own values align with those of Discovery.

Our fast-paced and dynamic environment enables smart, self-driven people to be their best.

As global thought leaders, Discovery is passionate about innovating in order to not only achieve financial success, but to ignite positive and meaningful change within our society.

About Group Internal Audit

Group Internal audit forms part of Group Finance.

Group Internal Audit is responsible for performing internal audit services throughout Discovery.

About the role

The successful candidate will be responsible for completing audits inside Discovery and providing feedback on the outcome.

The successful candidate must have a drive, sense of urgency and work flexibility.

Areas of responsibility

• Perform audits in line with Audit Methodology.
• Assist in defining scope and approach of audits.
• Prepare Letters of Engagement, Audit Planning Memorandums (APM), CAATs Manual and address review notes where applicable.
• Request data from the client, document SQL queries, analyse data and document deficiencies identified after performing the required CAATs testing.
• Build relational data structures, including relationships between tables, grouping data, and following steps to perform analysis.
• Obtain data for internal audit assignments (by means of SQL and any other relevant sources).
• Analysis of data and identifying exceptions and trends by utilising available data analysis software.
• Save all SQL scripts used for any audit assignment.
• Prepare finalised working papers and evidence for all components of work, as per standards set in the Audit Methodology.
• Ensure that working papers are appropriate and include: Objective, Risk, Controls, Tests, Results, Conclusion and supporting documents.
• Communicate findings / control weaknesses identified with business prior to drafting observations.
• Prepare the draft report which includes criteria, detailed findings, root cause, potential consequences, recommendations and management actions.
• Complete action plans on file.
• Provide feedback to Audit Manager / Audit Data Specialist regarding progress on activities.
• Advise Audit Manager / Audit Data Specialist immediately of any problems experienced on audit section.
• Assist management in compiling a continuous auditing audit plan.
• Conduct continuous auditing assignments.
• Assigned work is completed on time and within budget.
• Completion of time-sheets on a weekly basis.
• Request feedback from business management (client satisfaction survey).
• Escalate cases where feedback is not received.

Education and Experience

• B Degree or equivalent (and relevant) qualification (with Computer Science / Computer Auditing / Information Systems / Auditing / Data Science as majors)
• CISA / CISM / CRISC / CGIT (one or more of the afore mentioned are advisable)
• SQL / Alteryx (or data analytics equivalent) certification
• 3+ years data analytics experience
• Internal Controls
• CAATS tools such as SQL, Alteryx
• Extensive PL / SQL programming language
• Technical knowledge and experience on Windows, Solaris, Linux, Oracle and networks

Personal Attributes

• Upholds ethics and values and demonstrates integrity.
• Takes initiative and works under own direction with the ability to make quick, clear choices which may include tough choices or considered risks.
• Shows respect for the views and contributions of others.
• Strong negotiating and influencing skills.
• Excellent communication skills.
• The candidate should speak fluently, have the ability to write in a well-structured and logical manner.
• Demonstrates an understanding of different organisational departments and functions.

EMPLOYMENT EQUITY

The Company's approved Employment Equity Plan and Targets will be considered as part of the recruitment process.

As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.