BI Reporting Analyst

Enable accurate and scalable reporting through data transformation and dashboard creation.

This opening is not available anymore. Do not try to apply for this job.

ICRC - International Committee of the Red Cross

Open positions at ICRC
Logo of ICRC

Overview

Enable accurate and scalable reporting through data transformation and dashboard creation.

You have:

  • Bachelor’s degree in IT, Computer Science, Statistics, Business Analytics, or related field
  • 4+ years’ experience in BI, reporting, or data analysis
  • Strong proficiency in Microsoft Power BI (data modeling, DAX, dashboard development)
  • Experience with Microsoft Power Platform (Power Apps, Power Automate) is an advantage
  • Proficient in SQL and working with relational databases (e.g., SQL Server, Azure)
  • Advanced Excel skills (Power Query, pivot tables, data analysis functions)
  • Strong analytical skills with high attention to detail
  • Ability to translate business requirements into clear, actionable reports
  • Good written and verbal communication skills in English
  • Experience in shared services or corporate functions is a plus

Contract

This is a ICRC - Open-ended contract. More about ICRC - Open-ended contracts.

What we do

The International Committee of the Red Cross (ICRC) works worldwide to provide protection and humanitarian assistance to people affected by conflict and armed violence. We take action in response to emergencies and, at the same time, promote respect for international humanitarian law. We are an independent and neutral organization, and our mandate stems essentially from the Geneva Conventions of 1949. We work closely with National Red Cross and Red Crescent Societies and with their International Federation in order to ensure a concerted, rational and rapid humanitarian response to the needs of the victims of armed conflict or any other situation of internal violence. We direct and coordinate the international activities conducted in these situations.

Context

The Global Shared Services, HR Shared Services (GSS HRSS) is a unit based in Global Hub – Manila, operating under the Support and Digital Transformation (SDT) of the ICRC.

GSS HRSS provides a wide range of HR services to support ICRC’s operations in deploying its workforce to the field & headquarters and in accompanying their administrative journey in the organization. It is comprised of different services for employees under Swiss contract, such as Deployment, Rewards, Payroll, Personal & Profession Information (PPI) administration, Staff Health Support Services (SHSS), and Offboarding. GSS HRSS also extends its services to the entire workforce of the ICRC through iDevelop request processing, and to the employees under resident contracts for the administration of their International Retirement and Savings Plan (IRSP).

Purpose

The Business Transformation Team (BTT) of GSS HRSS drives innovation in business projects and solutions and effectively oversee new processes, improvements, and transformations.

Within the BTT, the BI Reporting Analyst enables accurate, timely, and scalable reporting by transforming approved business and quality metrics into reliable dashboards and insights. The role supports data-driven decision-making by ensuring reporting data is consistent, automated, and easily accessible to stakeholders, without owning KPI definition or quality governance.

Accountabilities & functional responsibilities

  • Design, build, and maintain BI reports and dashboards based on approved business and quality metrics defined by stakeholders
  • Translate documented reporting requirements into scalable data models and visualizations
  • Write, optimize, and maintain SQL queries to extract and transform data from enterprise systems
  • Ensure data accuracy, consistency, and timeliness of reporting outputs through validation and reconciliation checks
  • Automate recurring reports and dashboard refreshes to improve reporting efficiency and reliability
  • Maintain standardized definitions, calculations, and documentation for reporting metrics and data sources
  • Provide descriptive and diagnostic analysis to support business and quality reporting needs
  • Partner with Quality Assurance and business teams to enable reporting
  • Support stakeholders with data access, report interpretation, and ad-hoc reporting requests
  • Continuously improve reporting performance, usability, and scalability within BI platforms

Additional Duties

  • Follows up on all work-related messages and correspondence with the relevant contacts and departments
  • Takes responsibility for their own professional learning and development
  • Participate in projects
  • If necessary and upon request, provide ad hoc administrative tasks for the unit or department
  • Being proactive with continuous improvement propositions for the team’s management processes

Desired profile and skills

  • Bachelor’s degree in IT, Computer Science, Statistics, Business Analytics, or related field
  • 4+ years’ experience in BI, reporting, or data analysis
  • Strong proficiency in Microsoft Power BI (data modeling, DAX, dashboard development)
  • Experience with Microsoft Power Platform (Power Apps, Power Automate) is an advantage
  • Proficient in SQL and working with relational databases (e.g., SQL Server, Azure)
  • Advanced Excel skills (Power Query, pivot tables, data analysis functions)
  • Strong analytical skills with high attention to detail
  • Ability to translate business requirements into clear, actionable reports
  • Good written and verbal communication skills in English
  • Experience in shared services or corporate functions is a plus

Our values

  • At the ICRC, we value impact, collaboration, respect, and compassion. We seek candidates who demonstrate behaviors based on these shared values. For more information on the ICRC values, please visit this page.

Potential interview questions

Can you describe a time when you had to design a BI report from scratch? This question assesses your experience in BI reporting and problem-solving skills. Discuss the context, process you followed, tools you used, and the outcome.
How do you ensure data accuracy and consistency in your reports? This question evaluates your attention to detail and quality assurance practices. Pro members can see the explanation.
What strategies do you use to optimize SQL queries? Pro members can see the explanation. Pro members can see the explanation.
Describe a situation where you had to collaborate with stakeholders for a reporting project. Pro members can see the explanation. Pro members can see the explanation.
Can you give an example of how you automated a reporting process? Pro members can see the explanation. Pro members can see the explanation.
Tell us about your experience with Microsoft Power BI and its functionalities. Pro members can see the explanation. Pro members can see the explanation.
How do you handle conflicting priorities when working on multiple reporting requests? Pro members can see the explanation. Pro members can see the explanation.
What do you think is the most important consideration when building a dashboard? Pro members can see the explanation. Pro members can see the explanation.
Added 4 months ago - Updated 3 months ago - Source: careers.icrc.org