Job description

Do you want to work for a company whose purpose is to improve society by considering social outcomes, and to transform businesses, communities, and opportunities for it’s employees? Mott MacDonald is a global consultancy whose people do exactly that.

Mott MacDonald is looking for a Data Analyst to help deliver digital solutions in line with the business requirements.

The team is focused on helping our clients in ‘Realising the true value of information’, how it can improve their efficiency and provide for better outcomes for projects and management of existing assets.

You will help shape solutions according to client needs and manage their successful delivery, reaching back into the wider business for access to our deep domain knowledge, coupling this with the digital capability located within the business. The role is crucial as it will be acting as a conduit between the business and the digital worlds.

Our new and fast-growing Advisory Data Analytics is working globally, both client-side at the enterprise level and across major programmes, on exciting projects of national importance in infrastructure. Our purpose is to help clients collect, analyse and report on Project Management data such as risks, schedules, and costs. We have a start-up like environment: there is a fantastic opportunity to grow and get exposure to the variety of different responsibilities. Our team is also committed to training and will support you on a journey to gain more knowledge, experience, and qualifications

You will be part of our entrepreneurial and growing team which provides industry-leading, award-winning consulting services. We work with our clients helping them to harness opportunities, including digital to tackle their complex challenges. We do this by bringing together the best of our engineering domain knowledge and digital and data know how.

What you will contribute to the team
The day to day activities in the role will range from gathering data through ETL processes to building BI reports using Microsoft applications.

We are looking for candidates who are keen to share their experience to date in the application of data analytics, modelling and business intelligence related data design.

A key input would be receiving requirements from relevant stakeholders and building a project plan around the deliverables. You will first be conceptualising from a high level the business need and then executing a data strategy to fulfil that need.

Candidate Specification

Required for the position of Data Analyst

  • Experience in full life cycle BI projects, from consulting and needs analysis gathering through to development and delivery. With proven design, delivery and deployment experience of Business Intelligence projects.
  • Strong extract, transform and load skills, with the ability to summarise and prepare data to feed BI models.
  • Experience of ETL and data integration processes must include the use of tools such as SQL Server Integration Services or ETL using Power BI or Excel PowerQuery.
  • Data modelling (SSAS, Excel/PowerQuery or Power BI) experience is essential with a high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.
  • Working commercial knowledge in Business Intelligence projects using Microsoft Applications.
  • Experience in data querying using SQL on different platforms, such as using SQL within Power BI, in SSIS or SSMS.

Preferred, but not required

  • Knowledge of Agile process and principles, Professional Scrum certification is desirable
  • Ideally the candidate would have experience in creating data services such as SQL databases/warehouses either as PAAS or IAAS services and working with Active Directory
  • Working commercial knowledge in Business Intelligence projects using Microsoft Applications.

If you meet 80% or more of what we’re looking for, please still apply. We understand not everyone will meet all the requirements, but you might have skills we didn’t know we need.


Job Profile

About the business unit
The Advisory and Programme Delivery (APD) unit delivers management services in all the sectors that Mott MacDonald operate in the Built Environment, Defence, Energy, Water, Transportation and, Education, Health and Care.

The Unit delivers services to projects ranging in scale and complexity up to £20bn, through the technical disciplines of Programme Management, Project Management, Project Controls, Scheduling, Cost Management, Estimating, Infrastructure Finance, Management Consulting, Digital Consulting and Education, Health and Care Management.

How to apply
To apply for this role, please complete our 15-minute application via our website. Our talent acquisition coordinators aim to provide feedback within 5 working days with the outcome of your application. More information about our application process can be found here. If you have any questions regarding your application or the role, please reach out to the dedicated recruiter listed who will be more than happy to help.

Mott MacDonald is Work180 accredited – which means we actively support and encourage women to join our work force!

Benefits we offer:


  • Pension matched up to 7%
  • Life insurance
  • An annual professional institution subscription
  • Continuous development opportunities – because we want you to thrive
  • Agile/flexible working – because life isn’t 9-5
  • Enhanced parental leave; shared parental leave policies – for parents and care givers
  • Annual company performance bonus scheme – Subject to company performance
  • Flexible benefits that suit you, including cycle to work & interest free season ticket loans .
  • The opportunity to make a difference; learn more about our social outcomes

Other Information

Equality, diversity and inclusion
We put equality, diversity and inclusion at the heart of our business, seeking to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute.

If you have a disability and would prefer to apply in a different format or would like us to make reasonable adjustments to enable you to apply or attend an interview, please contact us at reasonable.adjustments@mottmac.com and we will talk to you about how we can assist.

Agile working
At Mott MacDonald, we believe it makes business sense for you and your manager to choose how you can work most effectively to meet your client, team and personal commitments. We embrace agility, flexibility and trust.

More about Mott MacDonald
We’re a global engineering, management and development consultancy.
Our purpose is to improve society by considering social outcomes in everything we do, relentlessly focusing on excellence and digital innovation, transforming our clients’ businesses, our communities and employee opportunities.
A fundamental part of this is respecting each person’s differences and striving to meet their needs.
Our values: progress, respect, integrity, drive, excellence

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.