National Consultant: Develop an Integrated Dashboard for the IDPs Statistics and Indexes

TERMS OF REFERENCE

Hiring Office:  UNFPA Mozambique Country Office            

Purpose of consultancy: Develop an integrated dashboard with robust inclusion of a list of durable solution indicators disaggregated at the provincial/district level. 

Scope of work: (Description of services, activities, or outputs)

In Mozambique, large-scale internal displacement persists. In August 2023, IOM’s Displacement Tracking Matrix documented in Mozambique over 850,000 internally displaced persons (IDPs) and 570,000 returnees across the country, of whom over 138,000 are experiencing protracted displacement due to sudden onset disasters in the central provinces of the country. Further, many returnees face heightened vulnerabilities even after returning to their former place of usual residence or to the vicinity thereof.  

The data symposium held in November 2023 recognized that the 2023 update to the Mozambique Common Operational Dataset on Population Statistics (COD-PS) serves the dual purpose of (i) providing a robust population baseline for short-term humanitarian needs assessment and response planning and (ii) updating the evidence base on the size, distribution and composition of IDPs and their host communities - which can, in turn, be used to guide evidence-based solutions to protracted forced displacement in Mozambique. Further, the symposium identified potential opportunities in 2024 and beyond to build on the 2023 COD-PS update and further integrate the INGD’s IDP register, WFP vulnerability mapping data, and CRVS/ID data to improve and enrich baseline population and displacement data and estimates in Mozambique. It was recommended that INGD, INE, UNFPA, IOM and WFP coordinate efforts to explore these opportunities for more joined-up population and displacement data systems in 2024.

UNFPA strengthening of existing data platforms at the national/provincial level with robust inclusion of solutions indexes will facilitate the Government, UN agencies / implementing partner and IDPs and host communities. Given the complex displacement data landscape, enhanced coordination and data interoperability are crucial, we will build on the existing work being done by SWG’s Workstream 1 (Data for Solutions), prioritizing the sustainability of efforts through existing collaborations with Government counterparts such as National Statistics Office (INE), National Disaster Management Agency (INGD), and the Ministry of Economics and Finance (MEF). 

In addition to UN agencies, the INGD has also collected data on IDPs in the specific districts to utilize the data for humanitarian response as well as for advocacy purposes. However, this data stream is not consolidated and statistically robust, thus is not accessible to the external audiences.

Therefore, this assignment has been conceptualized with the following objectives:  

Provide technical support to INGD to develop the statistical database of  list of durable solution indicators.  Organize the of list of durable solution indicators from all UN agencies (IOM, UNHCR and WFP) To develop an interactive dashboard of list of durable solution indicators at the lowest geographical level (e.g. provincial/district) which allows users to make custom tables/maps based on indicators available in database.

Dashboard website features would include an interactive map of districts and an admin post level. The dashboard not only allows users to create custom tables, and compare results across districts, but users can visualise these data through interactive column charts, line graphs, maps, and scatter plots. Users can select indicators and districts of interest, add background characteristics (where possible) such as age, education, and other socio-economic background variables, and instantly see in a chart what is hard to discern in a table. These images are exportable for use in papers and presentations. 

Duration and working schedule: The consultancy is for a period of 60 working days. The consultancy will start from (01 June, 2025) 

Place where services are to be delivered: The consultant will be based at INGD and close coordination with UNFPA in Maputo.   Required expertise, qualifications and competencies, including language requirements:

The Consultant should have extensive experience in leading dashboard development, deployment, and maintenance particularly in the social sciences, and public health. S/He will possess excellent analytical, communication, and writing skills. Previous experience in conducting analysis from the IDPs will be considered an asset. His/her primary responsibilities will be: 

Contribute to identifying the list of key indicators from the list of durable solution indicators, population, housing, and socioeconomic background characteristics, with the close collaboration of INGD and the UNFPA technical team.  Advise the different types of graphs/charts, maps, and interactive visualization of the indicators at districts and admin post levels.  Provide technical support to prepare data in formats that would ensure the confidentiality of individual records. Develop an integrated different-layer interactive dashboard at the lowest geographical level (district and administrative post level) in the most advanced computer language.  Indicator tab: depicts a summary of each thematic area/sub-areas indicators.  Output Display divided into two parts:  Chart tab: Detecting several graphs/charts of indicators for each indicator. Map –showing the indicators by administrative level map The database should develop in such a way that it can be enhanced in the future.  To develop the protection of the dashboard with a firewall and have restricted login to the approved users.   The dashboard should be developed using standard language, such as Laravel PHP and mySQL databases. Please do not use the open sources (ODK etc)

The expected outputs and deliverables are as follows:

Inception report outlining the consultants’ understanding of the ToRs, and proposed list of indicators and the layout of the dashboard.  The report should translate the requirements of the ToR into a practical and feasible approach to the dashboard, and work plan.  Presents the draft online version of the dashboard.  The PowerPoint should be presented with the contents of the dashboard.  The presentation of the dashboard to INGD/UNFPA for review and final approval.

📚 𝗗𝗶𝘀𝗰𝗼𝘃𝗲𝗿 𝗛𝗼𝘄 𝘁𝗼 𝗚𝗲𝘁 𝗮 𝗝𝗼𝗯 𝗶𝗻 𝘁𝗵𝗲 𝗨𝗡 𝗶𝗻 𝟮𝟬𝟮𝟯! 🌍🤝 𝗥𝗲𝗮𝗱 𝗼𝘂𝗿 𝗡𝗘𝗪 𝗥𝗲𝗰𝗿𝘂𝗶𝘁𝗺𝗲𝗻𝘁 𝗚𝘂𝗶𝗱𝗲 𝘁𝗼 𝘁𝗵𝗲 𝗨𝗡 𝟮𝟬𝟮𝟯 𝘄𝗶𝘁𝗵 𝘁𝗲𝘀𝘁 𝘀𝗮𝗺𝗽𝗹𝗲𝘀 𝗳𝗼𝗿 𝗨𝗡𝗛𝗖𝗥, 𝗪𝗙𝗣, 𝗨𝗡𝗜𝗖𝗘𝗙, 𝗨𝗡𝗗𝗦𝗦, 𝗨𝗡𝗙𝗣𝗔, 𝗜𝗢𝗠 𝗮𝗻𝗱 𝗼𝘁𝗵𝗲𝗿𝘀! 🌐

⚠️ 𝐂𝐡𝐚𝐧𝐠𝐞 𝐘𝐨𝐮𝐫 𝐋𝐢𝐟𝐞 𝐍𝐨𝐰: 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥 𝐓𝐞𝐜𝐡𝐧𝐢𝐪𝐮𝐞𝐬 𝐡𝐨𝐰 𝐭𝐨 𝐠𝐞𝐭 𝐚 𝐣𝐨𝐛 𝐢𝐧 𝐭𝐡𝐞 𝐔𝐧𝐢𝐭𝐞𝐝 𝐍𝐚𝐭𝐢𝐨𝐧𝐬 𝐍𝐎𝐖!

Delivery dates and how work will be delivered (e.g. electronic, hard copy etc.): All material will be submitted to INGD and UNFPA in soft/electronic form.

Monitoring and progress control, including reporting requirements, periodicity format and deadline: The consultant will be in close coordination with UNFPA, an INGD senior management and other technical staff to ensure quality and standards. 

Deliverables and payment schedule: 

The key deliverables and payment schedule are as follows: 

Milestones: Submit the first Layout of the dashboard with key charts and maps, inception report. Payment (condition upon approval): 40%.  Finalized dashboard along with report and Upload/link the dashboard to INGD websites, Payment (condition upon approval: 60%

Supervisory arrangements: The Consultant will work under the direct supervision Technical Specialist (P&D Team Leader), UNFPA. The Consultant will work with CENOE, and INGD.

Expected travel: Travel is not required.

Required expertise, qualifications and competencies, including language requirements: 

Bachelor’s degree or higher in Computer Sciences, Data sciences, or a relevant combination of education for technical consultation.  Minimum 3 years of professional experience in the field of dashboard development in social science, preferably in humanitarian context, health, education and Census/DHS.  Skilled PHP Developer with hands-on experience in Laravel, MySQL, and HTML.  The ideal candidate should be able to implement interactive graphs and reports, build robust APIs, and maintain scalable web applications.  Knowledge of the IDPs indicators, humanitarian context, and socio-cultural issues.  Proven ability to work effectively with government officials. Languages: Fluency in oral and written English and knowledge of Portuguese.  Excellent interpersonal and general communication skills.

Inputs / services to be provided by UNFPA or implementing partner (e.g support services, office space, equipment), if applicable: A consultant is expected to use his/her own laptop or any other equipment if required. 

Other relevant information or special conditions, if any: Individual consultancy contracts will be signed between the Consultant and UNFPA Mozambique Country Office.

UNFPA Work Environment:

UNFPA provides a work environment that reflects the values of gender equality, diversity, integrity and healthy work-life balance. We are committed to ensuring gender parity in the organization and therefore encourage women to apply. Individuals from the LGBTQIA+ community, minority ethnic groups, indigenous populations, persons with disabilities, and other underrepresented groups are highly encouraged to apply. UNFPA promotes equal opportunities in terms of appointment, training, compensation and selection for all regardless of personal characteristics and dimensions of diversity. Diversity, Equity and Inclusion is at the heart of UNFPA's workforce - click here to learn more.

Disclaimer:

Selection and appointment may be subject to background and reference checks, medical clearance, visa issuance and other administrative requirements. 

UNFPA does not charge any application, processing, training, interviewing, testing or other fee in connection with the application or recruitment process and does not concern itself with information on applicants' bank accounts. 

Applicants for positions in the international Professional and higher categories, who hold permanent resident status in a country other than their country of nationality, may be required to renounce such status upon their appointment.