REQUEST FOR EXPRESSIONS OF INTEREST
AFRICAN DEVELOPMENT BANK
Avenue Joseph Anoma, 01 B.P. 1387, Abidjan, CÔTE d’IVOIRE
Corporate IT Services Department (CHIS)
E-mail : IT_Recruitment@afdb.org
Telephone : (+225) 20 26 22 61/ (+225) 20 26 25 83
The African Development Bank hereby invites Individual Consultants to indicate their interest in the following Assignment : “Two Business Intelligence Analysts”.
The Bank intends to engage the services of two senior consultants to serve as Business Intelligence (BI) Analysts.
The selected Senior Consultants will manage, create, maintain and support all BI life cycle components managed by BI Team including maintenance and development on OBIEE platform, migration of the identified dashboard to SAP BI Platform, and implementation and assistance for Self-BI services on SAP or Power BI.
The consultants will also be involved in the Analysis and Relation with users, and cover all skills ranging from data mining and extraction from different sources (SAP S4Hana, Database format, MS Office format, data warehouse format, etc.), maintenance of corporate data warehouse and DataMart, the development of analytical reports and dashboards and dissemination into a portal for the main used platforms by CHIS BI Team. They should understand the source systems (SAP4HANA, SUMMIT, Oracle Database, SQLServer, MySQL and SharePoint), ETL principles for SAP ETL products, Talend, BI database concepts, reporting tools, BI analysis concepts, dashboards, SAP Fiori Launchpad and other portals.
The consultants’ duties will include the following :
| Task | Description |
| Requirements Analysis | – Assist Business Analyst to collect |
| Requirements | |
| – By domain, provide the list of reports to | |
| update, create, migrate and archive. | |
| ETL development from | – Mapping data sources and targets according |
| S4HANA, internal and external | to the recommended tool (SAP BW4Hanan |
| relational or decisional databases | native ETL, SAP Data services, Talend |
| Data Integration or SSIS) | |
| – Development of the ETL/ELT | |
| Maintenance of the corporate | – Maintain and enhance BW4Hana as a |
| Data Warehouse BW4HANA and | corporate data warehouse and maintain |
| legacy DataMarts | legacy DataMart |
| Development of analytical | – Development mainly under SAP BI |
| reports, dashboards and portals | TOOLS (SAP Webi, Lumira, Analytics for |
| Office) and maintenance of OBIEE reports; | |
| – Enable mobile device support as a key | |
| point of specific solution | |
| Self-BI | – Implementation of Self-BI with SAP |
| Lumira, SAP Webi, Microsoft Power BI or | |
| Tableau Desktop | |
| Validation of Results | – Validate with users that the solution is |
| correct in the target system and the reports | |
| and graphs are in line with user | |
| expectations and specifications | |
| Online user guide and technical | – Create an online user guide for end user if |
| documentation | needed |
| – Provide a technical document analysis of | |
| the solution with the list of objects, the | |
| target data model, data mapping sources | |
| and star model, reports and graph | |
| description | |
| – Provide final report of his mission to be | |
| approved by the CHIS Manager. | |
| Knowledge Sharing | – Work closely with BI Team and provide |
| necessary training or assistance | |
| – Report periodically to the BI Team Leader. | |
Essential skills/Competencies :
- At least Master/Engineering degree in computer science, software development or related business fields and/or equivalent work experience ;
- Minimum of 5 years’ experience as a customer-facing Business Analyst within an IT organization ;
- Strong understanding of BI technologies, trends and tools especially for SAP BW4HANA platform, OBIEE Platform and MSBI platform ;
- Deep Knowledge and skills in data warehousing methodologies, Decision Support and OLAP Technology and Multi-dimensional Data ;
- Knowledge on SAP HANA Data modelling using Attribute, Analytic, Calculation views ;
- Very good knowledge and experiences in the development of SAP Data services, Talend Data Integration Studio or SSIS ;
- Very good knowledge and experiences in the development with SAPBW4HANA, OBIEE or SQLServer ;
- Very good knowledge and experiences in the development with SAP BI-BO Reporting tools (SAP Webi, SAP Lumira designer and Discoverer 2.0, SAP Analysis for Office), with OBIEE Suite (Administration Tool, OBIEE, APEX, VA) and with MS reporting Tool (PowerBI) ;
- Good knowledge on SAP HANA, Oracle, MySQL and SQL Server Databases ;
- Knowledge to develop data flow and workflow in SAP BODS and import files into HANA tables using SAP Data Services, SAP SLT, Smart Data Access (SDA) and SAP Information Steward ;
- Good knowledge of web principle and technology (HTML, CSS, JavaScript) is a plus ;
- Programming experience with ABAP Objects in SAP BW4 and HANA SQL is desirable ;
- Certification on BI skills is a plus ;
- Experience on SAP Fiori is a plus.
The Corporate Information Technology Services Department (CHIS) invites Individual Consultants to indicate their interest in providing the above-described services. Interested Consultants shall provide information on their qualifications and experience demonstrating their ability to undertake this Assignment (CV, reference to similar services, experience in similar assignments, etc.).
The eligibility criteria, the establishment of a short list and the selection procedures shall be in conformity with the Bank’s procedures for the acquisition of consulting services funded by the administrative or capital expenditure. Please, note that interest expressed by a Consultant does not imply any obligation on the part of the Bank to include him/her in the shortlist.
The estimated duration of services is twelve (12) months and the estimated starting date is 02 January 2020.
Interested Individual Consultants may obtain further information at the address below during the Bank’s working hours: from 08:00 to 17:00 hours, Abidjan Local Time.
Expressions of interest must be received by email at the address below no later than Friday, 08 November 2019 at 17:00 hours, Abidjan local time and specifically mentioning “Two Business Intelligence Analysts”.
For the attention of : IT Recruitment Team African Development Bank
Corporate IT Services Department (CHIS) Avenue Joseph Anoma, 01 B.P. 1387, Abidjan, CÔTE d’IVOIRE
Tel: (+225) 20 26 22 61
Email : IT_Recruitment@AFDB.ORG
ESTABLISHMENT OF THE SHORT LIST :
A shortlist of three to six individual consultants will be established at the end the request of expressions of interest. The consultants on the shortlist will be judged on the following criteria on the basis of their updated resume.
| i. | Level of education in general | 20% |
| ii. | Educational level compared to the field of mission | 20% |
| iii. | Years of experience in general | 20% |
| iv. | Number of years of experience relevant to the mission | 40% |

















