Data Analyst

Discovery; Pretoria; On-site; ZAR 400 000 - 600 000; Full time

Job summary

A leading health-focused organization in Pretoria is seeking an Audit Data Analyst to perform audits and analyze data. The ideal candidate will have at least 3 years of experience in data analytics, proficiency in SQL and Alteryx, and excellent communication skills. The role involves preparing reports and ensuring audits are comprehensive and standards-compliant. This position emphasizes integrity and strong analytical capabilities.

Qualifications

• 3+ years of data analytics experience required.
• Experience in using CAATS tools such as SQL and Alteryx.
• Strong technical knowledge in Windows, Solaris, Linux, Oracle, and networks.

Responsibilities

• Perform audits in line with Audit Methodology.
• Assist in defining scope and approach of audits.
• Communicate findings and prepare draft reports.

Skills

Data analytics

SQL

Analytical skills

Communication skills

Education

B Degree or equivalent in Computer Science / Computer Auditing / Information Systems / Auditing / Data Science

CISA / CISM / CRISC / CGIT certification

SQL / Alteryx certification

Tools

SQL

Alteryx

PL/SQL

Job description

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 may include but not limited to

• 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.