Capacity Development Analyst – Intern at African Guarantee Fund (AGF)

Position Summary

The Capacity Development (CD) Intern’s duties will be to support the Head of Capacity Development and the Capacity Development Officer in the implementation of CD activities and tracking, analysis and reporting of CD and Guarantee data based on periodic Financial Statements and Portfolio Reports of Partner Financial Institutions

Major Responsibilities

Capacity Development/Guarantee Data Analytics and Reporting

These data will include:

• Guarantee: Volume, Pricing, Tenor, Product type, SME’s sector, Utilization ratio, NPL ratio, Claim ratio;
• Capacity Development: CD Activities, CD Partnership Tenor, Analysis of the performance of the CD activity, tracking of CD’s KPIs;
• PFI Guarantee Claims: disaggregated into Guarantee Products, Type of PFI, Region, Country;
• PFI Utilization: disaggregated into Guarantee Products, Type of PFI, Region, Country;
• Guarantee Fees received: disaggregated into Guarantee Products, Type of PFI, Region, Country etc.
• Data Sources will include: Audited and Unaudited Periodic Financial Statements from PFIs, Reports generated by AGF core system, etc.

The CD Intern will:

• Using automated tools to extract data from primary and secondary sources;
• Removing corrupted data and fixing coding errors and related problems;
• Developing and maintaining databases, data systems – reorganizing data in a readable format;
• Performing analysis to assess quality and meaning of data;
• Filter Data by reviewing reports and performance indicators to identify and correct code problems;

Desirable Skills, Knowledge and Experience

• Business Administration Degree
• Strong mathematical skills to help collect, measure, organize and analyze data
• Knowledge of programming languages like VBA, SQL, Oracle, R, MATLAB, and Python
• Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation
• Experience in handling reporting packages like Business Objects, programming (Javascript,
• XML, or ETL frameworks), databases
• Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analyzing
• Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions

Critical Competencies

• Bilingual – fluent in English and working knowledge of French
• Problem-solving skills
• Ability to work in a professional and cultural diverse environment
• Accuracy and attention to detail
• Adept at queries, writing reports, and making presentations
• Team-working skills
• Verbal and Written communication skills
• Proven working experience in data analysis