BI and Automation Intern

Application deadline
Place of work
32/F BDO Life Megaplaza, 358 Sen. Gil Puyat Ave., Makati City, Philippines
Contract
Internship

The Business Intelligence and Automation Intern within the Process Transformation and Continuous Improvement team supports the development and implementation of data-driven solutions, management reporting, dashboards, and process automation initiatives aimed at improving operational efficiency, data quality, and service delivery across Financial Shared Services.

The purpose of this internship is to provide technical and operational support to the Business Intelligence and Automation team in developing, maintaining, and improving dashboards, data analytics solutions, and automation initiatives. Under the guidance and supervision of the designated team members, the intern will assist in data preparation, report development, process analysis, testing, and documentation. The internship will also provide an opportunity to acquire practical, on-the-job knowledge and skills in business intelligence, data visualization, data transformation, workflow automation, and robotic process automation, while gaining exposure to financial processes and digital transformation initiatives within an international humanitarian organization. 

Main responsibilities

  • Assist the Business Intelligence and Automation team in developing, enhancing, and maintaining Power BI dashboards and reports, including data visualization, report formatting, and validation of reported information
  • Support data extraction, cleaning, transformation, and consolidation using Microsoft Excel, Power Query, and other available data tools
  • Assist in preparing, updating, and maintaining datasets, reporting templates, data models, and documentation to support management reporting and operational performance monitoring
  • Support the identification and documentation of repetitive, manual, and rule-based activities that may be suitable for simplification or automation
  • Assist in developing, testing, and documenting basic automation solutions using available tools such as Microsoft Power Automate, Excel VBA, Power Query, and UiPath, under the supervision of the team
  • Participate in testing and validating dashboards, data outputs, and automation solutions, including preparing test cases, recording issues, and documenting testing results
  • Assist in documenting business requirements, process flows, technical specifications, user instructions, and other supporting materials for BI and automation initiatives
  • Support the team in monitoring the performance and accuracy of existing dashboards and automation solutions, identifying anomalies, and reporting issues requiring further investigation
  • Assist in researching and exploring new digital tools, technologies, and practices in business intelligence, data analytics, and automation that may support the team's continuous improvement initiatives
  • Participate in selected BI, automation, and process improvement activities to gain practical exposure to the development lifecycle, from understanding business requirements and analyzing processes to solution development, testing, and handover

Selection requirements

  • Must be enrolled on his/her last year of University Program, preferably in Information Technology, Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Finance, or a related field.
  • Basic knowledge of Microsoft Excel, including formulas, data manipulation, and reporting.  
  • Familiarity with Power BI and Power Query would be an advantage.
  • Interest in data analytics, business intelligence, process automation, and digital transformation technologies.
  • Basic understanding of databases, data structures, programming, or data visualization concepts. Familiarity with SQL, Python, VBA, Power Automate, or UiPath would be an advantage.
  • Strong analytical and problem-solving skills, with good attention to detail and a commitment to data accuracy.
  • Good organizational, documentation, and communication skills, with the ability to explain technical information clearly.
  • Proactive, curious, and eager to learn new technologies, with the ability to work independently on assigned tasks while collaborating effectively with team members.
  • Respect for confidentiality, professionalism, and organizational policies, particularly regarding financial information, data protection, and information security.

What we offer

  • Diverse and humanitarian-minded workforce
  • An opportunity to contribute to institutional efforts to protect and assist conflict victims worldwide
  • Flexible work schedule 

How to apply

If this sounds like a good fit for you, kindly apply through Job Street and attach a copy of your updated and comprehensive resume along with your motivation letter.

Length of internship: Maximum of 3 months
Office Address: 32/F BDO Life Megaplaza, 358 Sen. Gil Puyat Ave., Makati City, Philippines 

Only shortlisted candidates will be notified. This vacancy is open for Philippine residents only.

About us

The International Committee of the Red Cross (ICRC) is a neutral, impartial and independent humanitarian organization that protects and assists people affected by armed conflict and other situations of violence around the world. It is present in over 100 countries, and its headquarters is in Geneva, Switzerland.

The ICRC's Manila Shared Services Center (MSSC), based in Makati City, Philippines, carries out a range of global functions, including reporting, financial, logistical, human resources and other services.