United Nations Development Programme (UNDP)
AI-Assisted Review and Streamlining of a Programme Metrics Workbook
Posted 19 Nov 2026 · Deadline 3 Dec 2026
United Nations Development Programme (UNDP)
Posted 19 Nov 2026 · Deadline 3 Dec 2026
Summary written with AI from the posting. Check the posting before you apply.
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.
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.
English, Level: Fluent, Required
Secondary education in Data science, computer science, statistics, information management, or another quantitative or technical discipline
- 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.
Data science, information management, Artificial Intelligence;Monitoring, evaluation;Knowledge management, research, reporting
United Nations Volunteers is an equal opportunity programme that welcomes applications from qualified professionals. We are committed to achieving diversity in terms of gender, care protected characteristics. As part of their adherence to the values of UNV, all UN Volunteers commit themselves to combat any form of discrimination, and to promoting respect for human rights and individual dignity, without distinction of a person’s race, sex, gender identity, religion, nationality, ethnic origin, sexual orientation, disability, pregnancy, age, language, social origin or other status.
Selected candidates for certain occupational groups may be subject to inoculation (vaccination) requirements, including against SARS-CoV-2 (Covid-19) in line with the applicable host entity policy
The United Nations does not charge any application, processing, training, interviewing, testing or other fee in connection with the application or recruitment process. Should you receive a solicitation for the payment of a fee, please disregard it. Furthermore, please note that emblems, logos, names and addresses are easily copied and reproduced. Therefore, you are advised to apply particular care when submitting personal information on the web.
Posted by United Nations Development Programme. See the original posting and apply.
This site shows the newest jobs. The free UN & NGO Jobs app finds the right ones for you and helps you apply well.