United Nations Development Programme (UNDP)

National Consultant (Design Monitoring and Evaluation Solution According to MZ Project Indicators and Beneficiaries)

United Nations Development Programme (UNDP)

Job Description

  In 2020, UNDP launched the implementation of the Strengthening the Role of Local Communities/Mjesne zajednice in Bosnia and Herzegovina Project, Phase 2 jointly financed by the Government of Switzerland and the Government of Sweden. The overall goal of the second Project phase is to improve the quality of life of the citizens of Bosnia and Herzegovina through empowered, gender responsive local communities (MZs) that facilitate active citizen engagement in public life, stand for people-centered performance of local governments and catalyze democratic transformation at the local level. The Project's implementing strategy is empowerment of local communities, with changes envisaged at system level (improvement of the Local Government regulatory framework, rulebooks and practices, emerging policy and regulatory changes at the higher level) and behavioural change (change in attitude, perceptions within communities; change in traditional gender roles and stereotyping, critical thinking community representatives, pro-active engagement in local public life, use of technologies for socially constructive purposes, restoration of trust in government and hope that change is positive). A combination of these transformations is a pre-requisite for durable changes once MZs become agents of local change. In doing so, the Project places MZs and their communities at the centre of its work, while also relying on a broad range of relevant stakeholders to sustain and expand Project results and increase democratic accountability.

The key Project stakeholders are the following 41 LGs: Banja Luka, Bihac, Bijeljina, Brcko distrikt, Breza, Centar Sarajevo, Citluk, Doboj, Goražde, Gracanica, Gradacac, Gradiška, Ilijaš, Jablanica, Kljuc, Kotor Varoš, Laktaši, Ljubinje, Ljubuški, Maglaj, Modrica, Mrkonjic Grad, Nevesinje, Olovo, Pale FBiH, Petrovo, Rogatica, Rudo, Sanski Most, Tešanj, Teslic, Trebinje, Trnovo, Višegrad, Visoko, Vitez, Vlasenica, Vogošca, Zavidovici, Zenica, Žepce.

Purpose of the Consultancy

The purpose of the consultancy is to support monitoring and evaluation processes of the Strengthening the Role of Local Communities /Mjesne zajednice in Bosnia and Herzegovina Project via more systematised collection and Analysis of set indicators and project beneficiaries on implementation of project activities. In this regard, one M&E solution Developer (hereinafter the Consultant) will be engaged.

Objective of the Consultancy

The consultancy objective is to provide MZ Project with monitoring and evaluation solution tool, designed and developed to allow prompt and easy monitoring of project indicators, participation of stakeholders and beneficiaries at different implementation activities organized within the MZ Project. More concretely, the Consultant will Design and develop MZ Project M&E tool, in appropriate technology, so as to provide best possible solution for easy, fast and accurate Data Entry and Data Analysis to enable quality overall monitoring, evaluation and reporting of this aspect of the MZ Project.

Duties and Responsibilities

The Consultant, in close cooperation with the Project team, will design and develop a user-friendly, stable and reliable M&E solution, which will allow fast and accurate data entry and analysis on several predetermined conditions and relations, and will import data from the current Project’s Excel tool into the newly developed database.  More concretely, the Consultant will have following key tasks and deliverables:
  • In close cooperation with the Project team, analyse existing tools and develop the structure or format of the database, incorporating ideas and amendments from the Project team.
  • Design a new simplified solution that will allow for fast, accurate and reliable data entry as well as analysis and reporting in required formats including pivots, graphs, charts, etc, based on the input by the Project team.
  • Develop Participants Database Manual on the use of the developed tool and provide training to relevant Project team members.
  • Submit a technical report covering all aspects of the solution development process and definitions of functions, codes, variables and copies of any programme written.
The database will be a stand-alone data-entry and analysis solution for information that can be recalled and referenced across multiple places. The Consultants is expected to recommend the underlying technology of the database (Excel, Access or different) taking into consideration the quantity of data that it should handle, and that the database needs to be based on either MS Office applications or open source solutions.

It is expected that the consultant will visit the MZ Project premises in Sarajevo at least 2 times during the assignment (for briefing and joint analysis at the beginning of the assignment and for the training at the end of the assignment), however, if necessary entire communication can be carried out by means of online platforms, emails or telephone.


New M&E tool developed and import of data from the current Excel tool finalized.

15 12 April 2021 75% Enter Deliverable Solution Manual and training on database use completed.

3 19 April 2021 15% Technical report finalized and submitted.

2 22 April 2021 10% Competencies

Core values:

  • Demonstrates integrity and fairness by modelling UN values and ethical standards;
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability.
Core competences:

  • Demonstrates commitment to UNDP’s mission, vision and values;
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability;
  • Plans, prioritizes and delivers tasks on time;
  • Strives for and promotes excellence in performance continually;
  • Participates effectively in a team-based, information-sharing environment, collaborating and cooperating with others;
  • Generates ideas and seizes opportunities to support corporate strategic objectives.
  • Technical writing skills, formulates written information clearly and persuasively;
  • Strong communication skills;
  • Shares information openly with co-workers and partners while using discretion to protect confidences;
  • Presents information in a clear and articulate manner

Required Skills and Experience

Academic Qualifications/Education:

  • University Degree in Computers Science, Economics, Statistics, Mathematics or similar relevant field.

  • At least three years of relevant experience in ICT and Software Development;
  • Proven experience with database design and development, Database Management and data analysis;
  • Proven record of practical experience in programming Microsoft Access database, SQL and VBA;
  • Experience in training project personnel in the use of tool/database management Software Applications;
  • Experience in writing and maintaining database design documentation and operating manuals.
  • Previous experience with UNDP or international UN Agencies.
Languages Requirements:

  • Fluency in languages of Bosnia and Herzegovina (excellent writing, editing and communication skills).
  • Fluency in English is an asset.
Longlisting/Shortlisting Criteria

Qualifications as stated in the ToR Relevant Education max 15 points5 points allocated for BA/BSc degree+ 5 points for MSc/MA+ up to 5 points for PhD Relevant professional experience max 15 points Prior work experience with UNDP/UN Agencies max 10 points Knowledge of English max 5 points - will be assessed as:5 points for fluency and the points decrease as per the level mentioned in the CV:good - 4 points;fair/upper intermediate – 3 points;intermediate - 2 points;beginner - 1 point.

Technical Evaluation Criteria Rating based on Qualifications 50% Methodological approach to the assignment  50% Evaluation

Individual  will be evaluated based on the following methodology: Cumulative analysis

When using this weighted scoring method, the award of the contract should be made to the candidate whose offer has been evaluated and determined as:a) responsive/compliant/acceptable, andb) Having received the highest score out of a pre-determined set of weighted technical and financial criteria specific to the solicitation.

  • * Technical Criteria weight-70%
  • * Financial Criteria weight- 30%
Interested candidated must submit the following documents/information to demonstrate their qualifications:
  • Explaining why they are the most suitable for the work
  • Provide a brief methodology on how they will approach and conduct the work; or sample of previous document/strategy/paper done by the consultant
Please scan all above mentioned documents and upload as one attachment only online through this website.


  • For an assignment requiring travel, consultants of 65 years or more require full medical examination and statement of fitness to work to engage in the consultancy.
  • Due to large number of potential applicants, only competitively selected candidates will be contacted for remaining steps of the service procurement process.
Apply Now