Data Analyst at Discovery Limited

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.