UNICEF works in some of the world’s toughest places, to reach the world’s most disadvantaged children. To save their lives. To defend their rights. To help them fulfill their potential.
Across 190 countries and territories, we work for every child, everywhere, every day, to build a better world for everyone.
And we never give up.
UNICEF places a high priority on the availability of recent and reliable information for monitoring the situation of children, young people and families, for developing evidence-based policies and programmes. In this context, the TransMonEE (Transformative Monitoring for Enhanced Equity) database captures a vast range of data on social and economic issues relevant to the situation and wellbeing of children, young people and women in the countries of Europe and Central Asia. The data represent a particularly useful tool for governments, civil society organization, funding institutions and academia in considering their decisions, policies, programmes and agendas. The database is updated every year in collaboration with the National Statistical Offices (NSOs), and uploaded in the TransMonEE website: http://transmonee.org.
The database was initiated by the UNICEF Innocenti Research Centre in 1992 as part of the project on ‘Public Policies and Social Conditions: Monitoring the Transition in CEE/CIS’, better known as the MONEE Project. In 2009, the database migrated to the UNICEF Regional Office for Europe and Central Asia.
Each year country-specific templates are shared with the NSOs of participating countries, filled in and submitted by countries by the end of September with the data for the previous year. The UNICEF regional office for ECA then follows up with the countries for clarifications and additional information. The data are brought together, indicators calculated and checked again for consistency before being disseminated on the regional TransMonEE webpage.
Since 2011, the ECA region has been engaged in a continued process to improve child rights monitoring in the region and in particular, rights of the most disadvantaged children. This requires further strengthening the TransMonEE database content and structure, revising the overall pool of indicators with a view to enhancing coherence with the SDGs and increasing the availability of data on child protection indicators. Most of the countries are still struggling with availability of disaggregated data although there have been considerable improvements in recent years in terms of availability of data by age groups, sex and other potential markers of disparity.
In addition to continuous improvement and update of the content, the validation of the TransMonEE data has recently been to some extent automated. The website of the TransMonEE has been re-designed and was launched in October 2017.
UNICEF ECA RO will hire a database management consultant to ensure the continuity of data collection and validation as well as to support the aforementioned planned improvements to the database and dataflows.
The database management consultant will be responsible for timely and quality management of the TransMonEE database. S/he will contribute to maintenance, annual update, validation and analysis of data, will prepare the publicly available version of the database. S/he will contribute to revising the content and structure of the database and improving linkages between the TransMonEE database and other sources. S/he will assist in the preparation of needed presentations for the annual TransMonEE meeting (Oct 2018).
Timeframe: 1 June 2018 to 31 March 2019
Reporting: The consultant will report directly to the Regional Monitoring and Evaluation Specialist
TASK 1 Update country-specific databases and full TransMonEE database (reporting on 2017 end of year statistics), including:
- Liaise with CO and NSOs to ensure data is submitted on time with as much information as possible,
- checking and adjusting population age groups and respective formulas according the age distribution presented by country and checking changes over the period,
- updating final notes for all years on the basis of the new or updated comments from countries,
- retrieving/updating data from other sources,
- updating the full TransMonEE Database.
TASK 2 Prepare the publicly disseminated version of the updated TransMonEE database, including:
- validating the newly generated tables following changes over the period, comparing data with those presented in the previous years database and highlighting considerable or implausible changes,
- creating a summary table with regional totals and averages for selected key indicators,
- checking and updating notes and comparing with those presented in the previous year’s TransMonEE database.
- Preparing short country reports about data quality.
TASK 3 Support next years TransMonEE data collection (of 2017 data sets), including
- preparing country data collection templates (for 2017 end of year data) with an integrated validation module,
- updating guidelines and definition documents for this year’s data collection,
- updating the validation module for automatic checks of consistency and plausibility,
- Input data values for any 2017 statistics already available in the public domain.
TASK 4 Contribute to review and use of the TransMonEE database and Annual TransMonEE NSO Meeting, including
- Providing recommendations for a reviewed database, with enhanced content on child protection indicators, and adjusted modalities of data collection to reduce the requirements to NSOs.
- providing advice, as needed, to users of the database, respond to inquiries related to data,
- reviewing TransMonEE graphs and other analysis on the basis of the TransMonEE database and provide inputs and suggestions,
- contributing to organization and facilitation of the TransMonEE network meetin
- DELIVERABLE 1: Updated versions of country-specific databases and full TransMonEE database with 2017 data submitted by NSOs
- DELIVERABLE 2: Publicly disseminated version of the updated TransMonEE database with 2017 data
- DELIVERABLE 3: TransMonEE country templates to be used for the 2017 data capture with an integrated validation module and updated guidelines
- DELIVERABLE 4: Recommendations for revised structure, content and data collection modality of the database
- DELIVERABLE 5: Finalized versions of country templates after all the checks and corrections have been conducted and country data quality reports
- Liaison with CO and NSOs on submission of 2017 data.
Qualifications and Competencies
Minimum Master’s degree in statistics, information systems, demography or a related field
Skills and Experience
- Minimum of 10 years of work experience in development and/or coordination of social statistics databases, the knowledge of TransMonEE being an asset,
- Familiarity with the data collection systems in Europe and Central Asia,
- Familiarity with the data collected by other international organizations such as EuroStat, UNECE, WHO, ILO, UIS and the World Bank,
- Advanced knowledge of MS Excel and familiarity with different types of software used for database management, analysis and presentation,
- Ability to analyze diverse and complex quantitative data from a wide range of sources,
- Fluency in English and preferably at least one of the major languages used in the region
- Demonstrated ability to work in a multicultural environment and establish harmonious and effective relationships with national partners,
- Ability to communicate effective to varied audiences.
Consultant’s Work Place and Official Travel
The consultant will work from home using own equipment and stationary. The consultant will be expected to travel to the TransMonEE network meeting, which is expected to take place in October 2018 (location: Almaty). Travel expenses and accommodation will be covered by the consultant and will be reimbursed by UNICEF upon submission of receipts. The travel costs reimbursed shall be based on economy class travel and the costs for accommodation, meals and incidentals shall not exceed applicable DSA rates as per UNICEF rules and regulations. Agreement with UNICEF is required previous purchasing of flight tickets or other onerous travel arrangements.
Estimated Cost of the Consultancy
Please indicate your daily fee for 75 working days
Payments will be made in the following instalments upon submission of the following deliverables in accordance with the requirements of the ToR:
- 1st payment – 10 August 2018, upon submission of deliverables 1,2,3,4 – 40 working days
- 2nd payment – 31 October 2018, reimbursement of travel cost for participation of the TransMonEE Meeting
- 3rd payment - 31 March 2019, upon submission/finalization of deliverable 5 – 35 working days
Confidentiality of Data and TransMonEE Documents
The consultant must respect the confidentiality of the data as well as any country-specific documents that will be reviewed throughout the TransMonEE data collection process. The consultant can use the documents and the datasets only for the tasks related to these terms of reference.
Nature of Penalty Clause in Contract
If the documents are not submitted according to the deliverables stated in this TOR, the payments will be withheld.
UNICEF reserves the right to withhold all or a portion of payment if performance is unsatisfactory, if work/outputs is incomplete, not delivered or for failure to meet deadlines (fees reduced due to late submission: 20 days - 10%; 1 month -20%; 2 months -30%; more 2 months – payment withhold). All materials developed will remain the copyright of UNICEF and UNICEF will be free to adapt and modify them in the future.
UNICEF is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of the organization.
Only shortlisted candidates will be contacted and advance to the next stage of the selection process.