Senior BI Developer

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

Job summary

National Highways seeks a Senior BI Developer to lead the BI development arm within the Digital Services Directorate, driving data-led decisions and delivering advanced dashboards using Power BI and DAX.

You will gather requirements, design data solutions, and champion best practices, while collaborating with cross-functional teams and continuously evolving reporting capabilities in a hybrid working environment.

Qualifications

• Significant experience delivering Power BI solutions using DAX.

Responsibilities

• Act as a key business partner to teams across the Digital Services Directorate to understand data challenges.
• Influence data use and drive a data-led culture across the Directorate.
• Develop engaging data presentation techniques and improve existing reports.
• Identify opportunities for automation of data reporting and visualization.
• Challenge the status quo and develop creative solutions to complex problems.
• Establish best practices for data visualization and reporting.
• Adopt a continuous learning approach to BI development and reporting techniques.
• Support and train the Performance and Business Reporting function in dashboard development.

Skills

Power BI

DAX

Stakeholder management

SQL

Data warehousing

ETL processes

Dashboard development

Analytical thinking

Tools

Power BI Desktop

SQL Server

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.