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