1. KEY TASKS AND RESPONSIBILITIES
KEY MEASURABLE GOALS
- Number of data analytics scripts developed and deployed (e.g., SQL, Python, ACL, Power BI, etc.) per quarter.
- Percentage of audits supported by data analytics.
- Timely completion of audit assignments as assigned.
- Accurate and timely preparation of audit reports on assigned audits.
- Understanding of the business, internal controls and business processes per assignment.
- Ability to professionally relate with the auditee during audit engagement and follow up.
KEY RESPONSIBILITIES
- Design, develop, and execute data analytics routines to support audit planning, execution, and continuous monitoring.
- Identify, extract, and integrate data from multiple sources (core systems, ERPs, data warehouses, third-party platforms).
- Write, test, and maintain SQL queries, data mining scripts, and analytics.
- Perform continuous auditing and monitoring analytics
- Conduct internal audits as assigned by the Supervisor.
- Assist in development of audit working papers.
- Planning for assigned audit engagements.
- Preparation of audit reports on the engagements assigned by the supervisor
- Carrying out data analysis as assigned by the supervisor.
- Carrying out adhoc investigations under supervision of supervisor.
- Follow up of issues after audit assignment.
- Conduct audit review on assigned units.
- Any other duties as may be directed by the supervisor.
2. SKILLS, KNOWLEDGE & COMPETENCIES
- Report writing skills
- Broad knowledge of banking operations and systems
- Good working knowledge of MS Office packages, Excel (Power Query, Pivot Tables, advanced formulas).
- Working knowledge of data analysis and visualization tools, e.g., Power BI, Tableau, Qlik, etc. (Required)
- Ability to write data mining and analytics scripts using SQL (Required)
- A good understanding of databases structures, data flows and data models. (Desirable)
- Honesty and high level of integrity
- Attentive to detail
- Ability to travel extensively around different parts of the country
3. QUALIFICATIONS & EXPERIENCE
- Basic Degree in Business, Statistics, related field, Computer Science or IT related degree course
- Data science concepts (Predictive analytics, Machine learning fundamentals (Desirable)
- Plus, CPA2 or ACCA
- CISA/CIA(Desirable)
- At least two (2) years relevant experience (Credit/Operations)
- Banking/Insurance experience (Desirable)
