Senior BI Developer

National Highways; Guildford; On-site; GBP 55,000 - 85,000; Full time

Job summary

National Highways is seeking a Senior BI Developer for the Digital Services Directorate. You will lead the business intelligence development arm of the Performance and Business Reporting team, driving efficiencies in data visualisation and reporting while showcasing our data across the business.

The role involves gathering requirements, designing and building solutions, and collaborating with stakeholders in a hybrid role to deliver impactful dashboards and automated reporting.

Qualifications

• Extensive experience with Power BI and DAX.
• Experience leading stakeholder engagement to shape dashboards or reports.
• Ability to read and write SQL.
• Understanding of data lifecycle and ETL in multi-source data solutions.
• Knowledge of data warehousing.
• Ability to translate complex concepts for non-technical audiences.
• Strong workload planning and delivery under deadlines.
• Analytical and logical thinker with big-picture focus.

Responsibilities

• Partner with teams across the Digital Services Directorate to understand their data challenges and needs.
• Influence approaches to using data to drive a data-led culture and provide recommendations.
• Develop engaging data presentation techniques and improve existing reports.
• Identify opportunities for automation in data reporting and visualisation.
• Challenge the status quo and develop creative data solutions for complex problems.
• Establish best practices for data visualisation and reporting.
• Keep up to date with latest BI practices and techniques.
• Support and train the Performance and Business Reporting function in dashboard development.

Skills

Power BI

DAX

SQL

Stakeholder engagement

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.