DTM Data Validation Support Consultant (Geneva)
I. ORGANIZATIONAL CONTEXT AND SCOPE
Established in 1951, IOM is the leading inter-governmental organization in the field of migration and 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.
The Displacement Tracking Matrix (DTM) has been IOM’s main operational tool for tracking and monitoring the movements and evolving needs of displaced populations since 2004. It has been systematically deployed in medium to large-scale humanitarian response operations in the last four years, including in all Level 3 emergencies. As of the end of 2015, DTM was active in 22 countries, tracking and monitoring over 14 million IDPs.
The DTM Support Team, based in headquarters, assembles expertise in operations and coordination, methodology and concept development, mapping and Geographic Information Systems, 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. The team provides a full range of support from the initial development and setup to continuous support on operations, staff deployment, data management, mapping, database systems, and development of information products. At the global level, the team is also striving to enhance the DTM by working on a multitude of initiatives exploring further integration of innovative technologies, improving capacity building components, and designing more streamlined processes.
Under the overall supervision of the Global DTM Coordinator and direct supervision of the Senior DTM Coordination Manager, the incumbent will be responsible for assisting the global Data Management activities in the cleaning, refinement and quality assurance of databases as of the Displacement Tracking Matrix (DTM). In particular he/she will:
II. RESPONSIBILITIES AND ACCOUNTABILITIES
- Support in the implementation of a quality assurance system based on compilation of best practices for data quality control as implemented by DTM offices worldwide and global guidance.
- Conduct spot checking and auditing on existing databases and address the findings for corrections, corrective actions and preventative actions.
- Provide technical support to IOM HQ and field missions in the collection and tabulation of DTM data and other information management activities (such as improvement of Central Data Warehouse, editing survey templates and data processing).
- Assist in the drafting and validation of standard operating procedures for DTM data collection and management.
- Create stored procedures in SQL Server for consolidating DTM data at the country, regional and global levels.
- Contribute to the implementation of data governance and data protection mechanisms in DTM exercises
- Develop and improve Kobo forms for survey templates, making sure the forms are in line with DTM data dictionaries.
-
Prepare tabulations for technical reports, information bulletins and other relevant information products related to displacement-affected populations and migration flows (such as statistical analysis and interpretation of results of site assessment, return intention surveys, flow monitoring surveys)
-
Querying and disseminating databases in displacement.iom.int and migration.iom.int as required by the operation/project managers and policy analysts.
-
Perform other duties as may be assigned.
- Required advanced proficiency of SQL Server.
- Valued proficiency in using two or more of the following tools: XLSforms for ODK and Kobo, Access, Python, Stata, R.
- Of particular value is experience in the development, refinement and implementation of population database systems (such as registrations, census or surveys).
- Knowledge of BI platforms (such as PowerBI or Tableau) is a plus.
IV. EDUCATION AND EXPERIENCE
University degree in Computer Science, Demographics, Statistics or an Information Management related-discipline, or alternatively, an equivalent combination of related education and professional experience. Excellent knowledge of databases management, querying, quality assurance and control systems.
V. LANGUAGES
Required
Proficiency in English.
Advantageous
Knowledge of French, Spanish and/or Arabic.
