New Consultancy - Business Intelligence Developer, WCARO, Dakar Senegal

Contract

This is a Consultancy contract. More about Consultancy contracts.

TOR ToRs-Business Intelligence Developer-advert.pdf

UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential.

Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone.

And we never give up.

For every child, fair chance

How can you make a difference?

Objectives

The UNICEF Western and Central Africa Regional Office (WCARO) is coordinating a regional resilience programme in Sahel, implemented by UNICEF offices in Mali, Mauritania and Niger, in close collaboration with another UN agency (World Food Programme), over four years (2019-2023). The programme is funded by the German Federal Ministry for Economic Cooperation and Development (BMZ) for an initial budget. The programme will generate numerous quantitative and qualitative data throughout the four year of implementation (21 different studies planned for 2020-2021 only) and it is therefore important to develop high-quality tools to support data visualization.

The primary objective for the assignment is to produce for the account of the UNICEF Western and Central Africa Regional Office (WCARO) an interactive dashboard focused on the various indicators of the Building Resilience in the Sahel Programme, by February 2021.

The specific objectives of the assignment include:

• The analysis of the various data models, sources and the overall modelling of the information architecture as to ensure data quality;
• The definition of the schema of the relational database management systems (DBMSs) including rationalization with regards to the adopted information architecture;
• The development of the database and various automated queries for retrieving, processing and updating the data (CRUD);
• The production of analytics reports template through the reporting tool (Descriptive statistics) for reporting;
• The development through the reporting tool of the various dashboards, reports and apps in Power BI;
• The facilitation of the communication around the dashboard with the development of comprehensive, easy to understand guide;

Training and capacity building intended towards a core team of UNICEF staff (M&E and Programme management profiles) to support the continuous updating and maintenance of tools after the end of this assignment.

Deliverables and Schedules

Interactive management dashboard for data visualization of results, as per agreed upon requirements by the end of the assignment. The product should be accompanied with all the relevant documentation (See reporting requirements).

The payments will be made bimonthly, subject to the submission of:

Deliverable

Amount

Month

Initial assessment report detailing the methodology, work plan, strategy and tools to be used (Month 1);

User Interface Design Drafts, and progress report (Month 2);

40%

October 2020

Progress report (Month 3);

Progress report (Month 4);

First Prototype of Dashboard (Month 4)

35%

December 2021

Progress report (Month 5);

Progress report (Month 6);

Final version of Dashboard along with apps, source code and any other solutions produced during the development of the different products (Month 6);

Training materials - user and admin guide, and training presentations (Month 6);

BI governance plan including RACI matrix, assumptions and dependencies (Month 6).

25%

February 2021

To qualify as an advocate for every child you will have…

• Education:

  • Master’s Degree in computer science, Statistics, Information Technology or related field. A Bachelor degree with 2 years’ experience may be accepted in lieu of a Master.
  • Microsoft Azure Power BI Certification preferred.

  Experience:

  • 5 years of significant software development experience, designing, developing and supporting intuitive reports, dashboards, and graphs using Azure Power BI Service, Power BI Desktop, Azure Analysis Services, DAX Query Language, SSAS, Visual Studio, SSDT and Excel Pivot.
  • Experience gathering requirements, interfacing with stakeholders, and supporting large Business Intelligence / Data Warehouse applications.
  • Experience and thorough understanding of Tabular, Multidimensional, Security Models, Dimensional Structures, Hierarchies, and Big Data / Business Intelligence / Data Warehouse best practices and standards.
  • Experience leading meetings, and the creation of presentations, status reports, specifications document, and technical design documents.
  • Strong analytical skills and experience with the SDLC methodologies such as Waterfall and Agile.
  • Self-motivated, proactive, detail-oriented, and can work independently as well as in a team environment.

  Language:

  Fluent in English and French is required

  ****NB: kindly fill in your profile correctly when applying on the UNICEF website.A misinformed profile will not be considered.****

For every Child, you demonstratef commitment

UNICEF's values of Care, Respect, Integrity, Trust, and Accountability (CRITA) and core competencies in Communication, Working with People and Drive for Results.

The functional competencies required for this post are

View our competency framework at

http://www.unicef.org/about/employ/files/UNICEF_Competencies.pdf

UNICEF is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of the organization.

UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UNICEF, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. UNICEF also adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo rigorous reference and background checks. Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check.

Remarks:

Only shortlisted candidates will be contacted and advance to the next stage of the selection process.

Individuals engaged under a consultancy or individual contract will not be considered “staff members” under the Staff Regulations and Rules of the United Nations and UNICEF’s policies and procedures, and will not be entitled to benefits provided therein (such as leave entitlements and medical insurance coverage). Their conditions of service will be governed by their contract and the General Conditions of Contracts for the Services of Consultants and Individual Contractors. Consultants and individual contractors are responsible for determining their tax liabilities and for the payment of any taxes and/or duties, in accordance with local or other applicable laws.