RFP for Consultant to Conduct Data Analysis and Report Writing for Latrine Census in Kakuma for Kalobeyei integrated settlement and Kakuma refugee cam Consultancy NEW

1. Background

Peace Winds is a Japanese Non-Governmental Organization established in 1996. Peace Winds has been providing humanitarian and development assistance for people affected by forced displacement and natural disasters in more than 20 countries in the world. Peace Winds launched its mission in Kenya in 2012 and has been implementing projects funded by UN agencies and the government of Japan. PWJ works in Garissa, Turkana, and West Pokot Counties where we implement projects on livelihoods (food security, and skills development for women and youth empowerment), WASH (water, sanitation, and hygiene), shelter and infrastructure, and supply chain management.

Peace Winds is currently implementing WASH, Shelter and Logistics project in Kalobeyei integrated settlement and Kakuma refugee camp funded by UNHCR, that seeks to improve access to safe shelter, sanitation and hygiene for refugees and host communities and as well as adequate portable water supply to the refugees, host communities, and institutions such as health facilities and schools.

The purpose of the latrine census is to provide data on the number and types of latrines, and their conditions. The census data can help to serve as a baseline for further assessments. Peace Winds will be latrine census in November 2024. The census will be conducted to all households (approximately 59,123[1]) in the Kalobeyei integrated settlement and Kakuma refugee camp. Peace Winds therefore is seeking to engage a consultant to document the census findings and submit a final report.

Objective of the assignment

The consultancy task is to analyze the census data and document the findings in a comprehensive report. The consultant shall analyze data in table formats, and submit the final report. The analyst should understand the desired goal of the project driving the findings towards it. The objectives of the census are driven under:

• Assessing latrine Conditions: The primary objective is to gather comprehensive data on the current state of latrines in the integrated settlement and refugee camp population. This includes assessing the type of latrines, their conditions, and any vulnerabilities or deficiencies.
• Identifying latrines-related Needs: Understand the specific needs and challenges related to access to latrines in the refugee camps. This involves identifying issues such as inadequate access, barriers to construction of basic household latrines and other factors affecting the quality of latrine.
• Quantifying the Population: Enumerate and categorize the population having access to the different types of latrines. This information is crucial for resource allocation, as it helps in estimating the scale of interventions required to address the access to latrine for the refugees.
• Creating Baseline Data: Establish a baseline for monitoring and evaluation purposes. This baseline data serves as a reference point for future assessments, allowing for the measurement of changes and the impact of interventions over time.
• Enhancing Resource Allocation: Enable efficient allocation of resources by identifying priority areas and populations with the greatest access to latrine needs. This ensures that interventions are targeted and resources are utilized effectively.
• Supporting Advocacy Efforts: Generate evidence for advocacy initiatives aimed at raising awareness and garnering support for policies and funding related to latrine issues. The data collected can be used to build a compelling case for improved living conditions.
• Ensuring Accountability: Establish accountability mechanisms by providing transparent and evidence-based information to stakeholders, including donors, governmental agencies, and the community itself.

Scope of the work

Data Cleaning and Validation: Review and clean the collected latrines census data to ensure accuracy and consistency. Validate the data for completeness, identifying and addressing any missing or inconsistent information.

Data Analysis: Conduct statistical analysis of latrine census data to derive meaningful insights and trends.

Utilize appropriate statistical tools and methods to analyze demographic information, latrines conditions, and other relevant variables.

Descriptive Analysis: Generate descriptive statistics to provide a comprehensive overview of the latrines related characteristics within the surveyed population. Summarize key findings, including averages, distributions, and patterns.

Mapping and Visualization: Create maps and visual representations of the latrines census data to facilitate a better understanding of spatial patterns and distribution of latrines-related indicators. Use Geographic Information System (GIS) tools if applicable.

Identifying Key Challenges and Opportunities: Highlight key challenges and opportunities based on the analysis, providing actionable insights for program planning and improvement.

Report Writing: Prepare comprehensive and clear reports summarizing the findings of the latrine census data analysis.

Present the results in a format suitable for diverse audiences, including policymakers, donors, and the community.

Recommendations: Provide evidence-based recommendations for programmatic interventions based on the data analysis. Suggest improvements and strategies to address identified challenges and enhance the impact of latrine-related interventions.

1. Deliverables

• Deliverable 1: Inception report containing detailed methodology for data analysis
• Deliverable 2: Census analyzed data in readable format (The graphics should entail right scaling and informative graphic headings.Note:(Poorly located and labeled axes, insufficient use of color, shape and size that can obscure the relationship in data or make the data hard to read and interpret should be avoided)
• Deliverable 3: Census report in MS word and PDF versions and Cleaned dataset

1. Reporting Modalities

The consultant will work with Peace Winds Shelter &Spatial planner/Engineer and MEAL staff in Kakuma, with overall guidance of the Area Manager. The MEAL team will work closely with the consultant by:

• Providing the raw data collected from the latrine census.
• Validation of the analysis ensuring it meets the standard of Peace Winds.
• Review of the report done by the Consultant

1. Assignment Duration

The consultant is expected to carry the assignment in 10 working days in November, 2024.

1. Qualification, required skills

   The consultant to be engaged in this assignment must have;

• A degree in Social Sciences, Statistics, BSc. degree in Public Health or Water Engineering from a recognized university with experience of at least 8 years in a similar discipline.
• Master degree in Development Studies, Monitoring and Evaluation, Social Sciences, Project Management, Public Health or WASH discipline is an added advantage.
• Experience of having conducted 3 similar assignments over the past 5 years .
• Strong background in statistics and data analysis of qualitative and quantitative methodology and use of mobile data collection tools (Kobo).
• Good communication and inter-personal skills.
• Previous work experience with NGOs in WASH and shelter interventions, especially in a humanitarian context.
• Excellent report writing in English and presentation skills.

1. Competencies

• Strong research and excellent writing skills in English
• High proficiency in the use of MS Word, SPSS, Excel and other analysis applications
• Excellent organizational skills
• Ability to meet deadlines and work under pressure
• Strong interpersonal skills

7. How to apply

Interested bidders shall prepare and submit technical and financial proposal as indicated in the guidelines below:

The consultant’s technical proposal shall contain the following:

• Clear understanding of the terms of reference including any relevant comments
• A clear methodology on how the consultant will undertake the assignment
• Work Plan with clear duties and responsibilities
• Summary of Consultant’s experience in undertaking assignments of similar scope and/or complexity (last 8 years)
• Consultants qualifications (include CVs of proposed consultant)
• Written commitment by the consultant affirming availability to conduct the entire assignment. (No substitution of interviewed consultants will be allowed once selected). The lead consultant will be expected to undertake the exercise in person.
• 2 sample reports from similar assignments conducted within the last 3 years
• Contact details of a minimum of 3 references from reputable organizations that the consultant has worked with over the past 5 years clearly indicating description of assignment, date/s of execution, name of organization and details of contact person (e-mail and telephone contact)

Note: The consultant’s technical proposal shall not exceed 10 pages. This excludes any annexes.

Financial Proposal

The consultant’s financial costing to undertake the assignment will be provided separately and should cover all costs associated with execution of the planned activities excluding travel expenses, and accommodation. The financial proposal shall be in Kenya Shillings.

The consultant will utilize the following budget template for their financial proposal:

Description

Unit

Qty

Rate (KSh)

Amount (KSh)

Consultants professional Fees

man-days

Communication costs

Other costs (indicate)

Taxes (indicate relevant tax) %

Total

Validity of Bid

Bidders shall clearly indicate that their bid is valid for a period of not less than 30 days from the date of submission.

Proposal Submission

The Technical Proposal shall be submitted comprising (a) Letter of submission duly signed by authorized bidder representative, (b) Main Technical Proposal document in PDF format, (c) Attachments to Technical Proposal in PDF (statutory requirements, CVs)

The Financial Proposal shall be submitted comprising (a) Financial Proposal Document duly signed by authorized bidder in PDF format and (b) Detailed calculations sheet in MS Excel format.

Interested candidates or organizations should submit electronic copies of technical and financial proposals with the e-mail clearly headed “Proposal for Consultancy to Conduct Data Analysis and Report Writing for Latrine Census for Kalobeyei integrated settlement and Kakuma Refugee Camp in Kenya” with the technical and financial proposal documents clearly labeled as ‘TECHNICAL PROPOSAL’ and ‘FINANCIAL PROPOSAL’ respectively.

Tagged as: Kenya, Peace Winds Japan