Data Analyst

Clicks Group Limited; Cape Town; On-site; ZAR 450,000 - 660,000; Full time

Job summary

Clicks Group Limited seeks a Data Analyst to join its Internal Audit team at the Cape Town Head Office. You will deliver data analytics to support risk assessments, control testing, investigations and continuous auditing across business units.

The role requires strong analytical and technical skills to transform complex data into reliable audit evidence and actionable insights for technical and non-technical stakeholders, with emphasis on data lineage and documentation.

Qualifications

• Postgraduate in Statistics preferred; degree in related field considered.
• ACL certification would be advantageous for analytics workflows.
• Bachelor's degree in Information Systems or related field is expected or advantageous.

Responsibilities

• Collaborate with audit teams to identify analytics opportunities and define data requirements.
• Extract, cleanse, transform and analyse data using SQL and approved analytics tools for audit testing.
• Assess data quality and investigate data issues before use in audit testing.
• Design and execute analytics procedures including reconciliations, trend analysis and exhaustive population testing.
• Analyse exceptions, identify trends and root causes, and highlight control weaknesses and risks.
• Prepare dashboards, visualisations and analytical summaries for stakeholders.

Skills

Analytical thinking

Problem solving

Data interpretation

Communication skills

Attention to detail

Learning mindset

Auditing knowledge

Education

Postgraduate in Statistics

Bachelor's degree in Information Systems

ACL certification advantageous

Tools

Power BI

Tableau

SQL

Python

Excel

ACL

SAS

IDEA

SAP

Job description

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