Functional Quality Assurance and Data Migration Officer

The Functional Quality Assurance and Data Migration Officer is responsible for ensuring the quality and integrity of data migration and functional testing within the Protection Digital Ecosystem. The role supports data cleaning, mapping, transformation, loading, reconciliation, and testing to ensure the digital ecosystem meets user and program needs.

Responsibilities

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

Requirements

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

Skills

• SQL
• Data Analysis
• Statistical Methods
• Functional Testing
• Data Migration
• Data Cleaning
• Data Mapping
• Data Transformation
• Data loading
• Data reconciliation
• Quality Assurance
• Business Process Analysis
• MS Excel
• MS Word
• Scientific Problem Solving
• Stakeholder Engagement

Languages

English