Data Analyst

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. #J-18808-Ljbffr