Skip to Job Description

AI-Assisted Review and Streamlining of a Programme Metrics Workbook

New
Closes 3 Dec 2026 EST (UTC-5)
Employers can close earlier.
Duty station conditions
Click any item for more detail.
Apply Now
Posted 2 minutes ago
Job Description

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

Advertisement
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.

Competencies and values

Living conditions and remarks

{{waiting}}
This position is no longer open.
Before you apply

We review listings for quality, but organizations may update or amend a posting at any time, so confirm the role and closing date on the organization’s official site before applying. No genuine employer charges a fee to apply, interview, or process an application — treat any request for payment as a scam. If a detail looks wrong or the posting seems fraudulent, report this job.

Advertisement