View Notice

Data Analyst to Develop an Integrated Solution of iPDNA, HBDA, ERNA, RDNA and DevLIVE+ Toolkits (Open for both National and International consultants)
Procurement Process :IC - Individual contractor
Office :UNDP Country Office - PHILIPPINES
Deadline :19-Jan-21
Posted on :06-Jan-21
Development Area :CONSULTANTS  CONSULTANTS
Reference Number :74297
Link to Atlas Project :
00115529 - UNDP Programme on Early Recovery
Overview :

Project Title: Early Recovery Project


Project Description
The Philippines is one of the most disaster-prone countries in the world, prone to earthquakes, volcanic eruptions, tsunamis and typhoons. Climate change has increased the scale and frequency of disasters in the Philippines with an average of 20 typhoons affecting the country each year. The current COVID-19 pandemic has emphasized the need for a more integrated approach that considers the resilience of the country’s health systems to minimize overall impacts on the economy and the welfare of the marginalized.


Disaster response and recovery in the Philippines has been largely focused on infrastructure reconstruction while socio-economic recovery has been more challenging. Risk reduction and humanitarian and recovery measures have not been systematically integrated, which has eroded resilience building efforts each time a new crisis occurred. As a result, the country’s poverty reduction efforts have often been compromised. Among those hardly hit are the most vulnerable on account of high exposure, inability to adapt, and weak socio-economic capacities. Those needing specifically targeted interventions include persons with disabilities, women and children, informal settlers in the urban areas, upland dwellers and indigenous communities, small farmers and fishermen.


In addressing these, disaster assessment is essential to quantify the situation by data. Multiple disaster assessment toolkits have been developed for various purposes and an integration solution is needed for better sustainability and simpler deployment.

The IT-enabled Post-Disaster Needs Assessment (iPDNA), supported by DFAT, UNDP Crisis Bureau and the Bangkok Regional Hub, has been deployed for Typhoon Kammuri on December 2019 and the Taal Volcanic Eruption on 2020 in support of the NDMO. Realizing the fruitfulness of its deployment, it was decided to enhance the iPDNA capability. iPDNA is currently being tailored for the integration and deployment for the COVID-19 response in the Philippines context and a National Consultant is hired to support the process.

UNDP has developed a Household and Building Damage Assessment (HBDA) Toolkit to support authorities in crisis-affected countries around the world, to assess residential and non-residential infrastructure and collect timely data to inform decisions. The HBDA will also inform prioritization for risk-informed rehabilitation and rebuilding.


Early Recovery Needs Assessment (ERNA) has been deployed by UNDP in various nations and focuses on understanding the recovery needs for host community and the Internally Displaced Persons (IDPs), while understanding the causes for, actors engaged in, and capacities for early recovery and social cohesion in the south, thereby enabling early recovery programming with a view to bridging the ongoing humanitarian operation with medium-term recovery and development programming in the south.


Rapid Damage Assessment and Needs Analysis (RDNA) is a response tool providing a quick “snapshot” of the disaster situation within the first 72 hours, thus, determines the type and extent of damages brought about by hazards, including its secondary threats, the critical needs of the affected population, and the local response capacities. It seeks to provide authorities and humanitarian actors the most pressing life-saving requirements. It has been deployed in the Philippines by OCD after various disaster events.


The Development through Local Indicators and Vulnerability Exposure Database (DevLIVE+) is a system and a tool that is used to collect, organize, visualize and manage baseline data and information on the household, building structures and production areas for monitoring access to and delivery of basic services, assessing vulnerabilities and exposures to hazards and risks, and creating development pathways toward sustainable and progressive communities. The DevLIVE+ generates socio-demographic profiles, not only at the municipal or barangay level, but up to the household level, including typology of houses. It also provides disaggregated data by sex, age, work, educational attainment, or spatial location through charts, lists or even map locations that would facilitate analysis in crafting the local land use and development plans. Considering that significant socio economic indicators can be captured related to access to basic services among others, local decision makers have found the tool essential in resource allocation, prioritization of barangays and delivery of services, or justify their programs, projects and activities using the DevLIVE+ to improve the conditions of communities who are most vulnerable, left behind, and lacking in access to government services.


In this context, an integrated digital solution of various DRR assessment toolkits would be an opportunity to explore in the Philippines. This assignment will contribute to embarking on a digital transformation by the integration of iPDNA, HBDA, ERNA and RDNA disaster assessment tools as well as DevLIVE+ at the Global level and its piloting in the Philippines context.

 

Institutional Arrangements
The Consultant shall report to the Focal Person that is supervised by the Team Leader of the Climate Action Programme Team of the Philippine CO, and work very closely with the System Developer of the integrated digital solution development in the execution of the assignment.

Technical supervision shall be provided by the Technical Working Group (TWG) composed of personnel from the Crisis Bureau, the Bangkok Regional Hub and the Philippine CO. The TWG shall review outputs/deliverables and determine whether to accept them within ten (10) working days after submission. The work shall be coordinated with the Regional Programme Accelerating Disaster Risk Reduction and Enhancing Crisis Response through Digital Solutions and the Country Programme Recovery and Resilience Building in the Philippines.
The Consultant should work closely with the HBDA team to seek clarification and any technic, and with technical teams engaged with ERNA/RDNA, iPDNA retrofitting and DevLIVE+ development. The outputs shall be delivered through a participatory approach, engagement with government, involving training sessions and focus group discussions with team members.

 

Duration of Work
It is estimated that the work shall involve a total of 90 person days spread over six (6) months; commencing February 2020 and ending in August 2021.

 

Duty Station
The engagement is home-based and for accessibility and availability to allow for discussions and reporting on progress of activities, regular online meetings shall be conducted. Schedule of these meeting will be discussed post-award.
The Consultant will not be required to be based in Manila or to report to office regularly, but status report on the outputs shall be expected from time to time or when per requirement basis.

 

Scope of Price Proposal and Schedule of Payments
The financial proposals from possible candidates should be expressed in lump sum amount inclusive of all financial costs related to this engagement (i.e. transportation/travel to and from residence-Manila and/or within Metro Manila, health insurance for the duration of the consultancy, supplies & materials, reproduction, communications including internet). Travel expenses to project-related meetings and workshops outside of Metro Manila shall be paid for by the Project.

The Payment terms are as follows:

Percentage

Description

Deadline

20%

Submission and acceptance of Inception Report

Feb 10, 2020

40 %

Assessment report of iPDNA, HBDA, ERNA/RDNA and DevLIVE+ indicator compatibility; and

Corresponding indicator adjustment plan that enables data reuse among DevLIVE+ and disaster assessment toolkits; and

Strategy report for integrating ERNA and RDNA

Feb 20, 2021

20%

Technical design of the proposed integrated package of iPDNA, HBDA, ERNA/RDNA and DevLIVE+ toolkits (Supporting the System Developer); and

Corresponding Data Flow Diagram among toolkits; and

Technical design of the cloud-based ERNA/RDNA digitalization toolkit (Supporting the System Developer); and

Technical design of the cloud-based ERNA/RDNA digitalization toolkit (Supporting the System Developer); and

A cloud-based ERNA/RDNA digitalization toolkit (Supporting the System Developer); and

The integration component of iPDNA, HBDA, ERNA, RDNA and DevLIVE (Supporting the System Developer); and

Testing report of testing deployment, adjustments and bug fixing (Supporting the System Developer)

Apr 16, 2021

20%

Submission and acceptance of Final Report with lessons learnt, summary of the technical support and other findings during project implementation (Collaborating with the System Developer); and

Pilot deployment report of the integrated DRR assessment package with data reuse for at least one (1) event (Collaborating with the System Developer); and

One webinar recording on findings of this assignment (Collaborating with the System Developer); and

One webinar / on-site training recording on HBDA deployment (Collaborating with the System Developer); and

One webinar / on-site training recording on ERNA/RDNA deployment (Collaborating with the System Developer)

June 25, 2021

 

Description of Responsibilities :

Objectives and Scope of Work
The objective of this assignment is to assess indicators compatibility of iPDNA, HBDA, ERNA, RDNA and DevLIVE+, carry out an indicator adjustment plan with a data reuse strategy, and develop a strategy to include ERNA in RDNA. The Consultant shall work closely with the System Developer and the Climate Action Team on developing an integrated solution of iPDNA, HBDA, ERNA and RDNA disaster assessment toolkits with function of importing data to and from DevLIVE+. Specific tasks are as follows:

Indicators Compatibility Assessment
- Assess indicator compatibility of iPDNA, HBDA, ERNA, RDNA and DevLIVE+;
- Carry out an indicator adjustment plan in consideration of gender equality and data reuse;
- Carry out a strategy that imports DevLIVE+ data to disaster assessment toolkits as baseline information;

Design of An Integrated Solution
- Support the System Developer in designing the technical architecture of the proposed integrated package of iPDNA, HBDA, ERNA, RDNA and DevLIVE+ toolkits;
o Separate toolkits with one integrated/interconnected database are preferred;
o Including an automatic data export module for Common Operational Datasets (CODs)
o Importing data from DevLIVE+ to disaster assessment toolkits as baseline information;
- Carry out a clear Data Flow Diagram that characterizes data sharing across toolkits and identifies the gap to having an integrated solution;
- Explore the feasibility to include ERNA in RDNA and carry out a strategy for integrated ERNA/RDNA;
- Support the System Developer in designing and developing a cloud-based ERNA/RDNA digitalization toolkit;
o KOBO or ODK-based designs are preferred;
o Offline functionality is required for non-Internet scenarios;

Technical Support for Pilot Deployment and Capacity Building
- Support the System Developer in testing deployment and adjustments;
- Provide technical support in iPDNA, HBDA and ERNA/RDNA pilot deployment as well as DevLIVE+ data import for at least one disaster event [hydro-met, earthquake];
- Conduct one (1) webinar session / on-site training session on ERNA/RDNA deployment, in collaboration with the System Developer;
- Conduct one (1) webinar session / on-site training session on HBDA deployment, in collaboration with the System Developer;
- Conduct one (1) webinar session on findings of this assignment;
- Support the System Developer in develop an Operation/User Manual for deployment and operation of the integrated solution including data syncing.

 

Expected Outputs and Deliverables

Deliverable/Output

Estimated Duration to Complete

Target Due Dates

Designated Focal Person who will review and accept Output

Assessment report of iPDNA, HBDA, ERNA/RDNA and DevLIVE+ indicator compatibility; and

Corresponding indicator adjustment plan that enables data reuse among DevLIVE+ and disaster assessment toolkits; and

Strategy report for integrating ERNA and RDNA

30 days

Feb 20, 2021

 

Team Leader of the Climate Action Programme Team (CAPT) of the Philippine CO

 

Technical Working Group (TWG)

 

Programme Analyst, CAPT

 

Programme Associate, CAPT

 

DRR Specialist, I&P / CAPT

 

Project/Early Recovery - Project Coordinator

 

 

Technical design of the proposed integrated package of iPDNA, HBDA, ERNA/RDNA and DevLIVE+ toolkits (Supporting the System Developer); and

Corresponding Data Flow Diagram

10 days

Feb 20, 2021

Technical design of the cloud-based ERNA/RDNA digitalization toolkit (Supporting the System Developer)

5 days

Feb 20, 2021

Development of a cloud-based ERNA/RDNA digitalization toolkit (Supporting the System Developer); and

Development of the integration component of iPDNA, HBDA, ERNA, RDNA and DevLIVE (Supporting the System Developer)

10 days

Mar 26, 2021

Testing report of testing deployment, adjustments and bug fixing (Supporting the System Developer)

5 days

Apr 16, 2021

Pilot deployment report of the integrated DRR assessment package with data reuse for at least one (1) event (Collaborating with the System Developer)

10 days

May 14, 2021

One webinar recording on findings of this assignment (Collaborating with the System Developer)

One webinar / on-site training recording on HBDA deployment (Collaborating with the System Developer)

One webinar / on-site training recording on ERNA/RDNA deployment (Collaborating with the System Developer)

10 days

May 28, 2021

Final Report (Collaborating with the System Developer)

10 days

June 25, 2021

Progress report

Weekly

Every Monday after the approval of Inception Report

TOTAL

90 days

 

 

 

 

 

Competencies :

Corporate Competences

  • Demonstrates integrity by modelling the UN mission, vision, values and ethical standards
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability

Other Competencies

  • Ability to work in close collaboration with a group of national and international experts, to meet strict deadlines and plan the work according to priorities;
  • Initiative, good analytical skills, mature judgment and ability to work under tight schedule while respecting deadlines achievement, ethics and honesty;
  • Ability to establish effective working relations in a multicultural team environment
  • Strong initiative and desire to succeed, accountable and willingness to be pro-active in identifying

suitable companies and engaging in appropriate business opportunities

  • Consistently approaches work with energy and a positive, constructive attitude
  • Builds strong relationships with internal and external clients
  • Demonstrates capacity to plan, organize and execute effectively
  • Encourages risk-taking in the pursuit of creativity and innovation
  • Excellent written communication and presentation/public speaking skills in English, focus on results, ability to interact productively in a teamwork environment;
  • Proven experience in dialoguing with senior level government and private sector executives

 

Qualifications : (Open for both National and International Consultants)

Candidates will be evaluated based on the Combined Rating methodology:

  • Technical qualifications = 70%
  • Financial Proposal =    30%

For the evaluation of the Technical Proposal, the selection of the successful consultant must be based on the following qualifications (with the appropriate obtainable points):

Qualifications

Points Obtainable (100 points)

Education

Minimum Master’s Degree in disaster risk reduction, humanitarian assessment and response, demographic surveys, sociology, data science, mathematics, statistics or related fields

 

- 20 points if relevant Ph.D

-  15 points if relevant Master’s Degree

20 points

Experience

At least 5 years of previous work experience on humanitarian response and needs assessments, demographic surveys, disaster impact assessment, disaster risk reduction or related fields.

 

 - Minimum 5 years = 32 points; 2 point per year for additional years, up to a maximum of 42 points in total

- Additional 6 points if minimum 2 years of working experience on any of target assessments/surveys, including PDNA, HBDA, ERNA and RDNA.

48 points

At least 1 year of previous work experience related to development of BI application, general software, data warehouse or general digital platform.

 

- Minimum 1 year = 7 points; 1 point per half a year for additional years, up to a maximum of 9 points in total

- Additional 3 points if minimum 1 year of working experience related to humanitarian response and needs assessments, demographic surveys, disaster impact assessment or disaster risk reduction

12 points

Sample Work

Submission of two sample works related to any of the following themes: indicator compatibility assessment of different datasets, humanitarian need assessments, disaster impact assessment, demographic surveys, disaster risk reduction or relevant fields.

 

- 10 points per qualified sample work

20 points

TOTAL

100 points

Applicants who will only receive 70 points from the assessment of the CV will be qualified for the assessment of the Financial Proposal. 

 

Recommended Presentation of Offer

Interested applicants must submit the following documents/information at https://jobs.undp.org/cj_view_job.cfm?cur_job_id=96200 to demonstrate their qualifications. Please group them into one (1) single PDF document as the application only allows to upload a maximum of one document. 

  1. Duly accomplished Letter of Confirmation of Interest and Availability using the template provided by UNDP;
  2. UNDP Personal History Form (P11) or Curriculum Vitae (following the template attached) indicating all past experiences from similar projects or requirements, as well as the contact details (email and telephone number) of the Candidate and at least three (3) professional references;
  3. Financial Proposal that indicates the all-inclusive fixed total contract price, supported by a breakdown of costs, as per template provided, and clearly stating the payment percentage as indicated in this TOR. If an Offeror is employed by an organization/company/institution, and he/she expects his/her employer to charge a management fee in the process of releasing him/her to UNDP under Reimbursable Loan Agreement (RLA), the Offeror must indicate at this point and ensure that all such costs are duly incorporated in the financial proposal submitted to UNDP. 

Note: The above documents need to be scanned in one file and uploaded to the online application as one document.

 

Interested applicants to note that personal Medical/health insurance (to be purchased by the individual at his/her own expense) is mandatory for the issuance of contracts. Upon award of the contract, the consultant must be ready to submit proof of insurance valid during the contract duration.

The following templates / Annexes and IC General Terms & Conditions can be downloaded from http://gofile.me/6xdJm/bE9TCw8fU:

  • General Terms and Conditions for Individual Contract
  • Letter of Confirmation of Interest and Availability
  • P-11 form

In view of the volume of applications, UNDP receives, only shortlisted offerors will be notified