Administrative Data Analyst; DAPM; Data and Analytics Education Section NYHQ, remote. Req#581696

Consultancy Title: Administrative Data Analyst

Division/Duty Station: Division of Analysis, Planning & Monitoring, DAPM; Data and Analytics Education  

Duration: 30 June 2025 – 31 July 2026

Home/ Office Based: Remote

About UNICEF

If you are a committed, creative professional and are passionate about making a lasting difference for children, the world's leading children's rights organization would like to hear from you. For 70 years, UNICEF has been working on the ground in 190 countries and territories to promote children's survival, protection and development. The world's largest provider of vaccines for developing countries, UNICEF supports child health and nutrition, good water and sanitation, quality basic education for all boys and girls, and the protection of children from violence, exploitation, and AIDS. UNICEF is funded entirely by the voluntary contributions of individuals, businesses, foundations and governments. UNICEF has over 12,000 staff in more than 145 countries.

 

BACKGROUND

Purpose of Activity/ Assignment: 

The overarching aim of this consultancy is to support the preparation and analysis of education administrative data, with a particular focus on linking administrative sources to household survey data for deeper insight into education system performance. The consultant will work closely with the Technical Working Group and country teams to acquire and clean administrative datasets, build workflows to standardize and integrate EMIS data, and develop reproducible scripts using R.

As part of this assignment, the consultant will support the creation of a linked database across six countries, enabling joint analysis of administrative and household survey data. This will involve producing country-specific factsheets, exploring econometric approaches to respond to national policy questions, and contributing to the validation and finalization of outputs. All scripts and documentation will be maintained on GitHub to ensure transparency and facilitate future updates by teams and country partners.

Scope of Work:

The Consultant will perform the following tasks:

1. Working with countries to acquire, clean and prepare education administrative sources for analysis
• Work with Technical Working Group to acquire administrative data
• Design and Documentation:
  • Work with colleagues to build on the update data prep script to clean data (merging data, resolving merge issues, cleaning category variables, calculating aggregations
• Workflow Development:
  • Create a workflow to clean and prepare EMIS data, link EMIS data to household survey data
  • Validate the generated output and iterate based on feedback
• Reproducibility:
  • Ensure that the code is well-annotated and published on a GitHub repository for future reproducibility and scalability
2. Produce analysis using administrative and household data (6 countries):
• Analyse and explore econometric methods to analyse the linked data to respond to country needs
•  analysis using R and produce a country factsheet with findings
• Validate the estimates
• Finalization:
  • Publish the updated workflow on GitHub with comprehensive documentation and a user guide for future maintenance and updates
• Support publication of factsheet
• Work with country offices and ministry of education to finalize and publish the analysis

Terms of Reference / Key Deliverables:

Work Assignment Overview/Deliverables and Outputs/Delivery deadline

 1.  Workplan and proposal

-  Development of Workplan and proposal

20 July 2025

2.  Work with Technical Working Group to acquire and prepare administrative education data

- For 3 countries, processed (cleaned, merged, generated new variables, and prepared for analysis) EMIS data from national administrative sources. This includes relevant variables from EMIS and other sources, with cleaned datasets, binary/categorical variables, and reproducible R scripts for analysis

30 August 2025

30 September 2025

31 October 2025

3.  Develop and document workflow to clean EMIS data and link it to household survey data

-  Three Merged EMIS and household survey data, with a reproducible, well-documented R script for cleaning and merging, posted on GitHub with an example dataset or usage instructions

30 November 2025

4.  Produce analysis and factsheets using administrative and household data (3 countries)

-  Three Country-level  analytical products  , with reproducible R codes for analysis, analytical outputs, sum