Lead SQL Developer

JN Bentley is a leading civil engineering and construction organisation that directly employs over 2500 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.

Were looking for a Lead SQL Developer to join our expanding development team based in Leeds. As a Lead SQL Developer youll 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 youll 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 youll 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.

Whats 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.

Required Experience:

IC