HR Data & Reporting Specialist (Excel Pro)

TRIA; Southampton; On-site; GBP 25,000 - 33,000; Full time

Job summary

TRIA is seeking an HR Data & Reporting Officer on a 3-month contract (Inside IR35) at £157 per day. The role is based in Basingstoke with two days per week onsite, supporting day-to-day management, validation and reporting of employee and organisational data.

The ideal candidate will be highly proficient in Excel, comfortable handling large datasets, and able to identify and resolve data discrepancies with minimal supervision.

Qualifications

• Strong practical Microsoft Excel skills.
• Experience analysing and manipulating large datasets.
• Confident using functions such as XLOOKUP/VLOOKUP, IF formulas, PivotTables and conditional formatting.
• Experience identifying data discrepancies, duplicates and data-quality issues.
• Experience producing reports, management information or workforce reporting.
• Excellent attention to detail and a methodical approach to data.
• Comfortable handling confidential and sensitive information.
• Able to work independently and contribute quickly in a short-term assignment.

Responsibilities

• Maintain and update employee and organisational data within the HR system.
• Process employee lifecycle changes including starters, leavers, contract changes and internal moves.
• Run regular HR and workforce reports and analyse the data in Excel.
• Produce headcount and workforce reporting, including analysis by department and other organisational areas.
• Identify duplicate, missing or inaccurate records and investigate discrepancies.
• Validate and reconcile employee data across HR, Payroll and Finance systems.
• Produce scheduled and ad hoc management information and reports.
• Support data quality checks and ensure HR records are maintained accurately.
• Handle confidential employee information appropriately and in line with data protection requirements.
• Support testing and data checks relating to system updates and improvements.
• Identify opportunities to improve reporting processes and reduce manual administration.

Skills

Excel skills

Data analysis

Lookup formulas

Data quality

Reporting

Confidential data

Independent work

Tools

Workday

HRIS

Power BI

BI tools

Job description

TRIA is seeking an HR Data & Reporting Officer on a 3-month contract (Inside IR35) at £157 per day. The role is based in Basingstoke with two days per week onsite, supporting day-to-day management, validation and reporting of employee and organisational data.

The ideal candidate will be highly proficient in Excel, comfortable handling large datasets, and able to identify and resolve data discrepancies with minimal supervision.