The Assignment
LaMP is seeking a project consultant to build a financial model for a labor mobility project between Colombia and Spain. The model will show how workers’ migration costs are financed through income share agreements (ISAs) or loans, and how those costs are repaid. Our goal is a long-term relationship with a consultant who can pitch in on LaMP projects as needs arise; this project is the first.
Scope of Work
The consultant will design and build a portfolio model for 5 to 50 borrowers financed through an ISA or a loan. The model should show repayment dynamics for each borrower and IRR at the portfolio level.
Deliverables
A first version of the financial model (Excel) with a clear assumptions tab and dynamic scenario planning tools, plus a short methodology note (2–3 pages)
A walkthrough and Q&A session for the LaMP team to review the model
A revised version of the model incorporating LaMP’s feedback
Ongoing support at an hourly rate after delivery, as needed
Bachelor’s degree in finance, economics, business, or a related field, or equivalent professional experience
Proven experience building financial models (cash flow, scenario analysis, IRR)
Experience with income share agreements and student or microfinance lending
Experience building models with multiple currencies
Ability to explain model and scenario analysis functionalities clearly to non-specialists
A modeler who knows what every cell of their spreadsheet is doing and stands behind the formulas (use of AI is not prohibited, but it may not take the place of a firm understanding of how every cell is related to the others)
Working knowledge of Spanish is a plus
Location: Remote
Duration: First project November–December 2026, with potential for ongoing project-based work
Compensation: Hourly or daily rate, based on the applicant’s proposal
How to Apply
Submit your CV and a short cover letter through the SmartRecruiters portal. Please include your daily and hourly rates, an estimate of the hours this project would take, and references from clients you have built financial models for. Address the cover letter to Kim Geronimo, Associate Director over Global Programs. Applications are reviewed on a rolling basis, and a decision will be made in the first half of November 2026.