Background:
UN Women, grounded in the vision of equality enshrined in the Charter of the United Nations, works for the elimination of discrimination against women and girls; the empowerment of women; and the achievement of equality between women and men as partners and beneficiaries of development, human rights, humanitarian action and peace and security.
Transparency and accountability are central to UN Women’s mandate and credibility. As a longstanding member of the International Aid Transparency Initiative (IATI), UN Women is committed to publishing high-quality, timely, and comprehensive data on its activities, results, and resources. Performance in global transparency assessments, particularly the IATI transparency score, is a key indicator of the organization’s openness, data quality, and compliance with international reporting standards. Maintaining and improving this score is critical for strengthening partner trust, enabling evidence-based decision-making, and demonstrating accountability to stakeholders and the public.
In 2022, UN Women launched its Transparency Portal (https://open.unwomen.org/en), which complements its IATI reporting by providing accessible, user-friendly data on its programmes and financials.
As part of its ongoing efforts to strengthen data systems and reporting, UN Women is developing its next-generation ERP system, PRISM. This transition presents a critical opportunity to improve data structures, enhance data quality, and fully automate data flows to IATI and the Transparency Portal. Ensuring alignment with IATI standards and safeguarding data integrity throughout this process will be essential to maintaining and improving UN Women’s transparency performance.
UN Women therefore seeks a Data Consultant to support this transition. The consultant will work within the Strategic Planning Unit (SPU) and collaborate closely with Information Systems and Technology (IST), the Transparency Portal vendor, and IATI stakeholders. The consultant will report to the Data Analysis and Monitoring Specialist (SPU/SPRED).
Description of Responsibilities/ Scope of Work:
The objective of the consultancy is to support the transition to the new data architecture by aligning IATI and Transparency Portal requirements with Phase IV standards, ensuring high-quality data preparation, and enabling the automation of data flows from the new system to external reporting platforms.
Key responsibilities include:
- Review and assess the new data structure to ensure alignment with IATI standards and Transparency Portal Phase IV requirements, with particular attention to data points affecting the IATI transparency score
- Identify data gaps, inconsistencies and required transformations that may impact data completeness, timeliness and accuracy in IATI reporting
- Extract, clean, validate and prepare datasets for IATI and Transparency Portal reporting, ensuring compliance with IATI data quality requirements and conducting manual work where needed
- Develop and document data transformation, validation and quality assurance processes to improve consistency and reliability of published data
- Manage the design and implementation of data workflows within the new data model and data warehouse, ensuring traceability and auditability of data
- Collaborate with technical teams to establish and optimize automated data pipelines from PRISM to IATI and the Transparency Portal, minimizing manual intervention and risks to data quality
- Contribute to defining data standards, metadata structures and business rules aligned with IATI requirements and transparency best practices
- Perform systematic quality assurance checks on data outputs, including validation against IATI performance and transparency score criteria
- Develop an analysis of IATI reporting outputs and identify opportunities to improve data coverage, timeliness and usability
- Provide troubleshooting during the transition from manual to automated processes, ensuring no disruption to reporting quality
- Engage with internal stakeholders to promote data quality standards and strengthen institutional capacity for transparency reporting
Outputs:
- Data structure review report outlining alignment of the new system with IATI standards and Transparency Portal Phase IV requirements, including identified gaps and recommendations
- Cleaned and prepared datasets ready for publication to IATI and the Transparency Portal, including documentation of manual interventions applied
- Data transformation and validation documentation, detailing processes, rules and standards used for data preparation
- Automated data flow framework, including workflows, scripts and configurations for data transfer from the new system to IATI and the Transparency Portal
- Quality assurance reports validating data accuracy, completeness and compliance with required standards and IATI criteria
- Technical documentation and handover materials, including data pipeline scripts, mapping logic and operational guidelines to strengthen ongoing automation, performance and maintenance
Competencies :
Core Values:
- Integrity;
- Professionalism;
- Respect for Diversity.
Core Competencies:
- Awareness and Sensitivity Regarding Gender Issues;
- Accountability;
- Creative Problem Solving;
- Effective Communication;
- Inclusive Collaboration;
- Stakeholder Engagement;
- Leading by Example.
Please visit this link for more information on UN Women’s Values and Competencies Framework:
Functional Competencies:
- Excellent analytical skills, with the ability to structure and integrate data from multiple sources in line with defined standards (e.g., IATI)
- Strong skills in data cleaning, validation and quality assurance
- Understanding of data models, data warehousing and automated data pipelines
- Attention to detail and commitment to data accuracy and compliance
- Excellent analytical skills, strong attention to detail, and ability to work independently in a fast-paced, evolving environment
- Excellent English communication skills, with the ability to document processes and explain technical data processes to non-technical stakeholders
- Strong planning, prioritization and organizational skills
Required Qualifications:
Education and Certification:
- Master’s degree in data science, information systems, statistics, computer science or a related field
- A first-level university degree in combination with two additional years of qualifying experience may be accepted in lieu of the advanced university degree
Experience:
- At least 5 years of progressively responsible experience in data management, data engineering, data analytics or related areas
- Proven experience working with data extraction, cleaning, transformation and validation processes, including handling complex and structured datasets
- Experience with data modeling, data warehousing, and supporting system/data architecture transitions
- Strong programming skills in SQL and at least one language such as Python or R for data processing and automation
- Experience in designing or supporting automated data pipelines processes
- Familiarity with international data standards (preferably IATI) and experience preparing data for external reporting platforms is highly desirable
- Experience working with data visualization tools (e.g., Power BI) for validation and reporting purposes is an asset
- Experience working with cloud-based data platforms (e.g., Microsoft Azure or similar environments) is an advantage
- Experience in international development, transparency or reporting systems is an advantage
Languages:
- Fluency in English is required.
- Knowledge of French or Spanish or any other UN official language is an asset.
Statements :
In July 2010, the United Nations General Assembly created UN Women, the United Nations Entity for Gender Equality and the Empowerment of Women. The creation of UN Women came about as part of the UN reform agenda, bringing together resources and mandates for greater impact. It merges and builds on the important work of four previously distinct parts of the UN system (DAW, OSAGI, INSTRAW and UNIFEM), which focused exclusively on gender equality and women's empowerment.
Diversity and inclusion:
At UN Women, we are committed to creating a diverse and inclusive environment of mutual respect. UN Women recruits, employs, trains, compensates, and promotes regardless of race, religion, color, sex, gender identity, sexual orientation, age, ability, national origin, or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, competence, integrity and organizational need.
If you need any reasonable accommodation to support your participation in the recruitment and selection process, please include this information in your application.
UN Women has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UN Women, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. All selected candidates will be expected to adhere to UN Women’s policies and procedures and the standards of conduct expected of UN Women personnel and will therefore undergo rigorous reference and background checks. (Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check.)
Note: Applicants must ensure that all sections of the application form, including the sections on education and employment history, are completed. If all sections are not completed the application may be disqualified from the recruitment and selection process.