Back to jobs
Mace
Mace

Data Analyst

Peterborough Hybrid 2-5 yrs exp Construction 10,106 employees
Advanced ExcelPower QueryData CleansingData TransformationPivot Tables

Requirements

The role requires advanced Excel skills and experience managing large HR or workforce datasets, with a strong focus on data quality, governance, and accurate skills classification. Experience with Copilot or other AI tools is required; Workday, skills frameworks, job architecture, workforce planning, and HR transformation experience are also relevant.

Job Description

Mace combines construction expertise with consultancy to unlock potential in every person or project and redefine the boundaries of ambition. Our values shape the way we consult and define the people we want to join us on our journey.

You’ll Be Responsible For

  • Cleansing and standardising job profile, job title, and employee data extracted from workday.
  • Reviewing and analysing existing job role outputs (JROs) and role profiles.
  • Use Copilot and other AI-assisted methods to extract skills from role documentation..
  • Prepare and format data for Workday upload and integration.
  • Conduct data quality reviews and validation checks to ensure completeness and accuracy.
  • Test data within Workday and investigate any data, mapping, or loading issues.
  • Create reporting approach for skills profile activity.
  • Provide data analytic SME to the CDCP programme.

You’ll Need To Have

Advanced Excel skills including:

  • Power query.
  • Data cleansing and transformation.
  • Pivot tables.
  • Lookup functions (XLOOKUP/VLOOKUP).
  • Experience managing and analysing large HR or workforce datasets.
  • Strong data quality and data governance mindset.
  • Experience extracting and categorising information using Microsoft Copilot or AI tools.
  • Ability to identify, standardise, and classify skills into structured taxonomies.
  • Strong analytical and problem-solving skills.
  • Excellent attention to detail.
  • Ability to work independently and deliver at pace.
  • Experience with Workday HCM and/or Workday skills Cloud.
  • Knowledge of skills frameworks, skills-based organisations, or workforce planning.
  • Experience supporting HR transformation, talent, or workforce programmes.
  • Understanding of job architecture, job profiling, and skills assessments.

Our values

Safety first - Going home safe and well: We champion a safe, diverse and inclusive working environment, understanding the importance of wellbeing in every team.

Client focus - Deliver on our promise: We own the quality of deliverables, strategic outcomes and build long term relationships with our clients.

Integrity - Always do the right thing: We influence positive outcomes within our industry, while always aligning with our compliance obligations.

Create opportunity - For our people to excel: We champion a continuous improvement culture throughout all activities, inspiring our people and teams to develop.

Mace is an inclusive employer and welcomes interest from a diverse range of candidates. Even if you feel you do not fulfil all the criteria, please apply as you may still be the best candidate for this role or another role within our organisation.

We are also open to discussing part time, flexible, and hybrid working options if suitable within the role.

Skills

Advanced ExcelPower QueryData CleansingData TransformationPivot TablesLookup FunctionsHR Data AnalysisData QualityData GovernanceMicrosoft CopilotAI-Assisted Data ExtractionSkills ClassificationWorkday HCMWorkday Skills CloudJob ArchitectureWorkforce Planning

About Mace

Mace Consult launched as a new and independent business on 5 March 2026, through a carve-out from Mace Group. Mace Consult and Mace Construct are now two independent businesses following the completion of a majority investment in Mace Consult by Goldman Sachs Alternatives. Mace Consult will continue to grow and develop under the Mace name, leveraging the strength of the brand’s global reputation in delivering exceptional programme and project delivery. Mace Construct will rebrand later in 2026. Until Mace Construct rebrands, we will continue to post news, views and achievements from both businesses on this LinkedIn account. Learn more about the transaction and what this means for the future of Mace Consult on our website.

View company profile →