International Consultant on development of a UN Country Analysis Dashboard in Power BI

Result of ServiceBased on the information received from UN RCO in Turkmenistan and following the guidelines, the Consultant shall be tasked to accomplish the following expected deliverables: 1. Revised design of the UN Country Analysis Dashboard. 2. Prototyped Power BI UN Country Analysis Dashboard. 3. Validated UN Country Analysis Dashboard launched. 4. Presented UN Country Analysis Dashboard and prepared its User Manual. Work LocationAshgabat, Turkmenistan Expected durationOctober-Dec 2025 Duties and ResponsibilitiesThe United Nations Country Analysis (UNCA) provides a comprehensive, evidence-based foundation for the UN’s engagement in Turkmenistan by identifying sustainable development challenges, risks, and opportunities. The UN 2.0 Agenda of the UN Secretary General and the new generation of UN guidance stress the need for real-time, integrated, and digital monitoring, leveraging data visualization for strategic decision-making and SDG acceleration. UN 2.0 centers on mainstreaming five mutually reinforcing capabilities – the “quintet of change” – across all UN activities: Data (systematic use of quality data for evidence-based decisions), Digital (adoption of inclusive digital solutions), Foresight (regular strategic anticipation of risks and trends), Innovation (embedding experimentation and co-creation), and Behavioral Science (applying behavioral insights for more effective, equitable, and sustainable results). The upcoming Turkmenistan UNSDCF (2026–2030) and prioritized SDG transitions require new tools to strengthen accountability, enable root cause analysis for leaving no one behind (LNOB), and support UNSDCF midterm review and evaluation. The new generation UN Country Analysis (UNCA) calls for strengthening anticipatory, forward-looking analysis and the institutionalization of foresight capabilities. The UN RCO is now looking to contract an individual for developing a UN Country Analysis Dashboard in Power BI. A digital dashboard will consolidate multiple information streams, track progress, and inform adaptive programming for the UN Country Team (UNCT), Government, and partners. The consultant will deliver a short-term assignment (20 working days), structured in the following tasks: Task 1. Review draft Design and Development of the Dashboard • Revise draft design of the dashboard and collected data provided by RCO • Develop the dashboard enabling the following modules not representing the full scope of possible content: • Country overview: Key facts, demographic data, international rankings, SPECA cross-country comparisons. • SDG Progress: National and international SDG scorecards, progress trackers for prioritized SDG transitions reflecting SDG interlinkages. • UNSDCF Results Tracking: Visualization UNSDCF theory of change, outcomes/outputs indicators, baseline, target values, and progress for UN joint workplans, highlighting horizon scanning signals and joint programming areas. • Multidimensional SDG Risks: Risks mapping using the Multidimensional Risk Analysis (MDRA) approach, DRR indicators, including thematic, geographic, and cross-sectoral risks. • UN HR mechanisms: Status visualization for ratification and implementation of UN Human Rights treaties and conventions. • LNOB/ Causality Analysis: Dynamic visuals showing causal pathways, bottlenecks, and barriers to progress for vulnerable groups, leveraging visuals and methods from causality analyses. Task 2. Integrate Data and add technical features • Automate data ingestion where feasible (UNSDCF indicators, SDG data, risk assessments etc). • Establish protocols for updating the dashboard in line with UNCA and UNSDCF reporting cycles. • Integrate additional technical features (such as searchable data repository for indicators, drilldown functionality by region, SDG, and population group (LNOB focus), export options for key data and visuals, user-friendly navigation and summary dashboards, resource page with links). Task 3. Validate and launch UN Country Analysis Dashboard. • Organize a session with the UN RCO, UNCA Task Force, MEL Group to validate the dashboard’s structure, prioritization logic, and end-user needs. • Revise and launch validated UN Country Analysis Dashboard. Task 4. Present the Dashboard and develop maintenance documents • Develop a user manual with data entry, update protocols, and dashboard interpretation guidance. • Deliver a brief orientation for UN RCO and MEL staff on introducing updates and changes. • Deliver a presentation for the UNCA Task Force, MEL Group, UN RCO, RG groups members on dashboard use. Qualifications/special skillsA first-level university degree (Bachelor Degree) in the field of Statistics, Economics, or Social Science is required. Minimum 5 years of professional experience in data analysis, survey data generation, SDG monitoring, UNCA processes, and UNSDCF frameworks is required. Proven experience in Power BI dashboard design and development for international organizations or government partners is required. Experience visualizing policy, root cause, or causality analyses using complex, multidimensional data is required. Prior exposure to multi-agency UN environments and working with national partners in Central Asia is desirable. LanguagesFluency in English and Russian is required. Additional InformationThe consultant will work home-based. No FeeTHE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.