Log in
All jobs
U

Consultancy: Data Processing & Template Automation (Python/R) - SDG 4 Education Survey 2027(Remote)

UNESCO
Remote
Remote

About this role

UNESCO Careers

CONSULTANCY: DATA PROCESSING & TEMPLATE AUTOMATION (PYTHON/R) - SDG 4 EDUCATION SURVEY 2027(REMOTE)

JOB DETAILS

Type of contract: Consultant Contract

Level: Level 1 - Junior

Hiring Unit: Institute for Statistics (UIS)

Duty Station: Montreal

Work location: Remote

Duration of contract: 4 months

Hiring open to: External candidates

Application deadline (Midnight UTC−5 Time): 27/11/2026

UNESCO Core Values: Commitment to the Organization, Integrity, Respect for Diversity, Professionalism

OVERVIEW

Do you write code that turns hundreds of spreadsheets into one clean, validated database? The UIS is looking for a data processing specialist to automate and quality-assure the flow of education data from countries into the global SDG 4 database for the 2027 survey cycle.

The UIS is the statistical office of UNESCO and the UN custodian agency for SDG 4 (Quality Education). It develops global indicators and methodological standards, collects and validates education data, and supports Member States in monitoring progress towards

Education

    1. Countries report their data through the UIS Education Survey, using Multi-Year Dynamic Templates (MYDTs) – Excel-based tools with built-in validation checks, indicator calculations and metadata requirements – for SDG 4 and education expenditure.
  • The UIS continuously improves these templates by refining formulas, updating calculations, adding years of data and keeping them aligned with international statistical standards. The consultant will update and test the templates, improve the Python/R/Stata scripts that automate their processing, validate country submissions and produce country indicator review reports for the May 2027 Data Refresh and the November 2027 Data Release.

  • Is this for you? This assignment suits a programmer-statistician who enjoys building reliable, well-documented data pipelines and explaining technical tools to non-specialists. (The UIS is also recruiting a Questionnaire Development and Data Processing Consultant, focused on survey instruments, translations and support to countries. Please apply to the consultancy that best matches your profile.)

  • ASSIGNMENTS

Under the overall authority of the Director of the UIS and the direct supervision of the Senior Project Officer (Administrative Data), the consultant will carry out the following tasks:

    1. Prepare the launch of the 2027 Education Survey (February 2027)
  • Update the MYDT structure: add new years of data entry and update formulas, validation checks and indicator functions.

  • Support the UIS in pre-filling templates after revision and carry out functional testing to make sure the templates run smoothly.

  • Produce French, Spanish, Portuguese and Russian versions of the updated templates.

  • Develop and improve the Python/R/Stata scripts used to update, pre-fill, test and process the templates.

    1. Support data analytics
  • Clean, process and compile datasets for the Montreal team’s analytical work, including contributions to international conferences and statistical forums.

  • Design clear, effective visualizations that communicate complex findings to diverse audiences.

  • Contribute to methodological notes, analytical scripts and technical documentation of data preparation, so that the work is reproducible.

  • Long Description

    1. Process country submissions – May 2027 Data Refresh (survey year 2026) and November 2027 Data Release (survey year 2027)
  • Run data cleaning and consistency checks, including age and age-cohort checks, based on UIS validation rules.

  • Verify that indicator calculations comply with UIS methodology.

  • Produce country indicator review reports from template submissions, in the standard UIS reporting format.

  • Consolidate the databases created from country templates and from mined templates.

  • In virtual meetings with the Regional Field Network (RFN) and the Montreal team, explain template functions, validation rules and indicator calculations, and help countries resolve template completion or technical issues.

  • CONTRACT DURATION

The consultancy is for a maximum of 90 working days, spread over approximately eleven months from January to November 2027. The work is fully remote, with regular online progress meetings with the supervisor. The consultant is expected to work independently with minimal supervision. Indicative allocation of working days:

  • Long Description

  • Stage 1 – 2027 survey launch

  • Timeline: January – February 2027 | Working days: 20

  • Stage 2 – Data analytics support

  • Timeline: February – April 2027 | Working days: 15

  • Stage 3 – May 2027 Data Refresh (survey year 2026)

  • Timeline: February – May 2027 | Working days: 26

  • Stage 4 – November 2027 Data Release (survey year 2027)

  • Timeline: June – November 2027 | Working days: 27

  • Stage 5 – Final deliverables package

  • Timeline: November 2027 | Working days: 2

  • Total: 90 working days

  • DELIVERABLES

  • Stage 1 – 2027 survey launch (by end February 2027)

  • 1.1 Updated MYDTs, including revised formulas and additional years.

  • 1.2 Tested and pre-filled MYDT versions.

  • 1.3 Translated versions in French, Spanish, Russian and Portuguese.

  • 1.4 All related Python/R/Stata scripts.

  • Stage 2 – Data analytics support (by end April 2027)

  • 2.1 Cleaned, processed and compiled datasets for agreed analytical activities.

  • 2.2 Visualizations and contributions to analytical reports, as agreed.

  • 2.3 Analytical scripts, methodological notes and technical documentation of data preparation and analysis.

  • Short Description

  • Stage 3 – May 2027 Data Refresh, survey year 2026 (by end May 2027)

  • 3.1 Validated country MYDT submissions, with completed quality-control checklists.

  • 3.2 Country indicator review outputs, where applicable.

  • 3.3 Consolidated database from country templates.

  • 3.4 Consolidated database from mined templates.

  • 3.5 All related Python/R/Stata scripts.

  • Stage 4 – November 2027 Data Release, survey year 2027 (by November 2027)

  • 4.1 Validated country MYDT submissions, with completed quality-control checklists.

  • 4.2 Country indicator review outputs, where applicable.

  • 4.3 Consolidated database from country templates.

  • 4.4 Consolidated database from mined templates.

  • 4.5 All related Python/R/Stata scripts.

  • Long Description

  • Stage 5 – Final deliverables package (end November 2027)

  • 5.1 All scripts, templates, quality-control logs, documentation and translated files.

  • 5.2 Final completion report summarizing activities undertaken and issues encountered.

  • COMPETENCIES - Core (C) & Managerial (M)

  • Communication (C)

  • Accountability (C)

  • Innovation (C)

  • Knowledge sharing and continuous improvement (C)

  • Planning and organizing (C)

  • Results focus (C)

  • Teamwork (C)

  • For detailed information, please consult the UNESCO Competency Framework.

  • REQUIRED QUALIFICATIONS

  • EDUCATION

  • Advanced university degree (Master’s or equivalent) in statistics, mathematics, computer science, education, economics or a related field.

  • WORK EXPERIENCE

  • A minimum of three (3) years of relevant experience in data processing, data validation or template-automation scripting.

  • Demonstrated experience in data validation, quality control or survey/statistical workflows.

  • Experience with UIS dynamic templates, SDG 4 indicators or UNESCO data workflows is an asset.

  • Experience with databases, Education Management Information Systems (EMIS) or automated data pipelines is an asset.

  • SKILLS AND COMPETENCIES

  • Strong programming skills in Python, R or similar languages (Stata is an asset).

  • Experience processing Excel-based systems programmatically (e.g. reading, validating and consolidating large numbers of workbooks).

  • Ability to write clean, documented and reproducible code that others can maintain.

  • Ability to convert scripts into user-friendly applications (e.g. Shiny, Streamlit or similar) is an asset.

  • Ability to explain technical tools clearly to non-specialists, work independently in a remote setting and meet deadlines.

  • LANGUAGES

  • Excellent proficiency in English (written and spoken) is required.

  • Knowledge of French and/or Spanish is an asset.

Your next opportunity starts here

Prepare, apply, track, interview and get hired — all from one platform, with AI in your corner.

Download app

Or sponsor Premium for someone who's job hunting →