Data Processing and Template Automation Consultant

OVERVIEW

Parent Sector : UNESCO Institute for Statistics (UIS)

Duty Station : Montreal

Classification of duty station : filter12

Standard Duration of Assignement : filter13

Job Family : Education

Type of contract : Non Staff

Duration of contract : 1 year

Recruitment open to : External candidates

Application Deadline (Midnight Paris Time) : 22 / 12 / 2025

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

OVERVIEW OF THE FUNCTIONS OF THE POST

Background

The UNESCO Institute for Statistics (UIS) works to ensure the collection quality and consistency of global education data particularly for monitoring SDG 4 - Quality Education. To support countries in submitting standardized accurate and comparable data the UIS uses Multi-Year Dynamic Templates (MYDT) that incorporate automatic validation checks indicator calculations and metadata requirements.

These dynamic templates are essential tools for improving data completeness ensuring methodological consistency across countries and facilitating systematic reporting to the global SDG 4 monitoring framework. The UIS continuously improves these tools by refining formulas updating calculations integrating additional years of data and ensuring alignment with international statistical standards.

To strengthen this work the UIS requires technical expertise in supporting country submissions performing data validation and processing updating the templates improving code scripts used for automation and preparing review reports for global data validation processes.

Objectives

Under the overall authority of the Director of the UIS and the direct supervision of the Senior Project Officer (Administrative Data) the consultant will support UIS activities related to country submissions template updates data processing automation and quality assurance.

Key tasks

Activity 1 Support in Country Submission of Multi-Year Dynamic Templates (MYDT) for Survey Year 2025 data refresh and Survey Year 2026.

The consultant will support a maximum of 67 countries from Sub-Saharan Africa the Caribbean Asia and the Pacific in submitting validated MYDT :

• Ensure completeness and quality of country submissions

o Review MYDT submissions for accuracy and completeness and align with the latest ISCED mapping

o Run and complete the quality control checklist for each country

o Participate in virtual meetings with UIS staff (i.e. Regional Field Network (RFN) staff Montreal-based team) to explain template functions validation rules and indicator calculations.

o Support countries struggling with template completion or technical issues.

Activity 2 Documentation Validation and Processing of Data

The Consultant will develop update and run code scripts that automate data transfer validation and consolidation :

o Write update and run scripts to transfer raw data across template versions.

o Write / modify scripts to consolidate templates into master databases.

o Run data cleaning and consistency checks including age and age cohort based on UIS validation rules.

o Verify indicator calculations comply with UIS methodologies.

o Pre-fill dynamic templates using previously mined or UIS-validated data.

o Produce clear documentation guidelines and code annotations and clarifications / additional notes specific to member states if any.

o Convert scripts into ready-to-run executables whenever possible.

Activity 3 Updating and Implementing Changes to MYDT

o Add new years of data entry.

o Update formulas validation checks and indicator functions.

2. MYDT revision and testing

o Support UIS in pre-filling templates after revisions.

o Perform functional testing to ensure templates run smoothly.

3. Multilingual versions

o Produce translated versions of updated dynamic templates in French Spanish Portuguese and Russian.

Activity 4 Producing Review Reports on Country Submissions

o Produce country review reports based on dynamic template submissions.

o Structure reports according to the standardized UIS reporting format.

Activity 5 Preparation of harmonized questionnaires for Survey Year 2027

o Support UIS in pre-filling templates after revisions.

o Perform functional testing to ensure templates run smoothly.

Deliverables

Deliverables

Expected Deliverables (Total Duration : 80 Days)

Activity 1 Support in Country Submission of MYDT

Deliverables :

Timeline : February / March 2025 (15 days) & June / August 2025 (15 days)

Activity 2 Documentation Validation and Processing of Data

Deliverables :

Timeline : March / August 2025 (20 days)

Activity 3 Updating MYDT

Deliverables :

Timeline : January / February 2025 (10 days)

Activity 4 Review Reports

Deliverables :

Timeline : July / August 2025 (10 days)

Activity 5 Harmonized Questionnaires for Survey Year 2027

Deliverables :

Timeline : March / August 2025 (10 days)

Final Deliverables Package

Deliverables :

Timeline : September 2025 (3 days)

COMPETENCIES (Core / Managerial)

Accountability (C)

Communication (C)

Innovation (C)

Knowledge sharing and continuous improvement (C)

Planning and organizing (C)

Results focus (C)

Teamwork (C)

Professionalism (C)

For detailed information please consult the UNESCO Competency Framework .

REQUIRED QUALIFICATIONS

Education

Experience

Skills

Language

DESIRABLE QUALIFICATIONS

Experience

Skills

APPLICATION PROCESS

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

Only the proposals that include all the four aforementioned elements will be considered. Failure to provide any of those will result in an incomplete application which will not be considered.

UNESCO places significant importance on achieving the objectives outlined in the Terms of Reference. Consequently the evaluation of proposals will prioritize the technical components. From the proposals that meet the criteria specified in the Terms of Reference UNESCO will select the one that provides the best value for money for the Organization.

References

SELECTION AND RECRUITMENT PROCESS

Please note that all candidates must complete an on-line application and provide complete and accurate information. To apply please visit the UNESCO careers website. No modifications can be made to the application submitted.

The evaluation of candidates is based on the criteria in the vacancy notice and may include tests and / or assessments as well as a competency-based interview.

UNESCO uses communication technologies such as video or teleconference e-mail correspondence etc. for the assessment and evaluation of candidates.

Please note that only selected candidates will be further contacted and candidates in the final selection step will be subject to reference checks based on the information provided.

Footer

U NESCO recalls that paramount consideration in the appointment of staff members 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. UNESCO is committed to achieving and sustaining equitable and diverse geographical distribution as well as gender parity among its staff members in all categories and at all grades. Furthermore UNESCO is committed to achieving workforce diversity in terms of gender nationality and culture. Candidates from non- and under-represented Member States ( last update here) are particularly welcome and strongly encouraged to apply. Individuals 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. Worldwide mobility is required for staff members appointed to international posts.

UNESCO does not charge a fee at any stage of the recruitment process.

Please note that UNESCO is a non-smoking Organization.

Required Experience :

Contract

Key Skills

Active Directory,Data Entry,Clearance,LAN,Database Development,Electronic Discovery,Peripheral Equipment,Windows,QC,Software Managements,Data Files,RAN,Backup,Data Processing,Setup

Employment Type : Temp

Experience : years

Vacancy : 1