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
- Consultancy: Questionnaire Development and Data Processing - SDG 4 Education Survey 2027 (Remote) Montreal, Canada
- Design and Production of GRALE 6 - Call for Proposals Hamburg, Germany
Similar jobs in Canada
- Technicien d’exploitation de centre de données / Data Center Operation Technician, DCEO Varennes, Quebec, CAN
- Business Intelligence Engineer, ASP Ops - WWSO Sales & Biz Ops Toronto, Ontario, CAN
- Technicien de Centre de Données / Data Center Technician, Opérations de centres de données/Data Center Operations Montreal, Quebec, CAN
- Senior Data Scientist, Autonomous Vehicles Toronto, Canada
- Data Governance Lead , Canada Toronto, Canada
- Senior Technical Recruiter, Data Toronto, Canada