View Jobs at African Development Bank Group (AfDB) |
Contract |
Abidjan Cote D'ivoire |
Posted 1 year ago |
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.
HOW TO APPLY
Interested and qualified candidates are required to express their interest by providing information on their qualifications and experience to: [email protected] using “EOI – Senior Business Intelligence Developer – TCIS” as the subject of the mail.
Click here for more information
Click here for the Job Description (PDF)
Deadline: May 5, 2023
Job Features
Job Category | Software/ Programming / Web development |