|
Quotation are invited for Data Analyst- Food System Challenge Closing Date: Monday, 24. Feb 2025 Intervention Sector(s): Training & Capacity Building Remuneration range: 1000 to 2000 (USD) Duration of Contract: N/A Context & Background Berytech is a leading organization in the Entrepreneurial Ecosystem in Lebanon, that aims to provide a conducive environment for the creation and development of startups, through incubation, business support, counseling, funding, networking, and company hosting, hence taking part in the economic revival of the country, participating in wealth and job creation, and retaining graduates and high-level skills in Lebanon. About FSC PROJECT The Food System Challenge supports businesses to solve core challenges of the food system in Lebanon, and more specifically in the sectors of dairy and meat production (cow, goat, sheep), cereals and pulses (and its by-products), protected horticulture (Classical green houses, hydroponics, and aquaponics), and domesticated edible herbs and plants. The Food System Challenge is implemented by the World Food Programme (WFP) and Berytech through support from the German Federal Ministry of Economic Cooperation and Development (BMZ). Throughout FSCs previous and current cycles, the program supported over 40 SMEs to fortify the Lebanese food system to create a more sustainable ecosystem. The program aims to address challenges faced by SMEs and their supply chains, particularly farmers and small producers, who are critical to ensure food security and economic stability. By understanding the challenges, attitudes, and needs of these farmers and small producers, the program seeks to develop targeted interventions that enhance production capacities, reduce costs, and support them in overcoming the ongoing economic crisis without resorting to negative coping mechanisms. To achieve this, a survey was conducted with up to 180 farmers and small producers who supply SMEs supported by the FSC program. The survey aimed to gather insights into: Challenges faced by farmers and small producers in dealing with SMEs, including issues related to pricing, payment delays, quality standards, and market access. Attitudes and agricultural practices of farmers and small producers, including their willingness to adopt new technologies, sustainable practices, and collaboration with SMEs. Technical and financial needs of farmers and small producers, such as access to affordable inputs, training, credit facilities, and infrastructure improvements. Other relevant information, including the impact of the economic crisis on their livelihoods, their ability to meet demand, and their perceptions of the FSC program. The findings of this survey will be used by Berytech and the World Food Programme (WFP) to design and implement interventions that support farmers and small producers, ensuring their sustainability and resilience in the face of economic challenges. Specifically, the insights will help: Improve production capacities and reduce costs for farmers and small producers. Address gaps in technical and financial support to enhance their productivity and profitability. Develop strategies to help them survive the economic crisis without abandoning the sector or resorting to negative coping activities. Strengthen the relationship between farmers, small producers, and SMEs to create a more resilient and sustainable food system. Objective The primary objective of this assignment is to engage a Data Analyst to analyze the survey data, identify key insights, and draft a comprehensive report that highlights the challenges, needs, and opportunities for farmers and small producers supplying FSC-supported SMEs. The report will serve as a critical input for Berytech and World Food Programme (WFP) to design targeted interventions.Scope of work: The Data Analyst will be responsible for the following tasks:1. Data Coordination and Validation Coordinate with the FSC team responsible for collecting the survey data to ensure timely and accurate data delivery. Review the collected data to identify any missing or incomplete information and request additional data if necessary. Provide feedback on the data collection system, including its efficiency, accuracy, and areas for improvement. 2. Data Analysis Clean and preprocess the survey data to ensure its readiness for analysis. Conduct descriptive and inferential statistical analyses to identify trends, patterns, and key insights. Analyze the challenges faced by farmers in dealing with SMEs, their attitudes, agricultural practices, and technical and financial needs. Identify correlations and relationships between different variables (e.g., challenges, needs, and production capacities). 3. Report Drafting Prepare a comprehensive report that includes: o Executive summary. o Methodology and data sources. o Key findings and insights from the survey. o Recommendations for interventions to address the identified challenges and needs. o Visualizations (charts, graphs, and tables) to present data effectively. Ensure the report is clear, concise, and tailored to the needs of Berytech and WFP. 4. Presentation of Findings Present the findings and recommendations to the FSC team, Berytech, and WFP in a clear and engaging manner. Address any questions or feedback from stakeholders and incorporate necessary revisions into the final report. DurationThe assignment is expected to be completed within 4 weeks from the start date. The timeline for deliverables will be as follows: Week 1: Data coordination, validation, and cleaning. Week 2-3: Data analysis and drafting of the report. Week 4: Finalization of the report and presentation of findings. Key DeliverablesThe Data Analyst is expected to deliver the following: Cleaned and Processed Dataset: A finalized dataset ready for analysis using Excel and data visualization tool. Detailed Work Plan: A comprehensive report detailing the survey findings, insights, and recommendations. Final Report: An updated report incorporating feedback from stakeholders. Presentation: A PowerPoint presentation summarizing the key findings and recommendations. Qualifications: The ideal candidate should possess the following qualifications: A degree in Statistics, Economics, Agriculture, Agribusiness or a related field. Proven experience (minimum 3 years) in data analysis, survey data processing and report writing, particularly in the agriculture or food security sectors. Experience working with datasets related to farmers, small producers, or agricultural supply chains, including familiarity with challenges such as pricing, market access, and production costs. Strong proficiency in statistical software and data visualization tools. Excellent communication and presentation skills, with the ability to translate complex data into clear, actionable insights for non-technical stakeholders. Familiarity with the challenges faced by farmers and small producers in the context of economic crises, particularly in developing or crisis-affected regions, is an asset. Evaluation Criteria: The award will be made to a responsible offeror whose offer follows the RFP instructions, meets the eligibility requirements, and is determined via a trade-off analysis to be the best value based on application of the following evaluation criteria. The relative importance of each individual criterion is indicated by the number of points below: Cost: 30 points Technical Expertise and understanding of the context: 25 points Proposed Methodology: 20 points Past Experience: 15 points Communication Skills: 5 points Administrative Compliance: 5 points Follow-up discussions may be conducted with several Consultant(s) to resolve any questions, finalize the scope of work and agreement on final not-to-exceed costs as a means to recommend final selection to Berytech. Please note that if there are significant deficiencies regarding responsiveness to the requirements of this RFP, an offer may be deemed non-responsive and thereby disqualified from consideration. Berytech reserves the right to waive immaterial deficiencies at its discretion. Best-offer quotations are requested. It is anticipated that award will be made solely on the basis of these original quotations. However, Berytech reserves the right to conduct any of the following: Berytech may conduct negotiations with and/or request clarifications from any offeror prior to award. While preference will be given to offerors who can address the full technical requirements of this RFP, Berytech may issue a partial award or split the award among various suppliers, if in the best interest of The Food System Challenge project. Berytech may cancel this RFP at any time. Reporting and Coordination The Data Analyst will report to the FSC Program Manager and work closely with the FSC team, Berytech, and World Food Programme (WFP). Regular updates and coordination will be required to ensure alignment with program objectives. Additionally, and if necessary, the consultant could consult with the SME beneficiaries of the program to validate the findings and ensure the report reflects the realities of their supply chains in addition to the surveyed farmers and small producers to provide feedback on the findings and ensure their perspectives are accurately represented. How to apply The selected candidate is expected to start his/her activities soon after selection; the exact timeline and effective working days are to be set after the final selection based on the program requirement and the consultants availability. The total budget allocated for the intervention is Between 1000 and 2000 USD. Candidates should submit the following documents separately: Technical (maximum two pages) describing the methodology to conduct the work based on the content suggested in the section: Scope of Work, Duration, an Tender Link : https://daleel-madani.org/civil-society-directory/berytech/calls/rfq-00034-call-data-analyst-food-system-challenge
|
