Consultancy: Data Processing & Template Automation (Python/R)
Organizational Context
The UNESCO Institute for Statistics (UIS) is the UN's custodian agency for SDG 4, focusing on Quality Education. It develops global indicators, sets methodological standards, and collects/validates education data. UIS supports Member States in monitoring progress towards Education 2030 by collecting data through the UIS Education Survey, utilizing Multi-Year Dynamic Templates (MYDTs) for data submission and analysis.
Job Purpose
The UIS seeks a data processing specialist to automate and ensure the quality of education data flow into the global SDG 4 database for the 2027 survey cycle. This role involves refining and testing the Multi-Year Dynamic Templates (MYDTs), which are Excel-based tools used by countries for data submission. The specialist will also enhance the Python/R/Stata scripts that automate the processing of these templates, validate country submissions, and generate country indicator review reports. The ideal candidate is a programmer-statistician adept at building reliable data pipelines and communicating technical information to non-specialists.
Responsibilities
The consultant will update the MYDT structure for the 2027 Education Survey, including adding new data entry years and refining formulas and validation checks. They will also produce multilingual versions of the updated templates and develop/improve scripts for template processing. Responsibilities include cleaning, processing, and compiling datasets for analytical work, and designing effective data visualizations. A key task is processing country submissions for the May 2027 Data Refresh and November 2027 Data Release, which involves running data cleaning and consistency checks, verifying indicator calculations against UIS methodology, and producing country indicator review reports. The consultant will also consolidate databases and explain template functions and validation rules to countries in virtual meetings.
Work Experience
A minimum of three years of relevant experience in data processing, data validation, or template automation scripting is necessary. Demonstrated experience in data validation, quality control, or statistical workflows is essential. Experience with UIS dynamic templates, SDG 4 indicators, or UNESCO data workflows is advantageous.
Skills
Proficiency in programming languages like Python or R is required, with Stata being an asset. Experience in programmatically processing Excel-based systems for validation and consolidation is crucial. The ability to write clean, documented, and reproducible code is essential. Skills in explaining technical tools to non-specialists, working independently remotely, and meeting deadlines are also necessary.