BI Reporting Analyst

Develop interactive dashboards and automate FSS processes.

ICRC - International Committee of the Red Cross

Open positions at ICRC

Manila (Philippines)

Show advice for this position

Open application form

Overview

Develop interactive dashboards and automate FSS processes.

You have:

University degree or equivalent.
At least 5 years working experience in IT related to data warehouse and business intelligence support.
At least two years working experience in Robotics Process Automation (RPA).
Strong working knowledge in large relational databases and SQL programming. Good knowledge in MS SQL is an advantage.
Strong working knowledge in developing Power Apps tools, VBA Macro, and Power Automate workflows for digitalizing and automating.
Extensive experience in analytic and interactive dashboards is a must.
Excellent oral and written command of English.

Contract

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

Don’t wait for the right job to appear. Build the connections that create opportunities.

Colleagues.org

Details

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.

Purpose

The Data BI Reporting Analyst is an expert on Power BI and data visualization, and on digitalization and automation of finance and accounting processes.

She/he will develop interactive dashboards and process automation to support FSS business users.

Accountabilities & functional responsibilities

Define and develop interactive Power BI dashboards for business reporting needs
Troubleshoot, maintain, and support in-house created BI dashboards for business users. Do revision on these reports if needed
Develop Power Apps tools and Power Automate workflows for digitalizing and automating FSS processes
Develop and automate end-user Excel applications and reports (VBA), including requirements verification, design reviews, development and testing, and thoroughly documenting application solutions and processes
Create user guides for all Power BI reports and Power Apps developed
Train business users on the use of Power BI desktop and Fabric, Power Apps, VBA Macro, SQL, Power Query, Power Automate, etc.

Robotics Process Automation (RPA)

Build, test, and deploy RPA bots using appropriate tools to streamline operations.
Identify repetitive, rule-based business processes suitable for automation and design efficient RPA workflows.
Ensure RPA solutions integrate seamlessly with Power BI, Power Apps, Power Automate, and VBA macros.
Oversee bot performance, troubleshoot issues, and implement updates or enhancements as needed.

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.

Reports to (role)

Data BI and Automation Team Lead

People management responsibilities

Scope & impact

Remit: multiple countries, global.

Relationships

Internally, interacts within metier, with end-users, ICT and other units or departments in HQ and FD
Externally, may interact with organizations that provide external data, in coordination with DTD_DATA

Certifications / Education required

University degree or equivalent.
Strong working knowledge of BI, SQL, statistical packages, Power BI.

Professional experience required

At least 5 years working experience in IT related to data warehouse and business intelligence support.
At least two years working experience in Robotics Process Automation (RPA)
Strong working knowledge in large relational databases and SQL programming. Good knowledge in MS SQL is an advantage.
Strong working knowledge in developing Power Apps tools, VBA Macro, and Power Automate workflows for digitalizing and automating
Extensive experience in analytic and interactive dashboards is a must.
Business Analysis experience an asset.
Excellent oral and written command of English.
Must be open to work in Makati City.

Apply now

Potential interview questions

Can you explain your experience using Power BI for dashboard development?	To assess the candidate's proficiency in Power BI and dashboard creation.	Provide specific examples of dashboards created and the impact they had on decision-making.
Describe a challenging RPA project you led and the outcome.	To evaluate the candidate's RPA experience and problem-solving skills.	Pro members can see the explanation.
How do you ensure the accuracy and reliability of your BI reports?	Pro members can see the explanation.	Pro members can see the explanation.
What methods do you use to identify processes suitable for automation?	Pro members can see the explanation.	Pro members can see the explanation.
How do you handle troubleshooting and maintaining existing BI reports?	Pro members can see the explanation.	Pro members can see the explanation.
What tools do you integrate with Power BI in your data analysis work?	Pro members can see the explanation.	Pro members can see the explanation.
Describe how you train users to utilize BI tools effectively.	Pro members can see the explanation.	Pro members can see the explanation.
Can you provide an example of how your analytical skills improved business decisions?	Pro members can see the explanation.	Pro members can see the explanation.