Senior Data Consolidation Associate (G7)

Job Description

Introduction

Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.

IOM is committed to ensuring a workplace where all employees can thrive professionally, while working towards harnessing the full potential of migration. Read more about IOM's workplace culture at IOM workplace culture | International Organization for Migration.

Applications are welcome from first- and second-tier candidates. For all IOM vacancies, applications from qualified and eligible first-tier candidates are considered before those of qualified and eligible second-tier candidates in the selection process.

Second tier candidates include:

All external candidates.

Context

The Displacement Tracking Matrix (DTM) gathers and analyses data to disseminate critical multi-layered information on the mobility, vulnerabilities, and needs of displaced and mobile populations that enables decision makers and responders to provide these populations with better context specific assistance.

The DTM Support Team, based in headquarters, assembles expertise in operations and coordination, methodology and concept development, mapping and Geographic Information Systems (GIS), statistical analysis, database and application system development, and data and information management. The support team has been critical in providing remote and onsite support to DTM field implementation. 

Under the overall supervision of the Global DTM Coordinator and direct supervision of the Senior DTM Coordination Officer, the incumbent will be responsible and accountable for supporting the activities and services provided by DTM support team in headquarters for DTM implementation in the field worldwide, in particular to support development and implementation of supplementary and interoperable systems for quality assurance and further improvement of global DTM data and analysis.

Responsibilities

Responsibilities and Accountabilities

1. Support global DTM data management across 100 plus country operations. Apply standards, support compliance, and contribute to resolving structural issues before publication.
2. Support the DTM Central Data Warehouse end to end. Contribute to ingestion processes, validation rules, consolidation logic, versioning, and historical consistency across regions and years.
3. Support the global DTM Application Programming Interface (API) workstream. Coordinate data exposure, schema alignment, access rules, refresh cycles, and quality controls for internal and external users.
4. Support DTM data transformation into Microsoft Fabric. Contribute to development of pipelines, structures Lakehouse assets, and maintain consistency between legacy Structured Query Language (SQL) outputs and Fabric datasets.
5. Contribute to scalable data architectures. Support phased migrations, contribute to defining milestones, and assist with addressing technical risks during platform transitions.
6. Provide technical support to colleagues within the data consolidation workflow, including reviewing data outputs and sharing technical approaches when required.
7. Support development and review of complex SQL logic for humanitarian indicators, including proportional allocation, rounding integrity, multiyear reconciliation, and treatment of edge cases.
8. Contribute to maintaining global data dictionaries and metadata standards. Support alignment of indicators, variables, and methodologies across countries, tools, and partners.
9. Respond to specific queries about data collected by DTM field operations based on data consolidated and other available databases.
10. Perform other duties as assigned.

Qualifications

Required Qualifications and Experience

Education

• University degree in Information Management, Computer Science, Engineering, Analytics or a related field from an accredited academic institution with five years of relevant professional experience; or,

• High school diploma with seven years of relevant experience.

  Accredited Universities are those listed in the UNESCO World Higher Education Database.

Experience

• Experience in working in multi-technical teams with Data Engineers, Data Scientists, Geo-spatial professionals and Information Management Officers; and,
• Experience in developing data workflows serving clear business requirements.

Skills

• Excellent communication skills: capable to share ideas and explain results to all levels of the Organization and stakeholders;
• Advanced skills with extensive professional experience in SQL, Python and MS Fabric;
• Experience in developing AP pipelines; and,
• Advanced level of data modelling and mobile data collection tools.

Languages

All staff members in all categories are required to be fluent in one of the IOM’s official languages (English, French, and Spanish).

For this position, fluency in English and French is required (oral and written).

Working knowledge of Spanish and another official UN language (Arabic, Chinese, and Russian) is an advantage.

Proficiency of language(s) required will be specifically evaluated during the selection process, which may include written and/or oral assessments. 

Competencies

IOM’s competency framework can be found at this link. Competencies will be assessed during the selection process.

VALUES - All IOM staff members must abide by and demonstrate these five values:

• Inclusion and respect for diversity: Respects and promotes individual and cultural differences. Encourages diversity and inclusion.
• Integrity and transparency: Maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.
• Professionalism: Demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.
• Courage: Demonstrates willingness to take a stand on issues of importance.
• Empathy: Shows compassion for others, makes people feel safe, respected and fairly treated.

CORE COMPETENCIES - Behavioural indicators – Level 2

• Teamwork: Develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.
• Delivering results: Produces and delivers quality results in a service-oriented and timely manner. Is action oriented and committed to achieving agreed outcomes.
• Managing and sharing knowledge: Continuously seeks to learn, share knowledge and innovate. 
• Accountability: Takes ownership for achieving the Organization’s priorities and assumes responsibility for own actions and delegated work.

• Communication: Encourages and contributes to clear and open communication. Explains complex matters in an informative, inspiring and motivational way.
  
  Notes

• Any offer made to the candidate in relation to this vacancy notice is subject to funding confirmation.
• This vacancy is only open to current and former IOM staff members who were separated in the last 12 months due to the structural adjustment process.

• This selection process may be used to staff similar positions in various duty stations.  Recommended candidates endorsed by the Appointments and Postings Board will remain eligible to be appointed in a similar position for a period of 24 months.

• Only candidates possessing the right of residence and right to work in Switzerland can be considered for this vacancy. Candidates for this vacancy will be considered to be locally recruited and will be eligible for allowances and benefits available to locally-recruited staff.
• Appointment will be subject to certification that the candidate is medically fit for appointment, accreditation, any residency or visa requirements, security clearances. Subject to certain exemptions, vaccination against COVID-19 will in principle be required for individuals hired on or after 15 November 2021. This will be verified as part of the medical clearance process.
• Vacancies close at 23:59 local time Geneva, Switzerland on the respective closing date. No late applications will be accepted.
• IOM has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and IOM, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination based on gender, nationality, age, race, sexual orientation, religious or ethnic background or disabilities.
• IOM does not charge a fee at any stage of its recruitment process (application, interview, processing, training or other fee). IOM does not request any information related to bank accounts.
• IOM only accepts duly completed applications submitted through the IOM e-Recruitment system (for internal candidates link here). The online tool also allows candidates to track the status of their application.
• Only shortlisted candidates will be contacted.
• For further information and other job postings, you are welcome to visit our website: IOM Careers and Job Vacancies 

Required Skills

Job info