Consultant for the Implementation of the Climate and Exposure Database (ClimEx.db) - For Filipino Nationals Only
United Nations Development Programme
3d ago

Duties and Responsibilities

For the engagement with HLURB, the consultant is expected to perform the following duties :

Conduct a workshop that centers on the use of the QlikSense application to retrieve information essential to the development of the enhanced CLUPs of the 12 RAPID partner LGUs.

The workshop should include but not limited to the following :

  • Brief overview of the ClimEx.db survey questionnaire to grasp the extent of the available data;
  • Understanding the ClimEx.db raw data;
  • Discussions on basic database concepts;
  • Navigation of the QlikSense desktop application;
  • Exporting data sets and filtered data;
  • Exporting of tables and charts;
  • Building HLURB’s Climate and Disaster Risk Assessment (CDRA) matrix;
  • Creating simple tables and charts without scripting; and

    Creating simple tables and charts with simple dimensions and expressions.

    Development of a dashboard in the QlikSense application with summary tables, graphs and charts customized in accordance with HLURB’s Supplemental Guidelines, specifically data requirements per Tables 4.

    4, 4.5, 4.6, 4.7 and 4.8 and other data on climate and disaster risk assessment (CDRA) needed for the integration process.

    Draft the ClimEx.db QlikSense Basic Navigation Manual / Module. This should incorporate discussions on the uses and functions of the ClimEx.

    db desktop application. Examples and exercises such as data retrieval, export to CSVs, table and graph generation should be in relation to the datasets that will be used as stated in HLURB’s CLUP Guidebook.

    Troubleshooting of issues that may arise from the ClimEx.db integration to the CLUP enhancement process effective within 2-

    months after the workshop.

    Technical assistance and advice to the RAPID Staff, Partner LGUs and HLURB Core Planning Team in report preparations and presentations, also within 2-

    months after the workshop.

    Prepare and provide training supplies / kits to the participants.

    For the Advanced ClimEx.db Application Training and Data Clean-up Activity with the RAPID partner LGUs, duties were as follows :

    Impart on the participants complex knowledge and skills with regard to the use of QlikSense for their ClimEx.db survey data such as :

  • Retrieving data from the database;
  • Loading and producing maps;
  • Exporting data sets and filtered data;
  • Generating frequency distribution tables;
  • Generating reports based on identified indicators; and

    Generating graphs, tables and charts with dimensions and expressions.

    Discuss and arrange drills and exercises about the creation of an electronic form using ODK.

    Discuss basic spreadsheet techniques for ClimEx.db survey data management.

    Discuss data clean-up methods and practices.

    Help LGUs in improving and refining their survey data.

    Draft the ClimEx.db Advanced User’s Manual and the ClimEx.db Data Clean-up Guidebook. These should incorporate presentations and examples discussed during the training.

    Prepare and provide training supplies / kits to the participants.


  • Commitment to UNDP’s mission, vision, values and ethical standards
  • Sensitivity to cultural, gender, religion, race, nationality and age differences
  • Treat all stakeholders fairly and without prejudice
  • Maintains objectivity and impartiality in handling evaluation processes

  • Experience in project development, implementation and evaluation particularly in directly managing results-based monitoring and evaluation methodologies
  • Demonstrated experience in conducting evaluation of multi-year and multi-component programmes and projects
  • Familiarity with the norms and issues in early recovery and rehabilitation work in disaster-affected areas
  • Ability to process large amounts and diverse set of data and documents related to infrastructure development, livelihood, resettlement, disaster risk reduction and management, and governance
  • Demonstrated strong coordination and facilitation skills
  • Strong interpersonal skills and the ability to initiate discussions with national / local governmental officials, peoples organizations and communities
  • Demonstrated ability to function in a team environment and to deal with complex multi-stakeholder environment
  • Demonstrated ability to prepare and present comprehensive reports
  • Education :

  • Bachelor’s degree or a diploma in any computer or programming related course;
  • Experience :

  • At least 5 years of experience in working with national agencies or local government units;
  • At least 3 years of working experience in QlikSense Desktop Application and Open Data Kit;
  • At least a year of experience in conducting trainings and workshops;
  • Knowledge of the ClimEx.db system;
  • Skills

  • Able to write technical and accomplishment reports;
  • Able to communicate and coordinate well with various project partners, local government units, and other stakeholders;
  • Able to work well with minimal supervision;

    The offer will evaluated based on the Combined Scoring method where the qualifications will be weighted a max. of 70%, and combined with the financial offer which will be weighted a max of 30%.


  • Duly accomplished Letter of Confirmation of Interest and Availability (Financial Proposal Template) using the template provided by UNDP;
  • Personal Curriculum Vitae, indicating all past experiences from similar projects, as well as the contact details (email and telephone number) of the candidate and at least three (3) professional references;
  • Application requirements should be emailed to and on or before 23 May 2018.

    Attachments can be downloaded in the below link (Financial Proposal Template, P11 Personal Histiory Template.)

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

    My Email
    By clicking 'Continue', I agree to neuvoo's Privacy & Terms and agree to receive relevant email job alerts. (cancel anytime) See here
    Application form