Data Consultant; IATI and Transparency Portal), Home Based, International Consultant

Background

UN Women 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.

UN Women is developing its next-generation ERP system, PRISM. This transition presents a critical opportunity to improve data structures, enhance data quality, and automate data flows to IATI and the Transparency Portal. The Data Consultant will support this transition, ensuring alignment with IATI standards, safeguarding data integrity, and improving transparency performance. The consultant will work within the Strategic Planning Unit (SPU), collaborate with Information Systems and Technology (IST), the Transparency Portal vendor, and IATI stakeholders, and report to the Data Analysis and Monitoring Specialist (SPU/SPRED).

• Review and assess the new data structure to ensure alignment with IATI standards and Transparency Portal Phase IV requirements.
• 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, complying with IATI data quality requirements.
• 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.
• 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.

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

• 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
• Functional Competencies
  • Excellent analytical skills, structured data integration, and quality assurance.
  • 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 English communication skills, able to document processes and explain technical details to non‑technical stakeholders.
  • Strong planning, prioritization and organizational skills.

Education and Certification

• Master’s degree in data science, information systems, statistics, computer science or a related field.
• A first‑level university degree combined with two additional years of qualifying experience may be accepted in lieu of the advanced degree.

Experience

• At least 5 years of progressively responsible experience in data management, data engineering, data analytics, or related areas.
• Proven experience with data extraction, cleaning, transformation and validation processes on complex structured datasets.
• Experience with data modeling, data warehousing and 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 designing or supporting automated data pipeline processes.
• Familiarity with international data standards (preferably IATI) and experience preparing data for external reporting platforms.
• Experience with data…