Reports To : Senior Director, Financial Planning & Analytics
Job Type : Full-time, exempt
Region : Central America & Mexico United States
Location : Costa Rica (San Jose or remote) or United States (Cambridge, MA or remote)
Start Date : Immediate
Contact : Please apply directly through Root Capital’s career site
The Financial Data Analyst will play a key role on the Financial Planning & Analytics (FP&A) team, with the opportunity to work on financial forecasting, analysis, and reporting projects influencing the operations and strategies of Root Capital’s lending program and global operations.
The Financial Data Analyst will contribute to key modeling, analysis, and reports that are crucial to Root Capital’s overall financial position and the success of our impact-first mission.
Note : All applications for this role must include a cover letter.
Mission & History of Root Capital
Root Capital is a nonprofit whose mission is to grow rural prosperity and build the resilience of farming families around the world.
We support the growth of agricultural enterprises so they can transform rural communities. These businesses purchase crops such as coffee, cocoa, or grains from smallholder farmers.
With growth, they become engines of impact that can raise incomes, create jobs for the next generation of leaders, level the playing field for women, and take urgent action against climate change.
We supply these businesses with vital credit and capacity building to foster their growth and resilience. We work in hard-to-serve communities where others don’t.
To date, we’ve distributed $1.6 billion to improve the lives of over 10 million people in farming families. Headquartered in Cambridge, Massachusetts, Root Capital currently has associated offices in Costa Rica, Mexico, Nicaragua, Colombia, Peru, Ghana, and Kenya.
Financial and Programmatic Analysis and Reporting (30%)
Drive institutional understanding of Root Capital’s programmatic and financial performance by developing and producing regular periodic reports and customized analyses for donors, investors, and internal audiences, including senior management and the Board of Directors.
Increase accessibility, usability, and efficiency of existing reports by developing new data interfaces and dashboards through reporting and visualization platforms such as Tableau, PowerBI, and other data visualization packages.
Prepare sections of the Monthly Performance Dashboard, Board presentations, Quarterly Performance Reports, and other reports as requested.
Support development of customized financial and lending projections and analysis for existing and prospective supporters and partners, working with FP&A, Development, and Lending staff as necessary.
Lending Planning and Projections (25%)
As a key participant in the semiannual forecasting process to project future lending activity, work with FP&A and Lending staff to model the growth and dynamics of Root Capital’s lending program.
Report on and analyze projected lending performance at the global, regional, sector, and / or client level, evaluating the projections for consistency with Root Capital’s global and regional lending strategies.
Identify and present key insights to internal audiences as appropriate.
Key contributor to presentations for internal executives and to select board committees.
Lending Model Development, Maintenance, and Enhancement (25%)
Root Capital’s Adaptive Planning-based Lending Model is used for reporting on and projecting Root’s lending program activity and revenue and for evaluating potential financial outcomes of management decisions and external events.
The Financial Data Analyst will be responsible for model maintenance, updates, and data quality, including :
Leading ongoing Lending Model development and updates, including monthly data imports, troubleshooting and enhancing existing lending model accounts and data import scripts, and identifying the need for third-party support as appropriate.
Identifying and documenting irreconcilable divergences with agreed-upon sources of truth, creating changes in the model integration process and accounts as necessary to ensure close fidelity with primary sources of data.
Ongoing documentation of Lending model procedures, structure, and enhancements.
Portfolio Risk Projections and Modelling (10%)
Contribute to development of periodic risk projections including provisioning expense and recoveries estimates in conjunction with FP&A staff, the Chief Credit Officer, and regional lending and risk management teams.
Share responsibility for Excel-based Risk Model, used at underwriting to evaluate a loan’s risk profile and determine alignment with Root Capital’s risk appetite.
Other Projects & Ad-Hoc Analysis (10%)
Projects and reporting may span departments and will likely include analytics-based work requested by, and / or executed in conjunction with, colleagues from departments including Risk, Lending, Advisory, Impact, Treasury, and Accounting.
Other relevant duties as assigned.
Skills and Experience
Bachelor’s degree in a quantitatively-oriented field (Economics, Operations Research, Mathematics, Engineering, Statistics, Data Science, etc.)
Minimum of 2 years of professional experience required in data analysis or another analytically-oriented field
Demonstrated interest in international development, nonprofit operations, and environmental sustainability
Strong attention to detail and commitment to high data quality & accuracy
Advanced proficiency in Microsoft Excel
Experience working with Adaptive Planning or other financial reporting and data analysis information systems highly preferred (experience with other relational databases an acceptable substitute)
Experience with data visualization applications (Tableau,