Lead SQL Developer

JN Bentley; Leeds; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work model

Competitive salary

Job summary

JN Bentley, a leading civil engineering and construction organisation, is seeking a Lead SQL Developer in Leeds. You will design, build and optimise SQL solutions, lead a team of developers, and drive data-driven decisions by integrating internal and third-party systems.

You will translate business needs into technical data flows, mentor peers, and ensure data quality across reporting and operations. A hybrid working model in Leeds supports collaboration with stakeholders and rapid delivery of

Qualifications

• At least 5 years' experience in SQL development or related roles.
• Experience leading a team of developers.
• Strong MS SQL Server experience and T-SQL.
• Experience with ETL/ELT processes and data pipelines.
• Experience using Git for source control.
• Experience developing or supporting Python-based solutions.

Responsibilities

• Analyse business requirements and translate them into database and integration solutions.
• Design, develop and maintain SQL queries, stored procedures, scripts and database objects.
• Build and support integrations between internal and third-party systems.
• Integrate, transform and validate data for reporting and operational processes.
• Investigate and resolve data, reporting, performance and integration issues.
• Document data flows and technical changes.
• Collaborate with developers, business analysts and stakeholders to deliver effective data solutions.
• Lead, coach and develop a team of SQL Developers, setting clear objectives and supporting performance and development through check-in conversations.

Skills

SQL Server

Team leadership

ETL/ELT

Python

Git

Education

STEM degree or equivalent

Tools

Git

Azure Data Factory

Microsoft Fabric

REST API integrations

Job description

JN Bentley is a leading civil engineering and construction organisation that directly employs over 2,500 people. We are a fast-growing business and are successfully working alongside companies such as National Grid, Rolls Royce, Yorkshire Water, United Utilities, Welsh Water, Severn Trent Water, the Environment Agency, and the Coal Authority, which has allowed us to progress as a leader in the UK construction and civil engineering sectors whilst developing and maintaining an excellent reputation with our clients. Across JN Bentley and our design and build companies MMB and JBA Bentley, annual revenue now exceeds £650 million.

We're looking for a Lead SQL Developer to join our expanding development team based in Leeds. As a Lead SQL Developer, you'll play a key role in developing new systems, integrating third-party applications and maintaining existing solutions. Working closely with developers, business analysts and stakeholders across the business, you'll help transform business requirements into practical, data-driven solutions that support decision making and drive operational improvements.

As a Lead SQL Developer, You Will

• Analyse business requirements and translate them into database and integration solutions.
• Design, develop and maintain SQL queries, stored procedures, scripts and database objects.
• Build and support integrations between internal and third-party systems.
• Integrate, transform and validate data for reporting and operational processes.
• Investigate and resolve data, reporting, performance and integration issues.
• Document data flows and technical changes.
• Collaborate with developers, business analysts and stakeholders to deliver effective data solutions.
• Lead, coach and develop a team of SQL Developers, setting clear objectives and supporting performance and development through check-in conversations.
• Providing direction and oversight of project controls and ensuring your team understands and complies with quality, programme, and cost requirements.

What You'll Need

• At least 5 years' experience in a SQL Developer, Database Developer, Data Engineer or similar role.
• Experience of managing a team as well as coaching and mentoring others.
• Strong Microsoft SQL Server experience, including queries, stored procedures, scripts and database objects.
• Experience creating or supporting data feeds, ETL/ELT processes, integrations or data pipelines.
• Ability to translate business requirements into technical solutions.
• Experience using source control tools such as Git.
• Experience developing or supporting Python-based solutions.

Desirable

• Degree-level qualification in a STEM subject or equivalent experience.
• Experience with Microsoft Fabric, Azure Data Factory, Dataflows, Lakehouse or Warehouse solutions.
• Experience developing or supporting REST API integrations or C# development.

What's in it for you?

Enjoy hybrid working from our Leeds office (2 days per week), a competitive salary, and a fantastic working culture. We offer a supportive environment and access to a wide range of financial, lifestyle, health, and wellbeing benefits.

To view our full range of benefits, please see the Bentley benefits brochure attached.