Background

Securing Child Rights in the Fisheries Sector in the Central Region and along the Volta Lake of Ghana (SECRIFISE) is a three-year project funded by the European Union and implemented by Hen Mpoano, CEWEFIA and Challenging Heights.  SECRIFISE is focused in five coastal districts of the Central region and six districts along southern Lake Volta.  With the overall objective to secure child rights in the fisheries sector by increasing public support for eliminating Child labour and trafficking (CLaT), implementing community-based initiatives for integrating CLaT victims in mainstream society and supporting enforcement of anti-CLaT legislation, SECRIFISE is targeted at children at-risk of CLaT, victims and survivors of CLaT and re-trafficked children; parents and guardians, including family heads in the central region as well as “slave masters” and “mistresses” in the Volta Lake; community and district child protection committees; state attorneys; anti-Human trafficking unit of Ghana police service among others.

SECRIFISE focuses on four specific objectives;

  • To increase public support for eliminating CLaT in the fisheries sector through awareness creation and behaviour change communication;
  • To promote an effective and evidenced-based system for rescuing, rehabilitating and monitoring vulnerable children and linking them to state protection services;
  • To promote enforcement of anti-CLaT legislation through strengthening institutions in CLaT source and receiving communities and state institutions along the prosecutorial chain;
  • To improve incomes of households susceptible to CLaT through provision of business development support services.

Stakeholders working on CLaT in the fisheries sector do not have a common and systematic format for collecting, storing and sharing data on CLaT. As a result, data on vulnerable children and those at-risk of trafficking in the fisheries sector are scanty and in most cases unavailable in formats that allow for long-term monitoring of vulnerable children and victims.

As part of supporting an evidence-based system for rescuing, rehabilitating and monitoring of vulnerable children and CLaT survivors, SECRIFISE seeks to engage the services of a firm or individual consultant to develop a CLaT monitoring database that provides a systematic format for storing and sharing data on CLaT. The development of a CLaT monitoring database will strengthen the information system for long-term monitoring of rescued survivors as well as rehabilitation and reintegration processes. The database will allow for storing, updating and retrieving both spatial and non-spatial information about victims and their status after rescue, rehabilitation and reintegration.

In performing the tasks, the consultant is expected to consult with stakeholders working on CLaT issues, including those in the fisheries sector.

Objectives of the assignment

The objective of the assignment is to develop a CLaT monitoring database that integrates both spatial and non-spatial information.

Tasks to be performed

Tasks for this assignment will include the following;

  • Data organization to inform relational spatial database

Consultant will utilize all available sources of data generated about trafficked victims in the course of the project. Data generated in the form of pictures, biodata (names, age, sex, education, parent names, places of birth, etc.) locational information regarding their origin, rescue date and location, and their current rehabilitation location. This information demonstrate their trafficking route. Additional information will include their activities at the rehabilitation center.

  • Planning of database design and system definition

Consultant will strategically plan and present a structure of the relational spatial database which accommodate information from Task 1 above, to a panel from the project for vetting and input. A key expectation in this design as well as implementation is the ability of the system to accommodate future information about a child as captured in the system.

  • Design database utilizing logical models to aid database connection, data retrieval and report development

Consultant will develop a spatial relational database which features Tasks 1 and 2. Task 1, rectified through Task 2, should be captured in data portals dedicated to individual cases in the database. Additional features should include the ability to possess a two-way system update platform which features the ability to update the database remotely through short messaging service (SMS) platform and allows for a SMS feedback. For system integrity purposes, we recommend restrictions to the location from where the SMS is received. The system should provide monthly report of the spatial distribution of the database, and provide update of the status of the database with the aid of data visualization tools. The database should possess overlapping channels that allows updates with future progress.

  • Relational spatial database implementation

Consultant will fully implement the spatial database on a server system provided and used by the project. Specialist will be in charge of populating the database from the date of its operation till the end of the project. During this period, he/she will train project members as well as the larger user community on how to update and query the system using the SMS approach. Lastly, a detailed hand over training will be planned to enable the specialist completely hand over the system to a project lead.  

Deliverables

  • Spatial relational database.
  • Portal or front end for generating individual case report through a SMS querying system for fast and efficient reporting and follow-up action.  
  • A power point presentation summarizing the components and functions of the database.  

Expected Skill Set of Consultant

Ability to use the following knowledge tools will be an advantage;

  • Relational spatial database design and implementation.
  • POSTGIS
  • POSTGRESQL
  • ArcGIS SUITES
  • SQL
  • R studio
  • QGIS 3

Budget

Budget should range between GHS 18,000 to 25,000 GHS. Contract terms and conditions will be negotiated upon selection of winner.

Application process

Proposals ( maximum, 2-pages including budget) and profile of firm/individual consultant must be submitted via email to info@henmpoano.org by GMT 23:59 on 14th December, 2020.

Assessment Criteria

  • Clarity of proposed approach for the assignment
  • Work schedule
  • Experience of the consultant/firm in executing similar assignments
  • Value for money