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

UNESCO · International organisation · Montreal, Canada

  • 1 day ago

UNESCO is hiring for the Consultancy: Data Processing & Template Automation (Python/R) - SDG 4 Education Survey 2027(Remote) position in Montreal, Canada, Canada, in data & analytics. The advert does not state the pay. The advert gives no closing date.

Apply on the employer's website

At a glance

Role
Consultancy: Data Processing & Template Automation (Python/R) - SDG 4 Education Survey 2027(Remote)
Employer
UNESCO
Where
Montreal, Canada, Canada
Field
Data & analytics
Pay
Not stated in the advert
Posted
1 day ago
Closes
No closing date given
How to apply
Directly on the employer's own careers site

The employer's advert

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 2030. 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.

2. 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

3. 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.

Apply on the employer's website

More openings at UNESCO

Similar jobs in Canada

All sections

Edition