Data Quality Specialist

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 Data Quality Specialist is a technical and quality specialist for the Protection Digital Ecosystem. They are responsible for creating reports, structured and quality data sets, and may contribute to preparing and cleaning data which will be used in Data Migrations. They are a part of the Level 3 support for Data Managers/ Regional Data Managers in the field, as well as the National Red Cross and Red Crescent Society teams (NS) that are part of the Family Links Network. They create quality checks and data visualization, and assist in producing and validating yearly and mid-term statistics. They review existing reports and optimize and suggest new data controls that respect the confidentiality of sensitive data. Accountabilities & Functional Responsibilities Data Quality and Reporting Assists in improving, developing & applying data quality monitoring processes & tools (reports, dashboards etc) and contributes where appropriate in data quality controls automation. Applies best practices, standards, guidelines and templates for data and analytics, and works on continuous improvement and optimization of reporting and analytics. Contributes to preparation, adaptation and execution of data cleaning jobs to correct identified global or delegation-specific inconsistencies. Supports colleagues in National Societies, in the PROT Data unit, as well in other parts of the PROT unit in general, in building SQL queries and designing reports. Executes controls in the process of validation of yearly and mid-term statistics. Produces and updates documentation relating to data quality and quality controls. Data Visualization Creates structured, high quality and ready to use data sets on a recurring and ad hoc basis to enable evidence-based decision-making or use of data in daily activities. Regularly updates existing dashboards and supports the Protection Division to adapt existing dashboards to their needs. Reviews and optimizes all existing reports and dashboards in the Protection digital tools/solutions. Platforms Management Supports the delivery of new solutions and enhancements for existing solutions and Platforms’ setups. Tests new technologies, as the evolution of the tools progresses, and participates in the development with regular contributions. Reports bugs & problems, suggests improvements and shares lessons learned to the Project Manager/Product Owner.

Certifications and Education Required Advanced university 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 must Excellent computer literacy (MS Word, Excel) Storytelling ability through visually clear reports and dashboards, both dynamic and static 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 data visualization, with a strong preference for Power BI Interest in data, methodologies and passion of bringing it to use for ICRC work 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