BI Reporting Analyst

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

No

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.