Consultant (6 months, home-based): JSP data visualization, Country Relations, Division of Private Fundraising and Partnerships (PFP) - Tenders Global

Consultant (6 months, home-based): JSP data visualization, Country Relations, Division of Private Fundraising and Partnerships (PFP)

tendersglobal.net

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, hope

The National Committee Relations oversees the Joint Strategic Plans (JSPs) with 33 National Committees. Joint Strategic Plans (JSPs) are jointly developed and mutually agreed between UNICEF and each National Committee. The JSPs set out multi-year objectives, goals and strategies for the National Committee, as well as how UNICEF will support implementation.

The JSP requirements and the JSP process are anchored in the Cooperation Agreement (CA) between UNICEF and each National Committee. The CA designates the JSP as essential and as mandatory to ensure that the operations and activities of the National Committee (and any related entities) are planned collaboratively with UNICEF with agreed UNICEF support, within the parameters of and aligned with the CA, and in alignment with the Private Sector Resource Mobilization Plans 2022-25 and UNICEF policy and priorities, to provide the framework for delivering the best results for children.

How can you make a difference? 

Scope of Work

Development of PowerBI data visualization for National Committee Relations.

The digitalization of the JSPs on the IMPACT Platform has enabled UNICEF and National Committees to access key data sources that provide insights into the joint strategies on income and influence, to achieve overall impact for children worldwide. To best maximize opportunities of engagement with National Committees and private sector partnerships, it is critical that JSPs are accompanied with data visualization tools that facilitate informed and faster decision making by using the right data at the right time. Furthermore, it is critical that National Committees also have access to important information and data from UNICEF systems to facilitate and maximize private sector fundraising and advocacy engagement in high income countries.

This assignment focuses on the development of dashboards, visuals and other tools to consolidate and pull data from UNICEF’s internal JSP strategies, financial systems, and recurring private sector reports. The deliverables of this assignment are expected to improve the capacity of the National Committee Relations’ team to effectively monitor the implementation of the JSP as well as enable National Committees to access data that strengthens their private sector fundraising and advocacy engagement.

Overall Work Assignments Overview

The implementation of this contract will be based on deliverables over a 6 month period. The service provider will work with the Relationship Team in PFP’s National Committee Relations section to design and develop key dashboards. The data visualizations will also be accompanied with the following information:

  • Overall workplan for the development of the different dashboards within an agreed upon timeline
  • Storyboards reflecting the data visualization needs
  • PowerBI templates and components that are adaptable, updatable and reusable
  • Common design/user interface for navigating through the data
  • Training presentation on the dashboard use, data availability and navigation
  • Super-user manual specifying data sources, links etc. in each dashboard to enable UNICEF to maintain the dashboard

The identified data visualization needs are specified in the table below and may be expanded depending on key needs arising from the field detailed here after.

Work Assignments Overview & Deliverables            

31 January 2024

Dashboard Development Workplan, Data Source Matrix and Business Intelligence Case

  • In collaboration with the National Committee Relationship Team, develop a workplan for development of the dashboards as well as matrix of data sources, business intelligence use-case, and story-boarding for each of the dashboards indicated in the list below.        

1 April 2024

Draft Mock-up of Power-BI Dashboards       

  • Develop draft Power BI mock-ups of each of the dashboards listed below (Dashboards 1-4).             

15 May 2024

Final Dashboard 1: National Committee and Private Sector Fundraising Overview Dashboard

  • Dynamic dashboards and templates that provide an overview of National Committee engagement in Private Sector Fundraising and Advocacy. Highlights key contributions of NatComs to UNICEF in resource mobilization and Child Rights advocacy. Provides live update of success stories, funds raised, advocacy information from National Committees.                     

Final Dashboard 2: JSP Monitoring Dashboard

  • Dynamic dashboards and templates that enable UNICEF staff to monitor the implementation of the Joint Strategic Plans (JSP). This will include pulling interactive financial data, consolidating reports that are spread across different dashboards, developing global monitoring view and a view that is specific to each National Committee. This will include interactive maps, charts, graphs, tables, factsheets etc. The dashboard will be linked to both internal UNICEF database as well as external sources. Staff should be able to export dashboards to Excel, PowerPoint presentation format, embed in websites, and use the elements in reporting or presentations.             

Final Dashboard 3: National Committee Grants Management Dashboard

  • Dynamic dashboards and templates that enable National Committee and UNICEF staff to view National Committee supported grants and their relevant details (e.g. donor name, country of programme implementation, total funding, utilization, reporting dates, start and end dates etc.). Built in analytics that enable key decision making from UNICEF staff: For example in built analysis and filters that highlight upcoming expiring grants to enable staff and National Committees to engage in donor negotiations if extensions are required.                

Final Dashboard 4: Country Office Profile and Resource Mobilization Needs Dashboards        

  • Dashboard that reflects an overview of UNICEF country offices (profile) and is able to show key financial gaps in their fundraising needs, demonstrate major donors (both public and private). The aim of this dashboard is to enable UNICEF and National Committees to better understand the resource mobilization needs and gaps in country offices to facilitate targeted fundraising.

Training and documentation on updating developed PowerBI Dashboards         

  • Host a training workshop for relevant colleagues on how to maintain dashboards in the long term.
  • Develop detailed documentation on Power BI data sources, APIs to help maintain data in the long term.      

Additional considerations 

Audience

  • The users of the data primarily intended to be UNICEF PFP and National Committee staff conducting analysis on the status of the JSP, grants management and resource mobilization needs for decision making
  • Key messages will be focused on availability of consolidated data from different sources presented in a structured format for further analysis
  • Users should be able utilize filters to create custom views of the available data 
  • Data layout should be clear, compelling and easy to understand without an advanced knowledge of PowerBi
  • Overview data should also be used to advocate for the role of private sector resource mobilization in UNICEF

Data

  • The majority of data sources will come from UNICEF’s internal data base through the use of APIs that are already built into UNICEF’s system for data extractions.
  • Data from external sources will vary.

Strategic Considerations 

  • The data visualization contractor will work with the unit to develop a brief Business Requirements Document that will highlight the use cases for each of the dashboards as well as the data points that need to be integrated
  • The primary use of the data will be for performance management, however elements of visual storytelling and visual discovery will be welcome

Branding/Design/Look and Feel

  • Dashboards should have a clean, harmonized and intuitive look and feel to enable navigation and visual discovery.
  • Dashboards should also clearly indicate critical data that can drive decision making and monitoring.
  • Visuals should be harmonized with UNICEF brand.

Development & Logistics

  • It is expected that the dashboards (once developed) will be used frequently and routinely by UNICEF during the current year and subsequent years.
  • Data should be auto updated based on the APIs and integration with external data points.
  • In the long term UNICEF should be positioned to manage the maintenance of the dashboards and will require a superuser manual to ensure that support and maintenance can be managed in-house.
  • The Programme Implementation Unit will oversee and approve the dashboards, but will include consultations with target regions and divisions.

Technology

  • The dashboards must be developed in Power BI format.
  • The dashboards should be able to integrate online platforms.

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

Education:

  • An advanced university degree (Master’s or higher) in Statistics, Economics, Mathematics, Data Analysis and Data Visualization or related field is required. Alternatively, a first University Degree (Bachelor’s degree) in a relevant field combined with 2 additional years of professional experience may be accepted in lieu of an Advanced University Degree.

Experience:

  • A minimum of 5 years of relevant professional in designing and customizing data visualizations in Power BI is required.
  • Knowledge and understanding of story-telling using data visualization tools and techniques is required.
  • Knowledge, understanding and experience with UN/ UNICEF’s data architecture and data visualization requirements is required.
  • Extensive knowledge and experience in Business Intelligence (BI) subject areas, products & tools are required.
  • Knowledge of use cases of various business intelligence solutions to facilitate decision making is an asset.
  • Knowledge of integration of multiple data sources, databases, enterprise applications and Web services using Power BI is mandatory.
  • Strong Expertise in data visualization and design using PowerBI platforms to make data clear and understandable for a variety of audiences is required.
  • Strong communication skills with ability to interact and speak with business stakeholders is required

Language:

  • Fluency in English is required. Knowledge of another official UN language (Arabic, Chinese, French, Russian or Spanish) or a local language is an asset.

For every Child, you demonstrate… 

UNICEF’s values of Care, Respect, Integrity, Trust, Accountability, and Sustainability (CRITAS).   

To view our competency framework, please visit  here

Remarks:  

Please indicate in the application your all-inclusive (lump sum) fees in USD against the deliverables listed above, If there is a need for business travel, the travel costs will be covered by UNICEF separately. The office selects the individual based on best value for money.

[1] Costs indicated are estimated. Final rate shall follow the “best value for money” principle, i.e., achieving the desired outcome at the lowest possible fee. Consultants will be asked to stipulate all-inclusive fees, including lump sum travel and subsistence costs, as applicable.

Payment of professional fees will be based on submission of agreed deliverables. UNICEF reserves the right to withhold payment in case the deliverables submitted are not up to the required standard or in case of delays in submitting the deliverables on the part of the consultant.

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. 

The selected candidate is solely responsible to ensure that the visa (applicable) and health insurance required to perform the duties of the contract are valid for the entire period of the contract. Selected candidates are subject to confirmation of fully-vaccinated status against SARS-CoV-2 (Covid-19) with a World Health Organization (WHO)-endorsed vaccine, which must be met prior to taking up the assignment. It does not apply to consultants who will work remotely and are not expected to work on or visit UNICEF premises, programme delivery locations or directly interact with communities UNICEF works with, nor to travel to perform functions for UNICEF for the duration of their consultancy contracts. 

UNICEF is here to serve the world’s most disadvantaged children and our global workforce must reflect the diversity of those children. The UNICEF family is committed to include everyone, irrespective of their race/ethnicity, age, disability, gender identity, sexual orientation, religion, nationality, socio-economic background, or any other personal characteristic.

UNICEF offers reasonable accommodation for consultants/individual contractors with disabilities. This may include, for example, accessible software, travel assistance for missions or personal attendants. We encourage you to disclose your disability during your application in case you need reasonable accommodation during the selection process and afterwards in your assignment. 

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. 

Apply now
To help us track our recruitment effort, please specify on the application form/indicate in your cover letter where (tendersglobal.net) you saw this job posting.

Job Location