Consultant for MIS and GIS

The USAID Indonesia Urban Water, Sanitation and Hygiene, Penyehatan Lingkungan Untuk Semua (IUWASH PLUS) program is a five-and-a-half-year initiative designed to assist the Government of Indonesia (GOI) in increasing access to water supply and sanitation services as well as improving key hygiene behaviors among urban poor and vulnerable populations. USAID IUWASH PLUS works with governmental agencies, the private sector, NGOs, communities and others to achieve the following "high level" results:

1. An increase of 1,100,000 people in urban areas with access to improved water supply service quality, of which at least 500,000 are from the poorest 40% of the population (also referred to as the “Bottom 40%” or “B40”), vulnerable groups or Indonesia’s eastern provinces; and 
2. An increase of 500,000 people in urban areas with access to safely managed sanitation. 

To ensure that improvements in access to WASH services are sustained, USAID IUWASH PLUS is guided by a development hypothesis that focuses on strengthening service delivery systems, so they can more effectively reach the poorest and most vulnerable segments of the population. In order to achieve this at scale, the program undertakes activities through four interrelated components, including: 1) improving household WASH services; 2) strengthening city WASH institutional performance; 3) strengthening the WASH financing environment; and 4) advancing national WASH advocacy, coordination and communication. In support of these components, USAID IUWASH PLUS also implements a Local Sustainability and Innovation Component (LSIC) that is designed to stimulate WASH innovations that strengthen community, private sector and government WASH service provision.

To achieve these outcomes IUWASH-PLUS is looking for a short term consultant to fill the position of 

Consultant for Development of Management Information Systems for Web GIS/Mapping of Service Area Coverage Application, National Office (Job Code : IC/WGIS-JKT)

Objective

The objective of developing the MIS for Web GIS/ Mapping of the service area coverages is that PDAM can be utilized more efficiently, effectively and transparently in the implementation of water distribution services to its customers, so that it is expected will be accelerate the achievement of government targets in drinking water services for the community.  MIS for Web GIS/ Mapping  of the service area coverages applications will speed up the process of new connection services, handling reports on distribution problems, finding locations for leaks and lack of water pressure and assisting management in plans of service area coverage development. Furthermore, with the use of MIS for Web GIS/ Mapping  of service area coverages application by the PDAM, it will ultimately help implement the program to reduce non-revenue water, additions to the number of customers and services area, then will increase regional revenues, especially from water distribution to the community. 

SCOPE OF WORKS
MIS for Web GIS/ Mapping  of service area coverage application is a system designed for special purposes and cannot be purchased directly because it is not available on the market, so it must be developed specifically, IUWASH PLUS, as an application buyer, will purchase the system through a Purchase Order mechanism to individual application provider.

The application provider in providing the system will design, develop, test and install in the system at the PDAM partner of USAID IUWASH PLUS and submit the master software installer including the source code and application operation manual software. The application provider must also train staffs of USAID IUWASH and PDAM regarding the operation of this application.  The candidate location to install the application is PDAM Depok City, but it is not limited, it can also be installed in other PDAMs.

The minimum specifications of the application:
• The application is developed with the concept of open source, so that later it will be easily developed and installed by anyone as needed, the source code will be shared in IUWASH PLUS GitHub Repository.   
• The applications must be developed as a web based applications and installed on the PDAM server, so it can be operated with web browser applications (Chrome, FireFox, Opera etc.) on every computer connected to the server (LAN, Internet)
• The application must be able to display existing spatial data of water supply services, including: location of water supply facilities, pipelines and it's accessories, customer location points of the format developed in GIS application (shapefiles), and basic maps as a background. Data can be stored in SQL database format or JSON/XML objects.
• The application can provide interface options for basic map as background, are: Google Maps, Open Street Map or Maps, or maps developed by PDAM it self with GIS application using WMS or Tileserver protocol.
• The application has several features, including; searching/querying features, displaying spatial data including it's attributes, drawing line vector objects and points on  screen but not edit the original data, length calculation the drawn line, generating earth coordinate values from drawn points and save screen displays in a common image format (jpg, bmp, etc).
• This application has user management features; administrators, supervisors and other users with various levels of access facilities which can be accessed by PDAM internal staff (not widely open for public)

DELIVERABLES
The Application providers for developing Management Information Systems for Web GIS/ Mapping of Service Area Coverage are responsible for the following work:

• Design and write Application programs
• Install the application on the PDAM Depok system
• Train USAID IUWASH PLUS and PDAM staff about procedures for installation and the use of the application
• The deliverables material are; All reports, master installer application including the source code and installation and operation manuals.

GIS facilitator requires to submit: work plan report, monthly reports, and Final Report as well as contributed to biweekly reports.

Period of Work
The work of Management Information System for Web GIS/ Mapping of Service Area Coverage development must be completed within three (3) months, starting from September 2019 to November 2019, with system test to be concluded in the middle of October 2019 to simulate the installation of new connections, search for pipeline leak locations and customer reporting locations. 

General Required Qualifications and Experience:
To ensure the delivery of the output: the Management Information System for Web GIS/ Mapping of Service Area Coverage, Application Provider has the following qualifications:  
a. Bachelor degree of information technology, computer science, software programmer/developer
b. Experienced in  develop web-based and android applications integrated with GIS/spatial mapping system
c. Minimum 3 years experienced in web-based applications development
d. Good knowledge of web2.0/3.0 technologies, experienced in Javascript, HTML, CSS web development
e. Experience in Yii2 PHP Framework, or Laravel, and LeafletJS/OpenlayersJS is preferable
f. Good knowledge in PostgreSQL (PostGIS) or GeoJSON/JSON API is highly desirable
g. Understand Geographic Information System concept and web-based spatial mapping databases development


Expected Start Date: September 2019 

APPLICATION SEND 
Interested applicants are invited to send a complete application with 3 references to IUWASH_plus_recruitment@dai.com  or IUWASHPLUS.recruitment@gmail.com before August 25, 2019. Please write the job CODE in the subject line of the email. We regret that we are unable to acknowledge receipt of all applications and only shortlisted candidates will be notified.