PMO Data & Insights Analyst

About Arup

Dedicated to sustainable development, Arup is a collective of designers, consultants and experts working globally.

At Arup you will have the opportunity to collaborate on ambitious projects - delivering remarkable outcomes for clients and communities, and to do socially useful work that has meaning.

Arup's purpose, shared values and collaborative approach has set it apart for over 75 years, and now is your opportunity to join.

Job description - the role

AMS is the world's leading provider of Talent Acquisition and Management Services. Our contingent Workforce Solutions (CWS) service acts as an extension of our clients' recruitment team and provides professional interim and temporary resources. We partner with Arup to support contingent recruitment processes. On behalf of Arup, we are looking for a PMO Data & Insights Analyst for a 6 months contract based in Cardiff.

Candidate Profile: Key accountabilities, skills & experience

Working at Arup offers you the chance to make a positive difference in the world. Independently owned and independently minded, we attract a diverse mix of people to work on ground-breaking projects. We have an ambitious commitment to shape a better world and be the digital leader in the built environment through our expertise and collaborative working. We value people with diverse experiences, backgrounds, specialisms and skills.

The Role:

We are seeking a highly analytical and technically skilled PMO Data & Insights Analyst to be part of the delivery team within the Portfolio Office of the Energy, Water and Resources Group (EWR). The delivery team is engaged in multiple water frameworks, helping our UK clients solve the most pressing challenges across the water cycle.

The PMO Analyst will work a with a wide variety of stakeholders as part of our framework teams to lead, facilitate and support our portfolio, programme and project demand and delivery approach to maximise value, effectiveness and agility.

This role is ideal for someone who thrives on working with complex datasets, enjoys building automated reporting solutions, and understands the nuances of engineering project delivery.

You will play a pivotal role in transforming raw project data into meaningful insights by leveraging tools such as Power Query, Power BI, and advanced Excel. Your work will directly support project governance, applications for payment, project forecasts, performance tracking, and strategic decision-making across a diverse portfolio of infrastructure and design projects.

The role reports to the Framework Director.

Key Responsibilities include:

• Building and maintaining automated dataflows using Power Query to extract, transform, and merge data from multiple internal sources (e.g., project controls systems, timesheets, finance tools).
• Designing and optimising Excel-based tools using advanced formulas to support monthly analysis and reporting needs.
• Leading and being responsible for timely and accurate monthly applications for payment and project forecasts in accordance with Client requirements and Arup governance processes
• Developing and managing Power BI reports and dashboards within shared workspaces, ensuring real-time visibility into project performance, resource utilization, and financial metrics.
• Collaborating with engineering, commercial, and delivery teams to ensure data accuracy, consistency, and alignment with project milestones and KPIs.
• Supporting project governance by preparing high-quality reports for internal and client-facing reviews.
• Continuously improving data processes, identifying opportunities for automation, standardization, and enhanced data quality.

What We're Looking For:

• Expertise in Power Query for data transformation and integration across multiple sources.
• Proficiency in Power BI, including workspace management, DAX, and data modelling.
• Advanced Excel skills, including complex formulas, pivot tables, and data validation techniques.
• Experience working with project data in an engineering or technical consultancy environment.
• Strong attention to detail, with the ability to spot inconsistencies and drive data integrity.
• Excellent communication skills and a collaborative mindset.
• Prior experience in a finance, accounting, or operations environment is a plus.

About the client

Diversity at Arup:

Arup is an equal opportunity employer that actively promotes and nurtures a diverse and inclusive workforce. Guided by its values and alignment with the UN Sustainable Development Goals, Arup creates and contributes to equitable spaces and systems, while cultivating a sense of belonging for all. Arup's internal employee networks support their inclusive culture: from race, ethnicity and cross-cultural working to gender equity and LGBTQ+ and disability inclusion - creating a space for everyone to express themselves and make a positive difference.

If you are interested in applying for this position and meet the criteria outlined above, please click the link to apply and speak to one of our Sourcing Specialists.

AMS are committed to providing all our candidates with the opportunity to perform at their best throughout the recruitment process. Please let us know if you require any additional support or reasonable adjustments during the screening process and we will work with you and Arup to identify the best solution to meet your requirements.

AMS, a Recruitment Process Outsourcing Company, may in the delivery of some of its services be deemed to operate as an Employment Agency or an Employment Business.