Power BI Specialist (PowerQuery - PPM)

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.

AMS is a global workforce solutions partner committed to creating inclusive, dynamic, and future-ready workplaces. We help organisations adapt, grow, and thrive in an ever-evolving world by building, shaping, and optimising diverse talent strategies.

We partner with Arup to support their contingent recruitment processes. Acting as an extension of their recruitment teams, we connect them with skilled interim and temporary professionals, fostering workplaces where everyone can contribute and succeed.
On Behalf of Arup, we are looking for a Power BI Specialist (PowerQuery - PPM) for an 8 Months contract based in London (Hybrid).

Purpose of the role:
As Power BI Specialist (PowerQuery - PPM) you will support the portfolio reporting and providing actionable insights through advanced data visualisation. You will support leadership decision-making and driving efficiencies through automation and digitalisation of reporting processes.

What you'll do:

• Design, develop, and maintain Power BI dashboards and reports to support portfolio, programme, and project reporting.
• Manage and optimise portfolio data models, ensuring data integrity and timeliness.
• Analyse large, complex datasets and synthesise them into actionable insights for leadership.
• Drive innovation in reporting processes through automation, workflows, and digital tools.
• Collaborate with the Power Platform team to ensure alignment with organisational standards.
• Support operational priorities and strategic decision-making through data-driven insights.
• Work within existing PPM tools and systems (eg, Microsoft Project Online, MS Office 365 suite).

The skills you'll need:

• Strong proficiency in Power BI, Power Query, and PPM software.
• Advanced skills in data visualisation, dashboard design, and analytics.
• Experience using SQL, DAX, and Power Query for ETL processes.
• High-level analytical and data management capabilities.
• Background in PMO and data analytics, ideally within a large, global organisation.
• Familiarity with MS Office 365 suite and collaboration tools.

About the client:

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.