To link the ACL Data Analytics tool to financial and operational applications' database within the organisation's subsidiaries and to write custom scripts to extract and analyse data from different systems as requested by management.
1.Key Performance AREA (ACL deployment)
Ensure that ACL is linked to all the financial and operational systems across OPCO's as required. Communicate with System Administrators of financial and operational applications from different OPCOs to link ACL to the operational systems' databases. Ensure that all the tables of linked databases are visible from ACL and the relevant data can be extracted from those table into ACL.Develop custom scripts required to extract data from financial and operations systems databases, perform data analysis and produce exceptions. Follow up ACL exceptions with management and produce a report detailing the findings and management resolution plan.
2.Key Performance AREA (Internal Audit assistance)
Support internal auditors in the planning, execution, and reporting of audit engagements by providing data-driven insights and analysis. Assist in compiling and analysing statistical data for audit planning, Audit fieldwork & Reporting. Perform sustainable analytical tests of controls by obtaining and analysing audit evidence, preparing audit workpapers, evaluating test results, and drawing conclusions on the adequacy and effectiveness of controls. Identify, design, and develop data analytics procedures to support audit activities performed by the Internal Audit team. Collaborate with internal audit team and other stakeholders to understand business requirements and identify areas for improvement.
3.Key Performance AREA (Fraud risk identification)
Establish efficient/automated means to analyse and evaluate large volumes of data for outliers, irregularities, patterns, trends and evaluate the appropriateness and effectiveness of controls Interpret data, identify trends and patterns, and create reports that provide insights to support potential areas of risk or non-compliance. Communicate data-driven insights, findings, and recommendations to management and stakeholders through clear and concise written and verbal reports Develop dashboards and visualizations to communicate findings to stakeholders. Monitor the implementation of corrective actions and track progress in addressing identified weaknesses and deficiencies using data-driven techniques. 4.Key Performance AREA (Ensuring data framework)
Create and sustain an effective system of data analytics and models which provides an enhanced insight into risks and controls. Ensure data accuracy, completeness, and consistency. Maintain documentation on data sources, methodologies, and analytical techniques. Develop and implement data analytics procedures to support continuous monitoring and risk assessment activities. Stay current with industry best practices, regulations, and emerging trends in internal auditing, data analytics, and financial reporting.
5 - Key Performance AREA (Special projects)
Participate in special projects, investigations, and process improvement initiatives as required.Perform ad-hoc tasks assigned by management.Prepare the ad-hoc review reports which includes criteria, detailed findings, root cause, potential consequences, recommendations, and management actions
B Degree or equivalent (and relevant) qualification (with Computer Science / Computer Auditing / Information Systems / Auditing / Data Science as majors: Essential SQL / ACL (or data analytics equivalent) certification: Essential CISA / CIA (one or more of the afore mentioned are advisable): Desirable. 3+ years data analytics experience:Essential 3 years' Experience using CAATS tools such as SQL or ACL:Essential 1 year Project Management and Systems Implementation: Desirable Experience in auditing using CAAT tools especially ACL:Essential Exceptional understanding of services, processes and tools in the telecommunications industry would be advantageous: Essential Exceptional understanding of the Managed Services customer value chain is required: Essential. Good understanding of technology, products and services offered by telecom organisations and the telecommunications industry: Essential. Good understanding of auditing procedures and methodologies: Desirable. All Appointments are subject to the Labour Legislation in the respective country.