Data Analyst at Clicks Group

Introduction

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

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.

Minimum requirements

EDUCATION

• Postgraduate in Statistics (preferred), Bachelor's degree 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/4HANA, SAP BI Launchpad or SAP BusinessObjects, would be advantageous.

JOB RELATED KNOWLEDGE & SKILLS

• 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
• Adapting and Responding to Change