Digital Analytics Consultant - Power BI & Data Solutions

Mott MacDonald Group; Manchester; Hybrid; GBP 42,000 - 68,000; Full time

Benefits offered by this job

Pension contributions

Life assurance

Income protection

Flexible benefits

Employee ownership

Private medical insurance

Health cash plan

Peppy support

Generous holiday

Enhanced family leave

Job summary

Mott MacDonald is seeking a Digital Consultant to deliver practical digital and data-enabled solutions on major projects within the APD unit. Working in the Digital PMO/project controls, you will turn complex reporting needs into usable, maintainable outputs.

The role requires owning defined work packages, engaging with stakeholders, and designing/testing Power BI dashboards, data models, pipelines, and automation while documenting architecture and supporting adoption across teams.

Qualifications

• Experience delivering Power BI reporting or analytics solutions, including data preparation, modelling, DAX and visualisation
• Ability to work with limited supervision on complex assignments and own delivery from discovery through testing and handover
• Experience capturing stakeholder requirements and translating business needs into practical, testable digital or data outputs
• Working knowledge of Power Query / ETL and SQL, with experience integrating varied data sources
• Strong communication and documentation skills, including supporting adoption and explaining solutions to non-specialists
• Organised and delivery‑focused, with experience in a project, programme, PMO or consulting environment

Responsibilities

• Designing, prototyping, building and testing Power BI dashboards, data models, reporting pipelines, workflow automation and SharePoint‑based collaboration structures
• Own defined work packages and work directly with stakeholders to understand processes, validate requirements, assess data sources and agree success measures
• Document solution architecture, data lineage, assumptions, controls, testing and handover information; support training and adoption
• Collaborate with project controls disciplines and wider delivery teams, contribute reusable assets and lessons, and provide practical advice to less experienced colleagues

Skills

Power BI

DAX

SQL

ETL

Data modeling

Stakeholder input

Power Query

SharePoint

Python

Azure Data Factory

REST APIs

GitHub

Tools

Power BI

SharePoint

Azure Data Factory

REST APIs

GitHub

Job description

Mott MacDonald is seeking a Digital Consultant to deliver practical digital and data-enabled solutions on major projects within the APD unit. Working in the Digital PMO/project controls, you will turn complex reporting needs into usable, maintainable outputs.

The role requires owning defined work packages, engaging with stakeholders, and designing/testing Power BI dashboards, data models, pipelines, and automation while documenting architecture and supporting adoption across teams.