HRIS Analyst – Reporting and Analytics

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.

Founded in London in 1866, the Group operates from more than 60 offices in 27 countries.  We are 5,200 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

The HRIS Analyst – Reporting and Analytics is a key member of the HR Data and Analytics team, responsible for delivering accurate and actionable insights to support workforce planning, HR reporting, and regulatory compliance. This role leverages advanced SQL, data modelling, automation, and reporting tools to streamline HR processes and provide decision-making support across the organisation.

Role Responsibilities

• Develop, maintain, and optimise complex SQL queries, stored procedures, and functions for data extraction, transformation, and reporting.

• Design and implement Excel-based automation solutions, including VBA tools, to enhance reporting efficiency and data validation.

• Build and maintain interactive Power BI dashboards and reports to support HR and workforce analytics initiatives.

• Design robust data models to enable effective HR reporting, workforce analytics, and headcount planning.

• Own and manage risk reporting and broker registration processes.

• Ensure data integrity and alignment across HRIS and reporting systems through governance, reconciliation, and quality control.

• Collaborate with HR and cross-functional teams to deliver actionable insights and support downstream applications.

Experience / Competences

Essential

• 5+ years of experience in a data analytics or reporting role within financial services.

• Advanced SQL skills, including experience with stored procedures, triggers, functions, and performance optimisation.

• Strong Excel VBA development skills for building automation tools, forms, and reporting templates.

• Experience in data modelling for reporting and analytics

• Proven experience in people and regulatory reporting.

• Ability to work collaboratively with HR and cross-functional teams to support decision-making.

• Excellent attention to detail and ability to manage large, complex datasets with a focus on accuracy and data quality.

Desired

• Computer Science, Data Analytics, Mathematics or Finance degree, or a related field.

• Familiarity with Workday or other HCM platforms

Job Band & Level

• Manager / Level 6

#LI-Hybrid #LI-ASO

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