Data Analyst, Finance (SQL and PowerBI)

TP ICAP; Manila; On-site; PHP 700,000 - 1,200,000; Full time

Job summary

TP ICAP is seeking a driven professional for a role within the Global Finance Change team based in Manila. You will spearhead fintech projects aimed at automating processes and driving efficiency through data analytics and reporting.

Ideal candidates are educated at degree level, possess strong knowledge in data analytics, and have experience with ETL tools such as Alteryx. Strong communication and project management skills are essential to navigate stakeholder interactions effectively.

Qualifications

• Educated to degree level.
• Strong technical grounding with some programming skills.
• Extremely passionate about data and analytics.
• Understanding of database and data modelling concepts.

Responsibilities

• Design, develop, and maintain ETL pipelines and dashboards.
• Analyze complex data and participate in reporting projects.
• Collaborate with stakeholders to align project deliverables.
• Manage project documentation and deliverables.

Skills

Data Analytics

Project Management

SQL

Alteryx

Business Intelligence

Communication

Education

Degree in relevant field

Tools

Alteryx

Power BI

SQL

Power Automate

Excel

JIRA

Job description

Role Overview

This role exists within the Global Finance Change team, with responsibility to drive fintech projects across finance with the aim to automate processes, increase efficiency, reduce risks and to establish reporting that supports greater insight and control. Other responsibilities include relationship management both internally and externally with all relevant stakeholders including IT, Compliance and Risk departments, committees and regulators.

Key Responsibilities

• Work with finance teams to identify process where automation would result in significant time savings and improved controls. Help define business requirements and translate into project deliverables.
• Design, develop, implement, and maintain ETL pipelines/workflows (mainly using Alteryx), MI dashboards and data models to be used as part of solutions to internal and external customers. Whilst the role does support solutions across all functions of the business, there is a bias to support Finance activities in particular.
• Ensure that data solutions are available and readily consumable by decision makers through reports that you create, as well as through self-service methods.
• Explore and recommend emerging technologies and techniques to support/enhance BI/MI landscape components.
• Analysing complex data from multiple sources using APIs, SQL queries etc., you'll be responsible for collating data from multiple business lines and technology stacks and combining into views that satisfy the MI objective(s).
• Maintain any reference data which enriches the MI data provided to the business and identify opportunities to minimise that locally maintained data in favour of using corporate or external reference data where possible.
• Analyse system data to identify data quality issues and propose ways to cleanse, normalise, or prevent bad data from entering source systems and/or data warehouse.
• Work on diverse data, reporting and process improvement projects across the business, including data visualisation, ETL development, business controls and regulatory reporting.
• Support the administration and optimisation of the Alteryx servers and end users of the gallery as well as sharing best practice with in-house Alteryx developers
• Understand the varying levels of client / audience, identify key reporting needs and pain points; then lead efforts from concept to final deliverable. This will require active & collaborative stakeholder management.
• Maintain a project list detailing out all projects currently being considered by finance and progress made. Manage project delivery according to TPICAP project methodology, policies and standards
• Develop, monitor and execute a comprehensive communications plan during the entire life-cycle of the project.
• Manage all own project documentation and support others in finance with their documentation
• Provide training on tools and systems where required.
• Work on multiple projects simultaneously

Education and Knowledge

Knowledge

• Educated to degree level
• Subject matter expert in areas related to Finance, Business Intelligence and Data Analytics
• Strong technical grounding, ideally with some programming skills
• Extremely passionate about data and analytics
• Understanding of database and data modelling concepts

Preferred Experience

• Extensive Alteryx or similar ETL tool
• Visualisation software – preferably Qlik and/or Power BI
• SQL – intermediate/advanced knowledge
• Experience using PowerAutomate & Power Applications (or AWS equivalent)
• Power Query & Excel – advanced
• Outstanding oral and written communication at a senior stakeholder level
• Role relevant qualification, certification or accreditation desirable
• Relevant, appropriate and demonstratable experience in a similar role
• Proficiency in project management software tools (JIRA)
• Strong experience in a project role with proven project delivery track record
• Experience or working in a fast moving environment where priorities and scope are subject to change.
• Process analysis, design and engineering
• Ability to understand and translate complex business requirements

Desirable Experience

• Technical finance and regulatory exposure or knowledge desirable
• Experience working with AWS and Snowflake technologies.
• Knowledge of at least one modern scripting language (Python, R, etc.)
• Experience working on projects related to Oracle, Concur or OneStream desirable
• Proficiency working with APIs

Job Band and Level

• Professional, 5

Location

Philippines - Ecoprime Building - Taguig City