Skip to Job Description

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

New
Level 1 - Junior Consultancy
Closes 27 Nov 2026 · 8 days CET (UTC+1)
Employers can close earlier.
Duty station conditions
Click any item for more detail.
Apply Now
Posted 2 minutes ago
Job Description

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.

Advertisement

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

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

Advertisement

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.

Advertisement

COMPETENCIES - Core (C) & Managerial (M)

  • Communication (C)
  • Accountability (C)
  • Innovation (C)
  • Knowlegde 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.

Long Description

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.

APPLICATION PROCESS

Interested candidates should complete the online application, then download and complete the Employment History form (Word file). At the end of the Word file, insert extra pages with the following required information:

Part 1: Technical Proposal

  • An up-to-date curriculum vitae;
  • A short statement (max. 2 pages) of understanding of the assignment, indicating how the candidate’s qualifications and experience make them suitable;
  • A brief proposed approach and work plan, including how the candidate would automate template updates, validation and consolidation, and any inputs required from UNESCO;
  • Examples of similar work, including – where available – a link to code samples or a repository (e.g. GitHub) demonstrating data-processing or automation work, and at least two (2) references from comparable assignments

Long Description

Part 2: Financial Proposal

  • An overall lump sum for the assignment, broken down into daily rate × number of working days (up to 90), quoted in a single currency (USD, EUR, CAD or GBP). The daily rate should be within the applicable UNESCO individual consultant rates.
  • No travel is foreseen under this consultancy.

Only complete applications received by the deadline will be considered. Responses to the mandatory pre-screening questions form an integral part of the application; candidates who do not meet the eliminatory criteria will not be considered further. Only shortlisted candidates will be contacted.

Applications will be assessed on a best value for money basis, combining the candidate’s qualifications and technical proposal with the proposed fee.

SELECTION AND RECRUITMENT PROCESS

Please note that all candidates must complete an on-line application and provide complete and accurate information, by the above deadline.

To apply, please visit the UNESCO Careers website. No modifications can be made to the application once submitted.

The process may include pre-recorded video interviews and/or written assessments, interviews with a Panel, as well as reference checks. In addition, candidates may be requested to provide additional information which may be pertinent to the position’s qualifications.

Please note that all candidates, whether selected or not, will be informed of the outcome of their application in due course.

Short-listed candidates may also be added to Talent Pools; subject to their consent (i.e. Data Privacy Statement).

ADDITIONAL INFORMATION

  • UNESCO recalls that paramount consideration in the appointment of personnel shall be the necessity of securing the highest standards of efficiency, technical competence and integrity.
  • UNESCO applies a zero-tolerance policy against all forms of harassment.
  • lndividuals from minority groups and indigenous groups and persons with disabilities are equally encouraged to apply.
  • All applications will be treated with the highest level of confidentiality.
  • UNESCO does not charge a fee at any stage of the hiring process.
{{waiting}}
This position is no longer open.
Before you apply

We review listings for quality, but organizations may update or amend a posting at any time, so confirm the role and closing date on the organization’s official site before applying. No genuine employer charges a fee to apply, interview, or process an application — treat any request for payment as a scam. If a detail looks wrong or the posting seems fraudulent, report this job.

Advertisement