Senior BI Developer

National Highways; West of England; On-site; GBP 65,000 - 90,000; Full time

Job summary

National Highways is seeking a Senior BI Developer to lead the Performance and Business Reporting data visualisation and reporting capabilities. Hybrid role, you will gather requirements and design solutions.

You will partner across the Digital Services Directorate to drive a data-led culture, develop engaging dashboards using Power BI and DAX, and streamline ETL processes.

The role emphasizes turning data into actionable insights and training colleagues in best practices.

Qualifications

• Extensive experience building solutions with Power BI and DAX.
• Experience leading stakeholder engagement to shape dashboards.
• Proficient in reading/writing SQL.
• Understanding of data lifecycle and ETL in multi-source systems.
• Knowledge of data warehousing principles.
• Ability to translate complex concepts for non-technical colleagues.
• Strong planning and prioritisation under deadlines.

Responsibilities

• Partner with teams to understand data challenges and needs.
• Influence data usage across the directorate.
• Develop engaging data presentation techniques and improve reports.
• Identify automation opportunities for data reporting and Visualisation.
• Challenge status quo and craft creative solutions.
• Establish best practices for data visualisation and reporting.
• Support and train team in dashboard development.

Skills

Power BI

DAX

SQL

ETL

Data warehousing

Stakeholder engagement

Communication

Planning

Job description

Your new role

The Digital Services Directorate is a fast-paced and dynamic function and recognises that in order to keep improving, we need to put data at the centre of the decisions we make - ensuring we are truly data-led.

As a Senior BI Developer, you will lead the business intelligence development arm of the Performance and Business Reporting team. You will drive efficiencies and improvements to Digital Services data visualisation and reporting capabilities whilst identifying opportunities to showcase our data in new and engaging ways across the business.

This will involve leading on business requirements analysis, along with the solution and data design and build. The position is very much a hybrid role - the ability to accurately gather and document requirements is important along with the ability to design and build solution.

What you'll be leading on

• Act as a key business partner to teams across the Digital Services Directorate to understand their critical business challenges and needs from a data perspective.
• Influence the approaches to using data across the Digital Services Directorate. Driving a data-led culture and providing advice and recommendations on how data can improve business initiatives.
• Develop engaging and innovative data presentation techniques and identify opportunities to improve existing reports.
• Work across the entire Digital Services Directorate, proactively identifying opportunities for automation of data reporting and visualisation.
• Have the confidence to challenge the status quo and develop creative solutions to complex problems.
• Establish best practices for data visualisation and reporting. So, data can be easily interpreted and utilised to inform business decisions.
• Adopt a continuous learning approach to business intelligence development and reporting techniques, keeping up to date with the latest practices and thinking.
• Support and train members of the 'Performance and Business Reporting' function in best practice and dashboard development.

To be successful

• Significant experience developing solutions using Power BI in conjunction with Data Analysis Expressions (DAX) programming language.
• Significant experience of leading stakeholder engagement to identify requirements to produce tailored or enhance, existing dashboard or reports.
• Ability to read and write SQL code.
• Understand data lifecycle and ETL processes in complex multi-source data solutions.
• An understanding of data warehousing principles.
• Ability to build and maintain strong relationships with technical and non-technical colleagues of all levels, translating complex concepts into simple terms where required.
• The ability to plan and structure workload, collaboratively delivering under pressure and to deadlines.
• A methodical, analytical and logical thinker with the ability to see the bigger picture and get to the underlying business challenges and questions that need answering.

A bit about us

The Digital Services Directorate is a growing and vibrant team, and there has never been a better time to join us. We are helping to transform the way National Highways operates by delivering digital, data and technology services from frontline to back office in a modern and efficient way. Our vision is to develop integrated information and technology that empowers our colleagues and provides real‑time information to our customers, integration with intelligent vehicle and transport systems as they develop, to improve journey safety and reliability.