Data Analyst, Finance (Data Analytics) at ICAP

Manila, Metro Manila, Philippines -

Full Time

Start Date

Immediate

Expiry Date

16 Aug, 26

Salary

0.0

Posted On

18 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Alteryx, SQL, Power BI, Qlik, Power Automate, Power Applications, ETL Pipelines, Data Modeling, Business Analysis, Stakeholder Management, JIRA, Python, R, API Integration, Data Visualization, Change Management

Industry

Financial Services

Description

The TP ICAP Group is a world leading provider of market infrastructure. Our purpose is to provide clients with access to global financial and commodities markets, improving price discovery, liquidity, and distribution of data, through responsible and innovative solutions. Through our people and technology, we connect clients to superior liquidity and data solutions. The Group is home to a stable of premium brands. Collectively, TP ICAP is the largest interdealer broker in the world by revenue, the number one Energy & Commodities broker in the world, the world’s leading provider of OTC data, and an award winning all-to-all trading platform. The Group operates from more than 60 offices in 27 countries. We are 5,300 people strong. We work as one to achieve our vision of being the world’s most trusted, innovative, liquidity and data solutions specialist. 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. Role Responsibilities: The Finance Data Analyst will support the delivery of the Finance transformation strategy, focusing on process automation, data management and dynamic reporting developments, using a variety of formal and Fintech tools. Principally a change focused role, with a drive to replace current manual processes and reporting with automated Fintech solutions. You will also manage relationships with stakeholders (including all project contributors) across the various business units. Strong interpersonal and communication skills are a must. Due to the nature of the role, good business analysis skills and prior experience working in a change management function are essential. Key responsibilities include; 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 Experience / Competences / Knowledge & Understanding 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 Client Focused Personable and engaging Communicates effectively and efficiently to internal and external stakeholders Build relationships and networks with both internally and externally wherever possible Demonstrates strong customer focus Demonstrates ability to work effectively with others Constructively handles disagreements to reach a resolution Ability to work with diverse groups/ personalities Act with integrity and due skill, care and diligence in carrying out your duties Innovative Open to innovative ideas/ experiences and ability to create new ideas, approaches or insights Seeks opportunities for improvements Handles situations and problems with innovation and creativity Dynamic & Competitive Demonstrates high levels of energy in seeking out and achieving new goals Goes that “extra mile” Self-starter with ability to work on their own initiative with minimal supervision Shows evidence of being comfortable working in fast paced or pressured environments Enjoys a challenge and is able to escalate Does not give up easily Open & Communicative Adapts communication style to suit audience Projects personal credibility Interacts confidently without being overbearing Ability to work effectively in a high pressure environment Keeps emotions under control in difficult situations Handles criticism constructively Professional Integrity Able to demonstrate honesty, integrity and professionalism Promotes loyalty to TP ICAP and its principles Works ethically and shows respect for both professional and company values Effective Excellent attention to detail, highly organised with a proactive approach Strong analytical ability and problem solving skills Evidence of ability to use sound judgment Job Band and Level Professional, 5 Not The Perfect Fit? Concerned that you may not meet the criteria precisely? At TP ICAP, we wholeheartedly believe in fostering inclusivity and cultivating a work environment where everyone can flourish, regardless of your personal or professional background. If you are enthusiastic about this role but find that your experience doesn't align perfectly with every aspect of the job description, we strongly encourage you to apply. You may be the ideal candidate for this position or another opportunity within our organisation. Our dedicated Talent Acquisition team is here to assist you in recognising how your unique skills and abilities can be a valuable contribution. Don't hesitate to take the leap and explore the possibilities. Your potential is what truly matters to us. Company Statement We know that the best innovation happens when diverse people with different perspectives and skills work together in an inclusive atmosphere. That's why we're building a culture where everyone plays a part in making people feel welcome, ready and willing to contribute. TP ICAP Accord - our Employee Network - is a central to this. As well as representing specific groups, TP ICAP Accord helps increase awareness, collaboration, shares best practice, and holds our firm to account for driving continuous cultural improvement. Location Philippines - Ecoprime Building - Taguig City Connecting clients, communities and colleagues for sustainable growth TP ICAP connects people, platforms, ideas, and insight across the world’s financial, energy and commodities markets. As a global leader in market infrastructure and data-led solutions, we enhance market access, increase efficiencies, and unlock possibilities. Work with us Joining TP ICAP puts you at the heart of markets that matter. You’ll have the freedom to innovate and act on your initiative. We’ll train you and build your abilities in your specialist area, so that you can become an expert in your field. And all within a connected network that’s there to set you up for success. More about us TP ICAP Group is a collection of premium brands each with a distinct, client-focused offering. Underpinning and connecting these client-facing brands is the financial security, operational strength and know-how we have as a Group. Connections are at the heart of what we do. We combine our people’s know-how with the latest technology to improve price discovery, trade execution and liquidity flow. Connections create strength. Through them, we help our clients to manage risk, realise investment strategies and expand the scope for growth. And connections act as a catalyst. Sparking richer solutions for our clients to break new ground, modernising markets for future performance, and creating dynamic careers for our people. Our capacity to connect builds trust, supports communities and gives us the power to anticipate and respond to change, whatever direction the world takes. It’s what makes TP ICAP a mainstay in the global markets, now and in the future. TP ICAP. We connect.

Responsibilities

Drive fintech projects within the Global Finance Change team to automate manual processes and increase efficiency. Design and maintain ETL pipelines, MI dashboards, and data models to provide actionable insights for decision makers.