Federation-wide Data Systems

<!–

Description

–>

• Data management systems and environments: Design and maintain data management systems and data pipelines to ensure key Federation-wide data collection and monitoring processes are aligned and further analysis of patterns, trends, and relationships is possible.
• Data collection, cleaning and quality assurance: Engage with regional and NS colleagues to ensure that the quality and coverage of Federation-wide data collection is improving and meeting the targets established. Provide guidance and support on key performance indicator definitions and data collection standards. Develop and maintain standard operating procedures and data validation process to ensure data quality before its publication.
• Data analysis, visualization, and storytelling: Propose and prepare regular analysis reports based on various Federation-wide datasets as well secondary datasets to analyse historical data and come up with forecasts and models subject to testing and refining.
• Everyone Counts report: Support the development of the Everyone Counts report, published every other year, for deep/thematic analysis of data collected via the FDRS and other Federation-wide data systems. Contribute to the data analysis and visualization, solicit content and stories, and support drafting, editing, and layout.
• Communication/Coordination: Liaise with colleagues within the IFRC secretariat in Geneva and in regional offices to validate National Society data and information. Monitor the [email protected] email account and action/ direct queries in timely manner. Respond to any other Federation-wide data related queries. 

• Actively work towards the achievement of the Federation Secretariat’s goals.
• Abide by and work in accordance with the Red Cross and Red Crescent principles.
• Perform any other work related duties and responsibilities that may be assigned by the line manager.

• Be currently-enrolled in a university or equivalent level, or have graduated recently (normally within 1 year from the date of hiring) in an area that is compatible with the IFRC activities.
• An advanced university degree in applied data science, information management, econometrics, or statistics.

• Fluently spoken and written English.
• Highly developed research, reporting and analytical skills.
• Familiar with the Red Cross and Red Crescent network and/or international humanitarian and development work.
• Proficiency in querying and manipulating raw datasets for analysis using Power Query (M) / Tableau Prep Builder, SQL, Python, or R.
• Proven experience with data visualization tools (e.g., Power BI, Tableau, Looker).
• Previous experience in data extraction via the use of APIs.

• Good command of another IFRC official language (French, Spanish or Arabic).
• Ability to develop and maintain Kobo/ODK Forms (xls forms).
• Understanding of database structures, ETL development and automation.
• Experience using Python, DAX, R, or Stata (scripting, analysis, and/or development) and collaborative platform (GitHub, Gitlab).
• Advanced Experience with Microsoft Power Platform.

<!—

<!–

–>