Senior BI Developer

National Highways; Bedford; On-site; GBP 70,000 - 95,000; Full time

Job summary

National Highways is seeking a Senior BI Developer for the Digital Services Directorate. You will lead the BI development arm and drive data-led decision making, delivering engaging dashboards and reports across the business.

The role requires strong Power BI with DAX, SQL, and ETL knowledge, plus experience in data warehousing and building automated data solutions. This is a hybrid role with opportunities for continuous learning.

Qualifications

• Significant experience developing solutions using Power BI with DAX.
• Significant experience leading stakeholder engagement to identify requirements for dashboards/reports.
• Ability to read and write SQL code.
• Understanding of data lifecycle and ETL processes in complex multi-source data solutions.
• Knowledge of data warehousing principles.

Responsibilities

• 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 and drive a data-led culture.
• 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 to make data easy to interpret and use for decisions.
• Adopt a continuous learning approach to BI development and reporting techniques, keeping up to date with latest practices.
• Support and train members of the 'Performance and Business Reporting' function in best practice and dashboard development.

Skills

Power BI

DAX

SQL

Stakeholder management

ETL

Data warehousing

Tools

Power BI Desktop

SSIS

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.