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 &amp; 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 OverviewThe 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<ul><li>Develop, maintain, and optimise complex SQL queries, stored procedures, and functions for data extraction, transformation, and reporting.</li><li>Design and implement Excel-based automation solutions, including VBA tools, to enhance reporting efficiency and data validation.</li><li>Build and maintain interactive Power BI dashboards and reports to support HR and workforce analytics initiatives.</li><li>Design robust data models to enable effective HR reporting, workforce analytics, and headcount planning.</li><li>Own and manage risk reporting and broker registration processes.</li><li>Ensure data integrity and alignment across HRIS and reporting systems through governance, reconciliation, and quality control.</li><li>Collaborate with HR and cross-functional teams to deliver actionable insights and support downstream applications.</li></ul>Experience / CompetencesEssential<ul><li>5+ years of experience in a data analytics or reporting role within financial services.</li><li>Advanced SQL skills, including experience with stored procedures, triggers, functions, and performance optimisation.</li><li>Strong Excel VBA development skills for building automation tools, forms, and reporting templates.</li><li>Experience in data modelling for reporting and analytics</li><li>Proven experience in people and regulatory reporting.</li><li>Ability to work collaboratively with HR and cross-functional teams to support decision-making.</li><li>Excellent attention to detail and ability to manage large, complex datasets with a focus on accuracy and data quality.</li></ul>Desired<ul><li>Computer Science, Data Analytics, Mathematics or Finance degree, or a related field.</li><li>Familiarity with Workday or other HCM platforms</li></ul>Job Band &amp; Level<ul><li>Manager / Level 6</li></ul>#LI-Hybrid #LI-ASONot 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 StatementWe 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. LocationPhilippines - A.T. Yuchengco Centre - Taguig City

We are the world&rsquo;s largest inter-dealer broker, the world&rsquo;s largest energy &amp; commodities broker, and the world&rsquo;s leading provider of over-the-counter (OTC) pricing data.
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.
We operate in 28 countries and employ 5,200 people, including 2,600 brokers. Our clients include top tier investment banks and financial institutions.
Through our people and technology, we connect clients to superior liquidity and data solutions across every major asset class, including Rates, FX, Credit Equities, Energy, Renewables and Digital Assets.
We are home to a line up of premium brands. Each has a distinct, client-focused offering, underpinned by the financial security, operational strength and robust governance of the TP ICAP Group.

HRIS Analyst – Reporting and Analytics (SQL)

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 &amp; 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.&nbsp; We are 5,200 people strong.&nbsp; We work as one to achieve our vision of being the world’s most trusted, innovative, liquidity and data solutions specialist.Role OverviewThe 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<ul><li>Develop, maintain, and optimise complex SQL queries, stored procedures, and functions for data extraction, transformation, and reporting.</li><li>Design and implement Excel-based automation solutions, including VBA tools, to enhance reporting efficiency and data validation.</li><li>Build and maintain interactive Power BI dashboards and reports to support HR and workforce analytics initiatives.</li><li>Design robust data models to enable effective HR reporting, workforce analytics, and headcount planning.</li><li>Own and manage risk reporting and broker registration processes.</li><li>Ensure data integrity and alignment across HRIS and reporting systems through governance, reconciliation, and quality control.</li><li>Collaborate with HR and cross-functional teams to deliver actionable insights and support downstream applications.</li></ul>Experience / CompetencesEssential<ul><li>5+ years of experience in a data analytics or reporting role within financial services.</li><li>Advanced SQL skills, including experience with stored procedures, triggers, functions, and performance optimisation.</li><li>Strong Excel VBA development skills for building automation tools, forms, and reporting templates.</li><li>Experience in data modelling for reporting and analytics</li><li>Proven experience in people and regulatory reporting.</li><li>Ability to work collaboratively with HR and cross-functional teams to support decision-making.</li><li>Excellent attention to detail and ability to manage large, complex datasets with a focus on accuracy and data quality.</li></ul>Desired<ul><li>Computer Science, Data Analytics, Mathematics or Finance degree, or a related field.</li><li>Familiarity with Workday or other HCM platforms</li></ul>Job Band &amp; Level<ul><li>Manager / Level 6</li></ul>#LI-Hybrid #LI-ASONot 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 StatementWe 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.&nbsp;LocationPhilippines - A.T. Yuchengco Centre - Taguig City

HRIS Analyst – Reporting and Analytics (SQL)

About the Job

About the Company

ICAP Energy AS

Similar Jobs

Lead Analyst - Reporting

Lead Analyst - Reporting

IT Support Analyst -SSRS

IT Support Analyst -SSRS

Service Business Analyst

Service Business Analyst

Data & Analytics Senior Analyst

Data & Analytics Senior Analyst

Planning Data and Analytics Operations Architect

Planning Data and Analytics Operations Architect

HR Data & Insight Analyst (Mid-Senior Level)

HR Data & Insight Analyst (Mid-Senior Level)

HR Specialist

HR Specialist

Senior Business Data Intelligence Specialist

Senior Business Data Intelligence Specialist

Director, People Analytics & Insights

Director, People Analytics & Insights

Senior Data Analyst - Finance

Senior Data Analyst - FinanceNew