School data consolidation

Support the consolidation and validation of school data for UNICEF Uganda.

This opening expired 9 months ago. Do not try to apply for this job.

UNICEF - United Nations Children's Fund

Open positions at UNICEF

Home-based;

Volunteering

Show advice for this position

Application deadline 9 months ago: Friday 23 Jan 2026 at 00:00 UTC

Open application form

Overview

Support the consolidation and validation of school data for UNICEF Uganda.

You have:

University degree in Data Science, ICT, Education Planning, or related field.
Proven experience in data management, cleaning, validation, and visualization.
Proficiency in Power BI, Excel, GIS tools, and database management.
Familiarity with Uganda’s education system and EMIS is an asset.
Knowledge of data privacy and cybersecurity principles.
Strong analytical, problem-solving, and communication skills.
Ability to work independently and collaborate virtually across diverse teams.

Contract

This is a UNV contract. More about UNV contracts.

Your experience matters—tell us how we can make UNtalent.org better.

UNTalent Community

Details

Currently, UNICEF Uganda runs several initiatives—Girls for Digital Uganda (G4DU), Leaders in Teaching, Airtel Partnership, and Giga—each requiring reliable school data for targeting and implementation. However, multiple fragmented and inconsistent school lists exist across projects, government systems, and partner databases. These discrepancies lead to inefficiencies, duplication of efforts, and challenges in reporting. A consolidated, validated master list of schools will enable UNICEF and partners to:

Identify priority schools for connectivity and digital learning.
Align interventions with Ministry of Education and Sports (MoES) EMIS standards.
Improve programme planning, monitoring, and reporting.
Support evidence-based decision-making for resource allocation.

This assignment will leverage digital tools and virtual collaboration to harmonize school data, ensuring accuracy, completeness, and usability across all UNICEF education programmes.

Objectives

Data consolidation: Collect and review existing school datasets from UNICEF projects, MoES EMIS, and partner sources.
Data quality improvement: Identify and resolve gaps, inconsistencies, and duplicates to ensure accuracy.
Standardization: Design a harmonized data structure with agreed attributes (e.g., EMIS code, GPS coordinates, enrollment, connectivity status).
Visualization: Develop interactive Power BI dashboards to support programme planning and decision-making.
Sustainability: Recommend mechanisms for regular updates and integration with UNICEF systems and national platforms.

The purpose of this assignment is to develop a comprehensive, accurate, and validated master list of all schools in Uganda, integrating data from multiple sources and aligning with national standards. The Online UN Volunteer will also create dynamic dashboards to visualize school data, enabling UNICEF teams to answer critical questions related to school information. This work will strengthen UNICEF’s ability to deliver impactful education programmes and foster collaboration with Government and private sector partners.

Online Volunteers are expected to;

• Data mapping and inventory: Compile all existing school lists from UNICEF initiatives, MoES EMIS, and partner databases. Document sources and data attributes. • Stakeholder engagement (Virtual): Coordinate with UNICEF sections via Teams and email to confirm data standards and validation protocols. • Data cleaning and validation: Remove duplicates, correct errors, and verify data against official sources using remote methods. Apply quality checks for completeness and consistency. • Master list development: Create a consolidated dataset in an agreed format (Excel/Database) with metadata for traceability. • Dynamic visualization: Build Power BI dashboards to visualize key information such as location, connectivity, enrollment, geographic distribution, etc. Ensure dashboards are user-friendly and accessible to programme teams. • Documentation and Reporting: Prepare a comprehensive report detailing methodology, findings, challenges, and recommendations for sustainability. Include guidelines for future updates and integration with UNICEF systems.

The expected deliverable is consolidated school data which includes:

Draft consolidated dataset: Preliminary version for review by end of week 4.
Final Validated Master List: Complete dataset with agreed attributes and metadata.
Power BI Dashboard: Interactive visualization tool for UNICEF programme teams.
Technical Report: Detailed documentation of processes, findings, and sustainability recommendations.
Update Mechanism Proposal: Clear steps for maintaining and updating the master list beyond the assignment period.

University degree in Data Science, ICT, Education Planning, or related field.
Proven experience in data management, cleaning, validation, and visualization.
Proficiency in Power BI, Excel, GIS tools, and database management.
Familiarity with Uganda’s education system and EMIS is an asset.
Knowledge of data privacy and cybersecurity principles.
Strong analytical, problem-solving, and communication skills.
Ability to work independently and collaborate virtually across diverse teams.

Apply now

Potential interview questions

Describe a time you consolidated data from multiple sources. What approach did you take?	The interviewer wants to understand your experience with data consolidation.	Provide specific details on the methods and tools you used during the process.
How do you ensure data quality when dealing with large datasets?	This question assesses your data management skills.	Pro members can see the explanation.
Can you share an experience where you developed a data visualization? What challenges did you face?	Pro members can see the explanation.	Pro members can see the explanation.
What strategies do you use to engage stakeholders when working on data initiatives?	Pro members can see the explanation.	Pro members can see the explanation.
How do you prioritize tasks when working on a project with tight deadlines?	Pro members can see the explanation.	Pro members can see the explanation.
What experience do you have with Power BI, and how have you utilized it in your previous roles?	Pro members can see the explanation.	Pro members can see the explanation.
Discuss a challenge you faced while cleaning or validating data and how you overcame it.	Pro members can see the explanation.	Pro members can see the explanation.
Explain your understanding of the EMIS standards and how they relate to education data management.	Pro members can see the explanation.	Pro members can see the explanation.