Result of Service
The objective of this consultancy is to develop a Water Information Management System (WIMS) for water related data and information that incorporates existing databases and other water sector stakeholders, to inform national decision-making for Trinidad and Tobago.
Duties and Responsibilities
The United Nations Environment Programme (UNEP) is the United Nations systems designated entity for addressing environmental issues at the global and regional levels. Its mandate is to coordinate the development of global consensus on environmental issues by keeping the environment under review and bringing emerging issues to the attention of governments and the international community for action.
UNEP and the Inter-American Development Bank (IDB) are currently implementing the Global Environment facility-funded CReW+ Project An integrated approach to water and wastewater management in the Wider Caribbean Region using innovative solutions and sustainable financing mechanisms in 18 countries in the Wider Caribbean. The GEF CReW+ Project aims to implement innovative, technical and small-scale solutions in the Wider Caribbean Region using an integrated water and wastewater management approach. The project is co-executed by the Secretariat of the Cartagena Convention, the German agency Deutsche Gesellschaft für Internationale Zusammenarbeit (GmbH) and the Organisation of American States (OAS) on behalf of UNEP and the IDB, respectively.
This consultancy post is in the UNEP Cartagena Convention Secretariat under the direct supervision of the Programme Manager for the Assessment and Management of Environmental Pollution Sub-Programme.
The Water Information Management System Consultancy for Trinidad and Tobago aims to develop a Water Information Management System (WIMS) for water related data and information that incorporates existing databases and other water sector stakeholders, to inform national decision-making. The development of the WIMS must explore the option of employing a combination of non-proprietary and/or proprietary tools and software – facilitating the WIMS’s interoperability between the different stakeholder’s databases/systems, while at the same time providing a modern user experience and easy-to-use interface no matter how complex the system.
The more specific objectives and criteria are:
- To create a national platform (open data portal) with a web-based front-end, that would facilitate and promote the access to and dissemination of water related data and information (both current and historical) in a real-time fashion via Application Programming Interfaces (APIs) and other end point;
- To create a centralized information hub that stores, secures, archives and controls access to the water related data and information provided by the relevant stakeholders i.e. WRA, IMA, EMA etc.;
- To deliver a user-friendly, national WIMS with databases that are secure – in accordance with current best practices and meets agreed data quality standards, with the ability to be maintained by all stakeholders and a platform that is intuitive to all end-users;
- To develop and deploy protocols for data exchange that is compatible with and creates interoperability among existing national information systems and regional water databases;
- To develop and deliver procedures for quality assurance, metadata maintenance and archiving of incoming data;
- To develop a basic Data Governance Framework that can be adopted by the collaborators of the WIMS. This framework should include processes, roles, policies, standards, and metrics that can be used to ensure the quality and security of the data within the WIMS, as well as the effective, efficient, and ethical use of the information to enable the water sector stakeholders to achieve their goals;
- To develop and implement a knowledge transfer procedure that will prevent knowledge loss when the project is completed. This procedure should feature the ability to capture and transfer explicit and implicit knowledge gained throughout the execution of the project;
- To identify and recommend workable solutions to any difficulties and barriers to data sharing among stakeholders;
- To identify data capture practices and mechanisms that can impact the effectiveness of the final product, and propose solutions to treat with these risks;
- To deliver a web-based, decision support tool that provides and allows for the creation, classification, presentation and distribution of numerical, graphical and descriptive statistical and spatial data , using the most common techniques;
- To generate a solution for inputting water related data in a standardized GIS format to meet the needs of all water sector stakeholders.
Roles and responsibilities:
The Consultant will carry out tasks as necessary to develop an electronic WIMS including a web-based Portal, tailored to Trinidad and Tobago’s specific context. Specific responsibilities include:
- Comprehensively reviewing the existing information portals and user needs and designing of a WIMS with data structure, database, management system, and software that meets those needs and satisfies all criteria outlined in Section 2;
- Designing functional specifications of the system to include but not limited to technology components, software/technologies, graphical user interface design and layout, incorporates dependability, security levels, spatial enablement, automated components, and catalogue of data sources, metadata, and quality control;
- Procuring any hardware and software as specified in the design;
- Preparing progress reports/documentation outlining the goals, defining works (completed and outstanding), meeting with implementation support team and updating project schedules;
- Populating the database with the initial data;
- Developing Standard Operating Procedures and a Data Governance Framework;
- Operationalizing and testing the information system;
- Preparing the Final Report which includes an Acceptance Testing Agreement;
- Conducting training sessions and workshops with stakeholders;
- Ensuring sufficient knowledge transfer to stakeholders;
- Handing over the Platform to the institution with responsibility for managing the system.
The WIMS Consultant will report directly to UNEP and will work in close coordination with the National Working Group. The Ministry of Public Utilities (MPU) and Water Resources Agency (WRA) of Trinidad and Tobago shall co-chair the National Working Group and coordinate the guidance and inputs of all the stakeholders represented. The MPU, as the Government entity with leadership responsibility for the water sector, would provide strategic oversight in collaboration with WRA to the National Working Group and ensure inter and intra institutional coordination is successfully undertaken.
The Consultant is expected to have the appropriate capabilities, software, equipment, facilities, or relevant access to such, in order to complete the required services. The Consultant will operate from their usual base country and is expected to use among others, open source (non-proprietary) software including but not limited to web technologies and APIs.
The contract price is a fixed output-based price regardless of extension of the duration specified herein. Payment will be remitted subject to the approval of deliverables by UNEP.
Skills: – Web and database programming skills;
- Creative, innovative, adaptable and an adept problem solver;
- Good organizational skills and proficient communicator who has proven experience in stakeholder engagement;
- Good analytical and organizational skills in gathering baseline data;
- Excellent verbal and written communication skills (English).
Academic Qualifications: – An undergraduate university degree in Computer Science, or other relevant disciplines;
- A postgraduate degree in any relevant field of study, such as computer science with a focus on information systems development, would be an asset;
- Professional certification in Data Platform Development / Business Intelligence or equivalent;
Experience: – Advanced knowledge of application, data and infrastructure architecture disciplines;
- Knowledge of fundamental web/internet technologies including familiarity with modern web design trends and user interface/user experience design;
- Ability to work collaboratively in teams and develop meaningful work relationships to achieve common goals;
- 4+ years of hands-on software front-end and back-end development experience with a strong background in database (SQL or no-SQL) technologies;
- Experience with data-driven architecture and systems design;
- Experience with unit and end-to-end testing;
- Knowledge of and experience in the integration of GIS data into web applications;
- Knowledge and/or experience of hydrological database design, would be an asset;
- Test-Driven Development (TDD) experience would be an asset;
- Familiar with integrating the Center for Internet Security – CIS Controls security standard into web applications.
Language: English and French are the two working languages of the United Nations Secretariat. For the post advertised, proficiency in oral and written English is required.
THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.