Consultant – Federation-wide financial data analysis and visualization Global Strategic Planning and Reporting Centre, New Delhi At International Federation of Red Cross And Red Crescent Societies

As part of the Global Strategic Planning and Reporting Centre in New Delhi and in close collaboration with the Federation-wide Data Systems team in Geneva, the purpose of the consultancy is to support the data analysis and visualization of Federation-wide financial data to be incorporated into external versions of the country unified plans and reports.

Key tasks and responsibilities

In reference to the preparation of 2023 annual reports being undertaken by the IFRC Global Strategic Planning and Reporting Centre, the consultant will be required to undertake the following complementary work:

1. Data consolidation: Extract key annual/semi-annual financial datasets from IFRC financial systems, and Country level National Society data collection forms and consolidate to provide a summary Federation-wide financial overview and analysis.
2. Data cleaning and quality assurance: Engage with regional and country IFRC colleagues to ensure that the quality and coverage of Federation-wide financial data is complete and accurate, incorporating all datasets from IFRC and National Societies.
3. Data analysis and visualization: Propose and prepare summaries and data visualizations to provide a clear financial overview, accurately managing and presenting overlaps in data, and identifying financial coverage and gaps.
4. Communication/Coordination: Liaise with colleagues within the IFRC secretariat in Geneva and in regional offices as needed and in particular with the Federation-wide Data Collection and Analysis Officer in Geneva.

Consultant specifications

• University degree/advanced degree in data science, information management, econometrics, or statistics required
• A good understanding of financial data and systems, with solid knowledge of reading and extracting data from financial reports for data analysis and visualization
• Candidate should ideally have a minimum of 7 years of experience
• Familiar with the Red Cross and Red Crescent network and/or international humanitarian and development work
• Familiar with IFRC financial systems an asset
• Required Technical Skills:
  • 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, particularly Power BI and Tableau
  • Previous experience in data extraction via the use of APIs is desirable;
• Preferred Technical skills:
  • 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
• Language skills: Excellent written and oral communication, organizational and presentation skills in English. Other IFRC languages (French, Spanish or Arabic) being an advantage.

Modalities for the consultancy

• The consultant will report to the IFRC Lead, Global Strategic Planning and Reporting Centre based in New Delhi, with a technical management line to the IFRC Manager, Federation-wide Data Systems, based in Geneva
• The time period foreseen is from 24 April for 2 months, with potential extension
• The initial number of working days will be 20 days during the overall contract period mentioned above.
• The consultancy will be carried out through a mix of presence in the IFRC office in New Delhi and remotely through digital communication means
• Payment will be made monthly as per number of days used or upon receipt of intermediary invoices by the consultant following completion of agreed deliverables