Senior BI Developer

National Highways; Manchester; On-site; GBP 60,000 - 90,000; Full time

Job summary

National Highways seeks a Senior BI Developer to lead the BI development within the Performance and Business Reporting team. You will drive data visuals and reporting improvements, partner with teams, and design solutions across the Digital Services Directorate.

The role is hybrid, focusing on gathering requirements, designing solutions, and delivering value through data-driven insights. Key requirements include strong Power BI with DAX, SQL proficiency, and experience in ETL and data

Qualifications

• Significant experience developing Power BI solutions with DAX.
• Significant stakeholder engagement to tailor dashboards or reports.
• Ability to read and write SQL code.
• Understanding of data lifecycles and ETL in multi-source solutions.
• Knowledge of data warehousing principles.
• Ability to build strong relationships with colleagues at all levels.
• Capable of planning and structuring workload under deadlines.
• Methodical, analytical, and logical thinker with big-picture focus.

Responsibilities

• Act as a key business partner to Digital Services teams to understand data needs.
• Influence data usage across the directorate and drive a data-led culture.
• Develop engaging data presentation techniques and improve reports.
• Identify opportunities to automate data reporting and visualisation.
• Challenge the status quo and create solutions to complex problems.
• Establish best practices for data visualisation and reporting.
• Keep up to date with BI practices and share learnings.
• Support and train the Performance and Business Reporting staff in dashboards.

Skills

Power BI

DAX

Stakeholder engagement

SQL

Data lifecycle

ETL processes

Data warehousing

Relationship building

Tools

SQL

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.