Consultant (6 months, home-based): JSP data visualization, Country Relations, Division of Private Fundraising and Partnerships (PFP)
- Country: Switzerland
- Organization: UNICEF
- Deadline: 2023-11-18
- No of Vacancies: N/A
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.
- 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
- 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.
- 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.
- 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…
- 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.
- 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
- Fluency in English is required. Knowledge of another official UN language (Arabic, Chinese, French, Russian or Spanish) or a local language is an asset.
If you are looking for more UN jobs in Switzerland, please click here: UN jobs in Switzerland