Functional Quality Assurance and Data Migration Officer

Purpose The Protection & CTA Division aims to protect people affected by war and armed conflict by advocating for their rights under the Geneva Conventions and providing life-saving assistance at all stages of hostilities. It also strives to minimize the vulnerabilities of people at risk and ensure that those involved in the fighting comply with their obligations under international humanitarian law. To support its programs across the globe, it relies on its ability to translate data into usable insights to better respond to the needs of the people affected. The Functional Quality Assurance and Data Migration Officer is a technical quality specialist for the Protection Digital Ecosystem and other digital solutions managed by the Protection Data team, with a focus on Data Migration and Quality Assurance. They are responsible for preparing data through global and delegation-specific data cleaning, mapping, and data transformation. At the same time, they are responsible for data loading, reconciliation, data integrity, and post-migration validations. They are also responsible for executing the functional quality and operational tests from a user and business perspective, as well as proposing and executing test automation, all related to the new Protection digital ecosystem. Simply put, the position is responsible to support the Functional Quality Assurance & Testing Officer based in Geneva, in ensuring that the new digital ecosystem works the way users and protection programs expect it to work, i.e. whether it is practical, functional and fit for Protection’s use and purpose - not on the underlying technical code or infrastructure. Accountabilities & Functional Responsibilities Data Migration Contributes to the implementation of the data migration strategy. Assists in analysing and mapping existing data structures to the Protection Digital Ecosystem requirements. Conducts analysis to identify global or delegation-specific inconsistencies in data that require cleaning. Prepares, adapts and executes data cleaning jobs to correct identified global or delegation-specific inconsistencies. Supports loads and imports data into the Protection Digital Ecosystem. Performs data quality and migration testing to validate the accuracy, completeness, and integrity of data and the outcome of the data migration on test and production. Participates and contributes to the improvement of data migration scripts; reports identified bugs and problems. Supports parallel running of both systems during the transition period and documents the migration process and outcomes. Quality Assurance and Testing Follows functional testing strategy, planning, schedules, dependencies and milestones and supports their improvement. Directly conducts functional testing of the Protection digital ecosystem, including prototype and configuration testing, component and functional testing, workflow and end-to-end testing, integration and interface testing, role, access and permission testing, regression testing, usability testing, user acceptance testing (UAT) and pilot testing. Clearly reports feedback. Suggests improvements and test automatization if possible and appropriate. Supports functional testing coordination, onboarding, preparation, provision of guidance, test scenarios, instructions, training as well as consolidation and analysis of feedback from testers to provide a coherent view of functional testing outcomes. Assists in issues, results and test reporting, with activities such as regular documentation and testing issues/results classification to maintain an evidence base to support functional acceptance and deployment decisions. Assists in functional readiness and continuous improvement by documenting and highlighting outstanding issues, gaps and risks and suggesting improvements.

Certifications and Education Required Bachelor’s degree preferably in Mathematics, Engineering, Computer Science, Statistics, or a similar technical field Knowledge and use of SQL (any flavour: MS SQL-TSQL, MySQL, PostgreSQL) is a strong asset Excellent computer literacy (MS Word, Excel) Fluent in English (both written and spoken); knowledge of French and Spanish is an asset Professional Experience Required At least 2 to 4 years of proven experience in a relevant field Experience in data analysis, statistical methods, and functional testing is a strong asset Interest in data, methodologies and passion of bringing it to use for ICRC work Ability to understand new business processes and their interplay with software and organizational structure Ability to adapt to varying workloads and to work under pressure with very short deadlines in a constrained technological environment Well-organized, meticulous, creative and open-minded with a scientific approach to solving problems. Team player with strong verbal and written communication skills, particularly with multicultural stakeholders Ability to interact effectively with data managers, data users, managers, and other stakeholders