UNICEF Zimbabwe is inviting proposals from individual national consultants to provide technical support in the Development of an Excel Reporting Template for WASH (WASHet)

, , ZW

Job Number: 503879 | Vacancy Link
Location: Zimbabwe
Work Type : Consultancy

If you are a committed, creative professional and are passionate about making a lasting difference for children, the world’s leading children’s rights organization would like to hear from you.

For 70 years, UNICEF has been working on the ground in 190 countries and territories to promote children’s survival, protection and development. The world’s largest provider of vaccines for developing countries, UNICEF supports child health and nutrition, good water and sanitation, quality basic education for all boys and girls, and the protection of children from violence, exploitation, and AIDS. UNICEF is funded entirely by the voluntary contributions of individuals, businesses, foundations and governments.


The situation in Zimbabwe with regards to water and sanitation is deeply marked by distress. There is lack of improved water and sanitation systems for the majority of women and children. MICS 2014 reports that 76% of Zimbabweans had access to improved drinking water and 61% with access to improved sanitation facilities. The challenge is particularly acute in rural areas, with 43.5% practicing open defecation; more than 50% of community piped water schemes are non-functional.

The government of Zimbabwe in partnership with various development partners have initiated various national and sector specific initiatives aimed at improving WASH including

  • Zimbabwe Agenda for Sustainable Socio-Economic Transformation (Zim Asset) which is seeking to accelerate economic growth and wealth creation. Thus, the improvement of water supply and sanitation services occupies a prominent position in the Social Services and Poverty Eradication Cluster under the Zimbabwe Socio-Economic Transformation (ZimAsset).
  • Identification of SDG 6 as one of the priority goals of the country
  • Commitments to Sanitation and Water for All (SWA) Initiative and AMCOW
  • Revision of the Sanitation and Hygiene Strategy
  • Development of National Sanitation and Hygiene Policy
  • Ongoing implementation of a Demand Led Approach to Sanitation for rural areas

To contribute to increasing WASH service delivery and strengthening of WASH coordination, institutions and, sustainability UNICEF with funding from DFID implemented a Rural WASH Programme (RWP) running from 2012 to 2016 in 33 districts of five provinces[1]. The RWP has subsequently been extended to an additional three provinces[2], through a project addendum running up to October 2018.

The project is being implemented through government structures (National Action Committee – NAC structures at national, provincial and district levels as well as sub-district WASH structures) in partnership with NGOs/IPs that entered into PCAs with UNICEF. In the extension phase of the RWP, the NGOs will facilitate for the activities, outputs and outcomes of the project through the District Water and Sanitation Sub- Committees of the project districts in the three new provinces whilst the DWSSC will facilitate the activities been undertaken in the five initial provinces.


The RWP has various processes and tools for monitoring progress against key performance indicators as provided for in the project document and log frame through the efforts of the Programme Management Committee (PMT), UNICEF’s routine monitoring systems as well as Annual reviews with donors.

At the national level, a national Rural WASH Management and Information System (RWIMS) is being implemented and aims to contribute to sustainability of installed water points by providing a regularly updated status of water point functionality which will be used to contribute to timely system of response and repairs; currently, RWIMS has been implemented in all five RWP provinces with ongoing engagement of national and provincial government structures for ensuring regular updating of data is done and definition of roles of all stakeholders.

Under the RWP, monthly progress reports are provided by all target districts with the support of implementing partners to track progress, identify bottlenecks and make recommendations. The individual district reports are consolidated and shared with donors, districts and partners and relevant graphs/pictorials are also produced. For the submitted progress reports to be useful in informing programme corrections and monitoring, the data must be consistent, timely shared amongst all stakeholders, easily accessible to all and reliable.

It is proposed to develop an online reporting system in order to improve on the above mentioned and following aspects of the RWP reporting system;

  • Contribute to reduction in amount of time required for reporting
  • Improve the reliability of data inputs and create inbuilt system of checking consistency of data
  • Provide online access to monitoring data to all RWP players, including use friendly dashboard
  • Improved flexibility in generating graphs/pictorials from project data

UNICEF thus requires the services of a suitably qualified individual consultant to develop an online monitoring system for reporting monthly progress of key indicators of the RWP.

Objective (s)

The objectives of the assignment are:

  • To develop an Excel Template reporting system
  • To design an Interface that imports data from the Excel Template into an SQL database
  • To develop dashboards for specific indicators from the SQL database
  • To develop and interface for inputting comments and other textual and numerical data

Methodology & Expected Output

The consultant is expected to design the system using existing technologies and open source software. In addition, it is a must for the consultant to use the Systems Development Life Cycle (SDLC) methodology. Furthermore, the developed system should meet the following outputs:

  • The Excel template should validate the data before it is uploaded into the database
  • The interface for uploading the data into the database should be interactive and easy to use
  • Dashboards should be executed from both the database
  • The system should be automated as much as possible

Components of the system

  • SQL Server
  • Excel template 2003 upwards
  • Dashboard designer (Dashbuilder, Excel, any Open Source)
Major Tasks and Deliverables

Task: Requirements Gathering and Analysis

Deliverable: Understanding the Concept document, Requirements Specification and Excel Templates

Task: Develop a functional Rural WASH Excel Template (WASHet Rural)

Deliverable: Demonstrate a functional Excel template reporting tool

Task: Designing dashboards and reports

Deliverable: Demonstrate functional dashboards and reports

Task: System Review with all stakeholders

Deliverable: Requirements specification

Task: Incorporate changes into the Rural WASHet system

Deliverable: Demonstrate a revised functional system

Task: System testing

Deliverable: Develop a System Review document with refinements and enhancements and System Manuals

Task: Training users on how to use the system

Deliverable: A list of trained people

Task: Change Management and Maintenance

Deliverable: Analyze the user feedback, implement approved changes.

All deliverables will have to meet expected quality as assessed by the supervisor of the assignment.


The consultant is expected to start on 1 May 2017 and completed in 33 working days within a period of 11.5 months

Consultancy Requirements

The Consultant should have the following:

Advanced University degree in Computer science, Information Technology or related field

  • At least 5 years’ experience in designing WASH or related sectors (Nutrition, Health, Education etc) Management Information Systems and dashboards
  • In-depth knowledge of web based database development and analysis techniques
  • Proven experience in coding systems on similar subjects
  • Minimum 5 years hands-on software development experience with a mix of the following frameworks, tools and languages:
    1. Python or Ruby
    2. Django (or experience with a framework such as Cheetah, Camping, Rails)
    3. Source code management / Version control systems (Git)
    4. AJAX and JavaScript including libraries (such as jQuery and Mootools)
    5. mySQL, SQL Server Express
    6. XHTML and CSS
    7. XML
    8. Mapping (Google Maps API/ Openlayers)
    9. Lightweight libraries for interacting with graphing, photos.
    10. Linux
  • Proficiency in object oriented back-end programming languages;
  • Ability to produce high quality work on a variety of issues within very short deadlines.

Application Procedure

If interested and available, please submit your application letter, CV, Technical proposal and an all-inclusive financial proposal detailing monthly professional fees etc, as well as 2 samples of previous similar work by 18 April 2017. To quote “WASHET Consultancy” as the email subject heading.

Only shortlisted consultants will be contacted. UNICEF does not charge a fee during the recruitment process.

[1] Masvingo, Matebeleland North, Matebeleland South, Midlands and Mashonaland West

[2] Mashonaland East, Mashonaland Central and Manicaland

UNICEF is committed to diversity and inclusion within its workforce, and encourages qualified female and male candidates from all national, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of our organisation.

Opening Date Tue Apr 04 2017 09:00:00 GMT+0200 (SAST) South Africa Standard Time
Closing Date Tue Apr 18 2017 23:55:00 GMT+0200 (SAST)