AI-Assisted Programme Metrics Workbook Review Volunteer
Job details and profile match
Overview
The UNDP Global Programme on Nature for Development seeks an online volunteer to simplify a programme metrics workbook. The volunteer maps data and formula dependencies, identifies unused elements, uses AI to implement approved changes and verifies that reporting figures remain identical, then documents the revised structure and maintenance approach with the project team.
Keywords:
- Generative AI Tools
- Spreadsheet design
- Data Architecture
- Google Sheets
- Column-header references
- Dependency map
Key details
- Job ID
- 1784888021274158
- Job type
- Volunteer · Part-time
- Function
- Data, AI & Analytics
- Sector
- Climate, Environment & Biodiversity
Skills & Tools
Job Description
AI-Assisted Review and Streamlining of a Programme Metrics Workbook
Attention! Please note that this is an Online Volunteering assignment. It's a short-term, task-based and non-contractual remote assignment; Online Volunteers are not UN Volunteers and do not receive any allowance or entitlements as part of the Online Volunteer assignment but receive a certificate of appreciation after successful completion. In addition, UNV is not involved in the selection process or collaboration.
Host entity: UNDP Global Programme on Nature for Development
Advertisement end date: 2026-12-03T00:00:00
General
Description of assignment title: AI-Assisted Review and Streamlining of a Programme Metrics Workbook
Assignment country: United States of America
Duration: 49 days
Sustainable Development Goal: 15. Life on land
Modality: Online
Work schedule: 6 - 10 hours per week
For how many hours per week will the volunteer be required?: 6 - 10 hours per week
Number of Assignments: 1
Details
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.
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 type
Data analysis
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:
- Reviewing the current data streams
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Assignment requirements
Relevant experience: No experience required
Languages: English, Level: Fluent, Required
Required education level: Secondary education Data science, computer science, statistics, information management, or another quantitative or technical discipline
Area(s) of expertise: Data science, information management, Artificial Intelligence, Monitoring, evaluation, Knowledge management, research, reporting
Driving license: -
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.