Lead SQL Developer

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.