Business Intelligence Reporting Analyst (Tableau) At International Committee of the Red Cross

PURPOSE

The Data BI Reporting Analyst is an expert on Tableau and data visualization and has very good knowledge of other reporting tools. She/he will develop interactive dashboards and support FAD business users. She/he reports directly to FAD_APPLIC Head in Manila in collaboration with FAD CORP/DAC unit in Geneva.

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 CIM_CORP_TRAK

MAIN TASKS

Development

• Define and help to develop interactive dashboards for business reporting needs in Tableau
• Interfaces with users to determine needs, uses and specifications of data requests and conducts detailed analysis of data requirements
• Troubleshoot / support in-house created BI dashboards for business users. Do revision on these reports if needed
• Create proper documentation for all Tableau reports developed
• May train business users on the use of Tableau desktop
• Develop and automate end-user Excel applications and reports, including requirements verification, design reviews, development and testing, and thoroughly documenting application solutions and processes

Data Quality

• Assists in improving, developing & applying data quality monitoring processes & tools (dashboards etc) and contributes where appropriate in DQ controls automation.
• Monitors data quality controls and consolidates, cleans and implements corrective actions.

Data Analytics

• Create and recommend new reports and key performance indicators for management
• Ensures the coherence of data with field reports, particularly for institutional reporting.

Data Support

• Ensures continuity and smooth transition of data entered into various system applications.
• Contributes to the development of the data model and usage of the referential data that supports analysis.
• Contributes to the definition of the overall testing strategy for the Information Systems. Executes testing of data, reporting and analytical reports

Additional Duties

• Respect and observe the staff regulations of the ICRC in Philippines
• Participate to MSSC general meetings
• The employee may be required to work overtime in line with the needs of the department/metier

SELECTION REQUIREMENTS

• Bachelor’s degree in science major in Mathematics, Computer Science / Information Technology or equivalent
• At least 5 years working experience in IT related to data warehouse and business intelligence support
• Knowledge in analytic and interactive dashboards is a must
• Experience in Data Visualization using Tableau
• Experience in large relational databases and SQL programming. Good knowledge in MS SQL is an advantage.
• Advanced knowledge in MS Excel/Access based in VBA development is an advantage.
• Exposure in various business management software or ERP software (e.g. SAP, MS Dynamics, Oracle, Infor).
• Knowledge of JD Edwards EnterpriseOne is a plus.
• Exposure to automation tools, such as Blue Prism, UiPath, Automation Anywhere in an advantage
• Knowledge in SharePoint is an added advantage
• Excellent verbal and written communication skills in English

WHAT WE OFFER

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