It Audit Junior Umhlanga

*Job Purpose:* * To perform Audit Data Analytics (ADA), following a pre-defined approach, to support the external audit team. * Establish and maintain constructive and professional relationships with the audit team and clients.   *Reports To: *Senior Data Analyst   *GENERAL DUTIES & RESPONSIBILITIES* * Performance of Audit Data Analytics including executing pre-defined ADA / CAATS procedures. * Documentation of evidence following the Firm’s audit methodology and International Standards on Auditing (ISA).     *REQUIREMENTS* * Matric * Accounting / Auditing qualification * Experience in the following areas: * Conducting ADA/CAATs   * Proficient in one or more of the following: * Microsoft Excel (pivot tables / vlookups /conditional functions) * Microsoft Word * CaseWare IDEA and/or ACL * The ability to extract data using ODBC or similar methods * Basic SQL query skills * Understanding of Power Query   *GENERAL KNOWLEDGE, SKILLS & ABILITIES* * Accounting / Auditing qualification * A good understanding of: * IS Audit and Assurance Standards; and * the principles behind the design and use of CAATS during an audit and the related required reporting * SAIPA / SAICA/ ACCA articles experience is advantageous * Studying towards a CISA certification is advantageous * Good verbal communication and reporting skills * Good interpersonal skills * Hands-on approach * Fluent English speaking * Own vehicle with valid driver’s license * Out of the box thinking and problem solving orientated * Providing insightful and clear analysis and conclusions for work performed     *REQUIREMENTS* * Matric * Accounting / Auditing qualification * Experience in the following areas: * Conducting ADA/CAATs   * Proficient in one or more of the following: * Microsoft Excel (pivot tables / vlookups /conditional functions) * Microsoft Word * CaseWare IDEA and/or ACL * The ability to extract data using ODBC or similar methods * Basic SQL query skills * Understanding of Power Query   *GENERAL KNOWLEDGE, SKILLS & ABILITIES* * Accounting / Auditing qualification * A good understanding of: * IS Audit and Assurance Standards; and * the principles behind the design and use of CAATS during an audit and the related required reporting * SAIPA / SAICA/ ACCA articles experience is advantageous * Studying towards a CISA certification is advantageous * Good verbal communication and reporting skills * Good interpersonal skills * Hands-on approach * Fluent English speaking * Own vehicle with valid driver’s license * Out of the box thinking and problem solving orientated * Providing insightful and clear analysis and conclusions for work performed