Direct from UNV careers
AI-Assisted Review and Streamlining of a Programme Metrics Workbook
Full job description
Host entity: UNDP Global Programme on Nature for Development
Areas of expertise: Data science, information management, Artificial Intelligence, Monitoring, evaluation, Knowledge management, research, reporting
Application deadline: 03/12/2026
Mission and objectives
UNDP brings the development agenda to biodiversity discourse, clearly articulating the roles of biodiversity and nature as part of global efforts to achieve sustainable development. This enables UNDP to engender increased public, business, and governmental support for biodiversity conservation, thereby broadening the support base and fomenting behavioural change on the part of stakeholders who are key to the systemic change that is necessary for achieving global biodiversity goals.
UNDP, with its large country-level nature portfolio - combined with its existing set of global projects linked to country level work - can connect people on the ground to national, regional and global decision makers and influencers, in addition to fostering exchange and learning between communities, landscapes, and governments.
The NBSAP Accelerator Partnership is a country-led global initiative aimed at accelerating the implementation of National Biodiversity Strategies and Action Plans (NBSAPs) aligned with the Kunming-Montreal Global Biodiversity Framework (GBF). This is done by providing coherent access to financial and technical support as a neutral broker, providing customized in-country/regional facilitation and cross-country learning, raising the political profile of NBSAPs, and promoting cross-sectoral and aligned nature-positive action.
Assignment context
The NBSAP Accelerator Partnership tracks country requests for technical and financial support in a digital platform. This data is imported into a Google Sheets workbook that calculates the figures used for donor reporting, public dashboards and internal analysis. As the partnership has grown, the workbook has accumulated legacy tabs, unused columns and formulas that depend on the position of columns. This makes the workbook harder to maintain and adapt. To this end, we are looking for one Online Volunteer to use AI tools to analyse the workbook's structure and formulas, and to design and test a streamlined version that produces identical results. This opportunity will give you a chance to contribute to a global biodiversity effort, gain experience in data architecture and spreadsheet design, and apply AI tools to a real analytical problem.
Task description
We are seeking an online volunteer to analyse and streamline the workbook. Working in a copy provided by the project team, the volunteer will be responsible for the following tasks:
1. Reviewing the current data streams
2. Mapping the workbook. The workbook currently contains 32 tabs: four tabs of imported data, 22 calculation and reporting tabs, four documentation tabs and two archived tabs.:
- how formulas depend on the imported data and on each other,
- tabs, columns and formulas that are unused or no longer needed, and
- documents and tools outside the workbook that draw on its data.
2. Proposing a streamlined structure that removes legacy elements and replaces column-position references with column-header references.
Proposed changes are to be sorted into two groups:
- changes that can be verified by testing, such as removing columns that feed no other formula and switching to column-header references, which may proceed without prior approval, and
- changes that require a decision by the project team, such as removing tabs that may still be in use, which are to be listed with supporting evidence for review.
3. Building the first group of changes, and any approved changes from the second group, in the copy, using AI tools to analyse, explain and rewrite formulas.
4. Reconciling results to confirm that every reporting figure in the streamlined copy matches the current workbook using the same data, and documenting and resolving any discrepancies.
5. Documenting the work, including a dependency map, a change log of what was removed, merged or rewritten and why, and a short maintenance guide for the new structure.
6. Attending meetings and training with the project team to discuss progress, exchange information and receive guidance.
AI tools are to be used in line with the data handling guidance provided by the project team at onboarding. The assignment runs from 1 December 2026 to 16 January 2027. Weekly hours may vary across the assignment by agreement with the project team. All deliverables are due by 16 January 2027 and will be reviewed at a handover meeting with the project team.
Skills and experience
- Strong logical reasoning, including the ability to follow how a calculation works step by step and judge whether it does what it is meant to.
- Hands-on experience using generative AI tools, through study, work or personal projects, to analyse, explain or write formulas or code.
- A systematic, methodical approach and strong attention to detail, particularly when checking that results match.
- Ability to document technical work clearly for non-technical colleagues.
- Strong ability to work independently and meet deadlines.
- Good communication skills and proficiency in English. Additional language skills a plus.
- Familiarity with Google Sheets is a plus.
- Undergraduate study in a quantitative or technical discipline is a plus.
- Familiarity with Google Apps Script or another scripting language (e.g. JavaScript, R, Python) is a plus.
- Interest in biodiversity or international development is a plus.
Full eligibility requirements, conditions of service and application instructions are available on the official UNV platform.
Listing sourced from UNV careers. Applications are handled entirely by the employer.