School Data Consolidation Volunteer

Requirements

• 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.
  
• Languages
  
• English, Level: Fluent, Required
  

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.