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. 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 (e.g., 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.

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 PMO Analyst for a 8 month contract based in London with remote work available (2 days per week in office) We are looking for a PMO Analyst with extensive Power BI skills to be part of the Portfolio Office within the Delivery team of the Digital Technology Group (DTG). The Delivery team leads technology transformation through projects and programmes globally across Arup, to help make Arup's strategic plan and digital vision a reality. The PMO Analyst (PBI) will work with a wide variety of stakeholders as part of a small global team to provide innovative reporting and insights and enhance efficiency through automation and workflows, to maximise value, effectiveness and agility. This pivotal facilitates the development and ongoing management of an optimised portfolio. You should apply if: You have a good understanding of modern portfolio delivery and reporting methods. You have strong interpersonal and communication skills, and enjoy working with diverse stakeholders. You are motivated by the potential of technology to transform a global business. You have strong skills and experience in the design and implementation of Power BI dashboards/reports. Responsibilities of the role include: Working with the project delivery and business analysis professional practices to enhance DTG and Strategy Office portfolio reporting and Power BI dashboards. Designing and developing dashboards for data analysis and visualisation to support operational priorities and leadership decision-making. Managing, maintaining and driving innovation for the digital tools used to deliver internal portfolios, programmes and projects. Evaluating and implementing process improvements and efficiencies; seizing opportunities for efficiencies automation, workflows and AI. Managing and assuring the integrity, quality and timeliness of the portfolio data models used to drive reporting. Updating core datasets as necessary to ensure accuracy of reporting. Liaison with Arup's Power Platform team to ensure alignment to standards. Requirements and skills: 3 years' experience in a project management/PMO role using best practice delivery disciplines including agile methods. Strong analytical skills and ability to work effectively with disparate data sets to drive management insights. Able to use advanced Power BI skills to develop reports and dashboards for operational and executive insights. Experience interpreting requirements and advising best approach to achieve desired outcomes. Experience using SQL, DAX and Power Query to extract, transform and load data. Advanced Excel skills to support data analysis and manipulation. Experience using a range of project management, portfolio management and digital collaboration tools such as Microsoft Project Online, the MS Office 365 suite, Azure. A good foundation in risk assessment, problem resolution, and influencing skills. About the client 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.