EOI - Senior Business Intelligence Developer - TCIS at the African Development Bank Group (AfDB)

African Development Bank Group (AfDB) - Established in 1964, the African Development Bank is the premier pan-African development institution, promoting economic growth and social progress across the continent. There are 80 member states, including 54 in Africa (Regional Member Countries). The Bank’s development agenda is delivering the financial and technical support for transformative projects that will significantly reduce poverty through inclusive and sustainable economic growth.

We invite suitably qualified candidates to indicate their interest in joining the Department in the capacity below:

Title: EOI - Senior Business Intelligence Developer - TCIS

Location: Abidjan, Cote d'Ivoire
Department issuing the request: Corporate Information Technology Services (TCIS)
Consultant type: Individual Consultant
Duration: 3 months
Estimated starting date: 1st June 2023

Introduction

• The African Development Bank Group (AfDB) wishes to recruit a Senior Business Intelligence (BI) Consultant with extensive hands-on experience in data integration/processing, warehousing and presentation
• He will be responsible for developing and maintaining business intelligence solutions that support decision-making processes.
• He will work closely with other members of the BI development team to document, design, develop and maintain data models, ETL2 processes, dashboards, and reports.
• He will also collaborate with end-users to gather requirements and provide support as needed.

Scope of Work
Business Requirements Analysis:

• Collaborate with clients to understand their business requirements, data needs, and reporting objectives.
• Translate business requirements into technical specifications, and develop data models, data dictionaries, and data mapping documents to guide the development of data integration and reporting solutions.

Data Integration:

• Design, develop, and implement data integration solutions using mainly Talend Enterprise Data Integration to extract, transform, and load data from Oracle, MySQL, SQL Server, spreadsheets, SAP S4HANA, and other sources.
• Ensure data accuracy, consistency, and integrity through data profiling, cleansing, enrichment, and validation.

Data Processing:

• Utilize Talend, PL/ SQL, DAX 3 and/or Java programming skills to process and manipulate data as needed to support business requirements.
• Perform calculations, aggregations, transformations, and valid ations using appropriate data processing techniques and tools.

Dashboarding and Reporting:

• Develop interactive and visually appealing dashboards using MS Power BI, OBIEE / OAC4, SAP Web Intelligence, and other relevant tools.
• Create visually attractive and user-friendly visualizations to present data insights to clients and facilitate data-driven decision-making.

Data Warehousing:

• Design and implement data warehousing solutions using multidimensional modeling and star schema design principles.
• Develop data models, create and manage data warehouses, and optimize data storage and retrieval performance for efficient data processing and reporting.

Technical Expertise:

• Stay up-to-date with emerging trends and technologies in business intelligence, including Oracle, MySQL, SQL Server, Talend Enterprise Data Integration, MS Power BI, OBIEE, SAP Web Intelligence , PL/SQL, Java, and Oracle Application Express Framework. Provide technical guidance , expertise, and support to clients and team members (juniors) on these technologies.

Project Management:

• Knowledge of end-to-end BI projects, including requirements gathering, solution design, development, testing, and deployment.
• Collaborate with cross-functional teams, including business stakeholders, data engineers, and other IT professionals, to ensure successful project delivery within timelines and budget.

Client Relationship Management:

• Build and maintain strong relationships with clients, understand their business needs, and provide proactive insights and recommendations to support their strategic decision-making processes.
• Deliver high-quality customer service and ensure client satisfaction throughout the project lifecycle.

Others:

• Knowledge of Moody’s RiskConfidence application, Ambit Focus IFRS 9, MODEX Financial Planning Analysis platform, Oracle Discoverer software and the openai models fine tuning will be a plus.

Qualifications and Experience

• Master's Degree in Computer Science, Information Systems or related field.
• Minimum of 5 years of experience in business intelligence, with expertise in Oracle Database, SQL Server, MySQL, Talend Enterprise Data Integration, MS Power Automate, MS Power Query, MS Power BI, OBIEE / OAC, SAP Web Intelligence, PL/SQL, Java, and Oracle Application Express (APEX) Framework.
• Strong knowledge of data integration concepts, ETL processes, data modeling, and data warehousing principles, including multidimensional modeling and star schema design.
• Proficient in creating interactive dashboards and reports using MS Power BI, OBIEE / OAC and SAP Web Intelligence.
• Strong programming skills in PL/SQL, DAX and Java for data processing and
• manipulation.
• Experience Oracle Application Express (APEX) framework.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team.
• Ability to learn and adapt to new technologies quickly.
• Knowledge of programming languages such as JavaScript and Python is a plus.
• Knowledge of the ERP SAP4HANA and SAP Embedded analytics will be highly appreciated.
• Good written and oral skills in French or English with a good working knowledge of the other language.

Deliverables
The Senior BI Consultant will be assigned to specific projects and is expected to deliver the
following:

• A well-documented requirement analysis documentation.
• A well-documented technical documentation translating requirement to technical implementation solution.
• A well-documented deployment and maintenance guide of the developed solution.
• The final package of developed solution (ETL workflow and script, target data mart creation script, reports and code sources).
• Any related project artifacts as required by the projects.

Duration of Assignment:

• The duration of the mission is expected to be 3 months.
• The renewal will be subject to the consultant’s performance and the availability of the budget.

Suppervision of the Mission:

• The consultant will perform the assignment under the supervision of BI Team Lead within Corporate Application Services (TCIS.1) division.
• The assignment can start as soon as possible.

Location:

• The work will be carried out on hybrid mode: remotely and/or at the Bank's headquarters in Abidjan, Cote d’Ivoire.

Remuneration

• The consultant will receive a monthly lump sum rate based on his experience. No additional benefits or per diem will be paid.
• The individual consultant is responsible for his/her own health insurance and own accommodation costs.

Application Closing Date
5th May, 2023 (17h00 Abidjan local time).