International Federation of Red Cross and Red Crescent Societies
Consultant - Federation-wide financial data analysis and visualization Global St
International Federation of Red Cross and Red Crescent Societies, Atlanta, Georgia, United States, 30383
```htmlJob PurposeAs 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.
Job Duties and ResponsibilitiesIn 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:
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.
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.
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.
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.
EducationUniversity degree/advanced degree in data science, information management, econometrics, or statistics required.
ExperienceCandidate should ideally have a minimum of 7 years of relevant experience.
Knowledge, Skills and Languages
• A good understanding of financial data and systems, with solid knowledge of reading and extracting data from financial reports for data analysis and visualization
• 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 platforms (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.
Competencies, Values and Comments
Core competencies:
Communications, Collaboration & Teamwork, Judgement & Decision, National Society & Customer Relations, Creativity & Innovation, Building Trust.
Values:
Respect for Diversity, Integrity, Professionalism, Accountability
The consultancy will be carried out through a mix of presence in the IFRC office in New Delhi and remotely through digital communication means.
Application InstructionsApplications should be sent to the below contact persons and contain:
A short motivation letter justifying suitability of skills, information on level of availability (typical average number of days per month, blocked periods, other constraints), and indicating the daily consultancy fee range (in Indian Rupees)
A Curriculum Vitae with specific references if relevant to previous IFRC network/Red Cross Red Crescent experience (employment and/or consultancies)
```#J-18808-Ljbffr
Job Duties and ResponsibilitiesIn 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:
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.
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.
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.
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.
EducationUniversity degree/advanced degree in data science, information management, econometrics, or statistics required.
ExperienceCandidate should ideally have a minimum of 7 years of relevant experience.
Knowledge, Skills and Languages
• A good understanding of financial data and systems, with solid knowledge of reading and extracting data from financial reports for data analysis and visualization
• 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 platforms (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.
Competencies, Values and Comments
Core competencies:
Communications, Collaboration & Teamwork, Judgement & Decision, National Society & Customer Relations, Creativity & Innovation, Building Trust.
Values:
Respect for Diversity, Integrity, Professionalism, Accountability
The consultancy will be carried out through a mix of presence in the IFRC office in New Delhi and remotely through digital communication means.
Application InstructionsApplications should be sent to the below contact persons and contain:
A short motivation letter justifying suitability of skills, information on level of availability (typical average number of days per month, blocked periods, other constraints), and indicating the daily consultancy fee range (in Indian Rupees)
A Curriculum Vitae with specific references if relevant to previous IFRC network/Red Cross Red Crescent experience (employment and/or consultancies)
```#J-18808-Ljbffr