Data analyst

We are looking to recruit a Data Analyst to join our Internal Audit department at Clicks Head Office in Cape Town. Reporting to the Internal Audit Data Analytics Manager, you will work within a specialist team that delivers data-driven insights to support internal audits, investigations and continuous auditing across the business.

This is a hands-on role that requires strong analytical, technical and problem-solving skills to transform complex data into reliable audit evidence and actionable insights.

JOB PURPOSE

To deliver accurate, reliable and well-documented data analytics that support risk assessments, control testing, investigations and internal audit activities across financial, IT, forensic, retail and distribution audits.

JOB OBJECTIVES Collaborate with audit teams to identify analytics opportunities, define data requirements, design tests and interpret results. Extract, cleanse, transform and analyse data using SQL and approved analytics tools to support audit testing. Assess data quality and investigate data issues before it is used for audit testing. Design and execute analytics procedures, including reconciliations, trend analysis, exception reporting and full-population testing. Analyse exceptions, identify trends and root causes, and highlight control weaknesses, fraud risks and operational inefficiencies. Prepare dashboards, visualisations and analytical summaries to communicate the nature, scale, trend, risk and potential impact of exceptions to technical and non-technical stakeholders. Develop, test and maintain reusable analytics routines and automated audit tests for approved continuous auditing activities. Maintain scripts, queries, data models and recurring analytics in line with the approved methodology. Support approved investigations by securely acquiring, organising, analysing and presenting relevant data in accordance with agreed objectives, confidentiality requirements and Internal Audit investigation protocols. Perform data analysis for special reviews, operational assessments and management requests. Ensure audit data is handled in accordance with applicable privacy legislation including POPIA and other information security requirements. Prepare clear workpapers and document data lineage, transformations, validations and reconciliation results. EDUCATION Postgraduate in Statistics (preferred), bachelor’s degree(TM1) or equivalent qualification in Information Systems, Computer Science, Data Analytics, Statistics, Applied Mathematics, Finance, Commerce or a related field. Relevant data analytics, Microsoft Power BI, SQL, Python, ACL certification would be advantageous. JOB EXPERIENCE 2–5 years data analytics experience working with financial systems, internal audit, external audit or systems auditing; Big Four experience would be advantageous. Practical experience using data visualisation and reporting tools such as Power BI or Tableau. Experience using Microsoft Office products, particularly advanced Excel. Exposure to an SAP environment, including SAP ECC, SAP S/4 HANA, SAP BI Launchpad or SAP Business Objects, would be advantageous. JOB RELATED KNOWLEDGE & ST ICKES Strong analytical, problem-solving and technical skills. Working knowledge of SQL and experience with Python, ACL, SAS, IDEA or similar analytics tools. Ability to analyse and interpret large, complex datasets from multiple sources. Excellent written and verbal communication skills, with the ability to present technical findings to non-technical stakeholders. Strong attention to detail and organisational skills. A strong appetite for continuous learning and emerging technologies, including AI-assisted analytics and automation. Understanding of Internal Audit methodologies, IIA Standards and Corporate Governance principles. Knowledge of applying Internal Audit and Risk Assessment Methodologies, 2024 Global Internal Audit Standards and Corporate Governance Principles. JOB RELATED COMPETENCIES Deciding and Initiating Action Working with People Applying Expertise and Technology Presenting and Communicating Information Learning and Researching Creating and Innovating Delivering Results & Meeting stakeholder Expectations