Independent platform: UNAtlas aggregates publicly available United Nations job openings and is not affiliated with the UN. All applications happen on official websites.
UNVUNDP Global Programme on Nature for DevelopmentRemote / Home-based
Job opening

AI-Assisted Review and Streamlining of a Programme Metrics Workbook

LevelUNV
LocationUnited States of America
Application period04/12/2026 00:00
Work arrangementRemote / Home-based

Organizational Context

The United Nations Development Programme (UNDP) integrates the development agenda with biodiversity discourse, advocating for nature's role in achieving sustainable development. The NBSAP Accelerator Partnership, a country-led global initiative, supports the implementation of National Biodiversity Strategies and Action Plans (NBSAPs) aligned with the Kunming-Montreal Global Biodiversity Framework. It provides financial and technical support, facilitates cross-country learning, and promotes nature-positive actions to foster systemic change necessary for global biodiversity goals.

Job Purpose

This online volunteer assignment focuses on streamlining a critical Google Sheets workbook used by the NBSAP Accelerator Partnership for tracking country requests for technical and financial support. The workbook is essential for donor reporting, public dashboards, and internal analysis but has become complex due to accumulated legacy data and inefficient formula structures. The volunteer will leverage AI tools to analyze the workbook's current state, design and implement a more efficient structure, and ensure the streamlined version produces identical results to the original. This role offers a chance to contribute to global biodiversity efforts, gain experience in data architecture and spreadsheet design, and apply AI to a practical analytical challenge.

Responsibilities

The online volunteer will analyze and streamline the NBSAP Accelerator Partnership's Google Sheets workbook. Key tasks include reviewing current data streams and mapping the workbook's structure, including formula dependencies, unused elements, and external data connections across its 32 tabs. The volunteer will propose a streamlined structure, removing legacy elements and replacing positional formula references with header references. Changes will be categorized into those verifiable by testing and those requiring project team approval. The volunteer will implement approved changes using AI tools to analyze and rewrite formulas, reconcile results to ensure accuracy, and document the process with a dependency map, change log, and maintenance guide. Regular communication and collaboration with the project team are expected.

Work Experience

Required experience includes strong logical reasoning for analyzing calculations step-by-step, hands-on experience with generative AI tools for formula/code analysis, and a systematic, methodical approach with attention to detail. The ability to clearly document technical work for non-technical audiences and work independently to meet deadlines is also necessary. Familiarity with Google Apps Script or other scripting languages is advantageous.

Skills

Key skills include data science, information management, Artificial Intelligence, monitoring and evaluation, knowledge management, research, and reporting. Strong logical reasoning, proficiency in using AI tools for formula analysis, meticulous attention to detail, clear documentation abilities, independent work ethic, and good communication skills in English are essential. Familiarity with Google Sheets and scripting languages is beneficial.

Community intelligence

What candidates and members are discussing

Be the first to add context around this opportunity.Ask something practical or share experience with this organization. Contributions can help future candidates long after the vacancy closes.
Keep exploring

Related opportunities

AI-Assisted Review and Streamlining of a Programme Metrics Workbook (UNV) – UNV in United States of America | UN Atlas