About this role
<div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>What we do</b></H2> </div><div><p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">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.</span></p> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Purpose</b></H2> </div><div><p><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">The Data BI Reporting Analyst is an expert on Power BI and data visualization, and on digitalization and automation of finance and accounting processes.</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">She/he will develop interactive dashboards and process automation to support FSS business users.</span></p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Accountabilities & functional responsibilities</b></H2> </div><div><p> </p> <ul> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Define and develop interactive Power BI dashboards for business reporting needs</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Troubleshoot, maintain, and support in-house created BI dashboards for business users. Do revision on these reports if needed</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Develop Power Apps tools and Power Automate workflows for digitalizing and automating FSS processes</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">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</span></li> <li>C<span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">reate user guides for all Power BI reports and Power Apps developed</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Train business users on the use of Power BI desktop and Fabric, Power Apps, VBA Macro, SQL, Power Query, Power Automate, etc.</span></li> </ul> <p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt"><strong>Robotics Process Automation (RPA)</strong></span></p> <ul> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Build, test, and deploy RPA bots using appropriate tools to streamline operations.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Identify repetitive, rule-based business processes suitable for automation and design efficient RPA workflows.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Ensure RPA solutions integrate seamlessly with Power BI, Power Apps, Power Automate, and VBA macros.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Oversee bot performance, troubleshoot issues, and implement updates or enhancements as needed.</span></li> </ul> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Our values</b></H2> </div><div><p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">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 <a href="https://careers.icrc.org/content/Our-Values/?locale=en_GB " target="_blank" rel="noopener">page.</a></span></p> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Reports to (role)</b></H2> </div><div><p> </p> <ul> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Data BI and Automation Team Lead</span></li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>People management responsibilities</b></H2> </div><div><p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">No</span></p> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Scope & impact</b></H2> </div><div><p> </p> <ul> <li style="font-family:arial, helvetica, sans-serif;font-size:14.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Remit: multiple countries, global.</span></li> </ul> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Relationships</b></H2> </div><div><p> </p> <ul> <li style="font-family:arial, helvetica, sans-serif;font-size:14.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Internally, interacts within metier, with end-users, ICT and other units or departments in HQ and FD</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:14.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Externally, may interact with organizations that provide external data, in coordination with DTD_DATA</span></li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Certifications / Education required</b></H2> </div><div><p> </p> <ul> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">University degree or equivalent.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Strong working knowledge of BI, SQL, statistical packages, </span><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Power BI.</span></li> </ul> <p> </p> <p> </p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:18.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Professional experience required</b></H2> </div><div><p> </p> <ul> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">At least 5 years working experience in IT related to data warehouse and business intelligence support.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">At least two years working experience in Robotics Process Automation (RPA)</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Strong working knowledge in large relational databases and SQL programming. Good knowledge in MS SQL is an advantage.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Strong working knowledge in developing Power Apps tools, VBA Macro, and Power Automate workflows for digitalizing and automating</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Extensive experience in analytic and interactive dashboards is a must.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Business Analysis experience an asset.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Excellent oral and written command of English.</span></li> <li><span style="font-family:arial, helvetica, sans-serif;font-size:14.0pt">Must be open to work in Makati City.</span></li> </ul></div></div></div>