TERMS OF REFERENCE

Individual Consultant

Development of a Loan Portfolio & Beneficiary Reach Dashboard for the SAMIR Fund

Sanaag Agriculture, Markets and Innovation for Resilience Fund - SAMIR

Issuing organization

CARE International in Somalia/Somaliland

Programme

SPA II Extension - Accelerating new financing models for climate adaptation under COLISBR

Assignment location

Sanaag Region, Somaliland, with remote/hybrid delivery and field engagement as required

Contract type

Individual consultancy

Indicative duration

45 working days over approximately 9-10 calendar weeks

Reporting to

MEAL Manager with Technical Coordination from SAMIR Fund Programme Manager, Finance, Microdahab and relevant implementing partners

1.    Overview

CARE International in Somalia/Somaliland and CARE Denmark, with support from DANIDA, are implementing the SPA II Extension under the Community-Led Innovative Solutions for Building Resilience (COLISBR) programme. The extension focuses on accelerating new financing models for climate adaptation, with the SAMIR Fund as a key investment-readiness solution.

The SAMIR Fund (Sanaag Agriculture, Markets and Innovation for Resilience Fund) is a dedicated, community-anchored blended finance mechanism designed to address structural financing barriers faced by marginalized and climate-vulnerable communities in Somaliland, particularly in Sanaag Region. It builds on CARE's earlier revolving loan fund pilot and applies a blended finance approach that combines grants, revolving loans, credit guarantees and other de-risking instruments to improve access to climate-smart agricultural technologies and enterprise finance.

The Fund targets groups that are often excluded from formal finance, including smallholder farmers, agro-pastoral households, internally displaced persons, women, youth, pastoralists who have lost productive assets, VSLAs, farmer cooperatives, producer groups and emerging rural or peri-urban enterprises. It is expected to support adoption of technologies such as drip irrigation, solar-powered water systems, drought-resilient inputs, small-scale processing equipment and other productive investments that contribute to climate adaptation, income diversification, food security and reduced pressure over scarce natural resources.

As the SAMIR Fund moves from pilot and pre-scaling into a more structured investment-readiness phase, CARE requires a practical, reliable and regularly updated dashboard that can track fund capitalization, loan uptake, repayment performance, portfolio risk, beneficiary reach, inclusion outcomes and investment-readiness indicators. The dashboard should not be a one-off visualization product; it should be a simple management and decision-support system that can be maintained by MEAL, programme and finance staff after handover.

Required Qualifications and Experience Essential qualifications

·         Bachelor's degree or higher in data science, information systems, computer science, software engineering, statistics, economics, business analytics or a related field.

·         At least seven years of demonstrated experience designing and deploying dashboards, data visualization products, MIS tools or decision-support systems.

·         Proven experience working with the mainstream dashboard platform of as Power BI.

·         Strong experience with data modelling, dashboard indicator design, data cleaning, validation rules, user-centred design and documentation.

·         Ability to design tools that work in low-bandwidth, field-based or offline-capable environments.

·         Ability to explain technical issues to non-technical users and train programme staff to maintain the system.

·         Experience working with NGOs, humanitarian organizations, development programmes, climate adaptation initiatives or financial inclusion programmes in Somalia/Somaliland or the wider Horn of Africa.

·         Familiarity with microfinance, revolving loan funds, portfolio-at-risk calculations, repayment tracking, blended finance, guarantees or investment-readiness reporting.

·         Experience integrating dashboards with KoboToolbox, ODK, CommCare, Excel, Google Sheets, mobile-money data or financial tracking spreadsheets.

·         Experience designing gender- and inclusion-sensitive data systems with sex, age, displacement, disability and livelihood disaggregation.

·         Knowledge of MEAL standards, data protection principles and donor reporting requirements is an advantage.

Submission Information / How to Apply

Bidders must download the request for proposal (RFP) attached along with the ToR and complete all required information including attachments where necessary

Please send your complete RFP, technical and financial proposals (Please note that No ZIP Files) to this email address [email protected] clearly marking the subject line “Development of a Loan Portfolio & Beneficiary Reach Dashboard for the SAMIR Fund .” no later than 18th July 2026 11:59 PM.