Portfolio Data Analyst - AHWS.0 at African Development Bank - AfDB

Reference: ADB/18/191
Location: Côte d’Ivoire
Grade: PL6
Position N°: 50062657

The Complex

• The Vice Presidency for ‘Agriculture, Human, and Social Development’ is a Sector Complex focusing on the Bank’s Ten Year Strategy High 5s priority of “Feed Africa” and “Improve Quality of Life for the People of Africa”. The complex objectives are (i) to develop, policy and strategy; (ii) provide deep sector expertise to the Regions by gathering pools of experienced individuals who can be consulted to provide sector expertise on complex transactions; and, (iii) develop new financing instruments. The Vice President will act as the spoke person with external stakeholders on aspects of “Feed Africa” and “Improve Quality of Life for the People of Africa”.

The Hiring Department

• The Water Development and Sanitation Department (AHWS) is responsible for the coordination of the Bank's water development and sanitation-related activities to enhance synergies and contribute to achievement of all High 5s (Power and Light Africa, Feed Africa, Industrialize Africa, Integrate Africa, and Improve the Quality of Life).
• Through its two Divisions: AHWS.l for water coordination and partnerships, and AHWS.2 for water security and sanitation, and the African Water Facility (AWF), the Department supports regional hubs in the development and promotion of new knowledge, approaches and tools for green and inclusive water resources development and management, and for improved sanitation. In so doing, the Department leads the scaling-up of the Bank's contribution to Africa's efforts to attain water security and sanitation for sustainable socio-economic transformation.

The Position

• The Portfolio Data Analyst will assist officials and staff of the Department in: (i) collecting, providing and processing structured data on the water related portfolio in the Department and across other water-user units as necessary; (ii) pooling and organizing information on the work program and its monitoring; (iii) managing data related to the Bank’s water-related operations (completed/under implementation/in the pipeline) and ongoing or new initiatives; and, (iv) contributing to preparation of periodic reports on the sector activities in the Bank.

Duties and responsibilities
Under the supervision of the Director of AHWS, and in close collaboration with the Division Managers and Coordinator of AWF, the Portfolio Data Analyst will be perform the following tasks:

• Collect, provide and process structured data on the Bank’s water sector-related operations (including outputs and outcomes, financing sources and data, etc.) and on the water-related initiatives (AWF, RWSSI, WPP, and any others);
• Design business intelligence tools for the water sector activities in the Bank, and maintain a projects database;
• Prepare monthly, quarterly and ad hoc reports on the Department’s portfolio management and performance;
• Coordinate and liaise with the Task Managers based in the 5 Regional Hubs and constantly keep up-to-date with the latest knowledge and data on water-related operations;
• Coordinate preparation and monitoring of the administrative budget. Participate in identification of resource requirements for submission and administration of the budget; recommend, if necessary, the reallocation of funds; coordinate data on mobilization of bilateral resources;
• Coordinate preparation and monitoring of the annual work program and quarterly mission schedules of the Department. Regularly update work programs on the basis of established processing schedule;
• Coordinate preparation of annual activity reports and portfolio analysis reports;
• Support management to coordinate responses to enquiries concerning the Bank’s activities in the water sector;
• Carry out analytical tasks and support research on a wide range of operational, country and regional water sector related issues;
• Contribute to preparing briefing material on country/sector and project issues;
• Provide technical assistance to staff of the Department in the use of Bank IT systems (SAP-PS; BPPS, SRAS)
• Track the Bank's performance towards supporting Africa to attain water security in line with the draft water policy and the Bank’s Results Measurement Framework;
• Liaise regularly with other key units of the Bank , notably Delivery Performance Management and Results,  Independent Evaluation,  as well as Resource Mobilization and Partnerships; and,
• Support whenever needed the implementation of programs and activities under the water sector portfolio.
• Perform other duties as assigned by the supervisor.

Selection Criteria
Including desirable skills, knowledge and experience:

• Holds at least a Master’s degree or its equivalent in Economics, Business Management, and Information Technology or in a related discipline.
• Have a minimum of four (4) years of relevant professional experience.
• Proven ability to manage and deliver many products and projects within the required time.
• Good working knowledge of operations, particularly the information required for project cycle activities and portfolio management, planning, work programs, budget preparation and financial management of MDBs.
• Demonstrable analytical and report preparation skills.
• Ability to communicate effectively (written and oral) in English or French. A working knowledge of the other will be an asset.
• Competence in the use of standard Microsoft Office applications (Word, Excel, Access, PowerPoint); practical knowledge of SAP - Project Support.