We are seeking a Data Engineer with strong hands-on experience in Microsoft SQL Server, T-SQL, and data integration to design, build, and maintain reliable data pipelines and data solutions. The role will focus on ingesting data from internal systems and third-party platforms, including REST APIs, transforming and validating data, and delivering high-quality datasets for reporting, analytics, and operational use. This aligns with current SQL Server Data Engineer and integration-focused role patterns.  

Working hours are: Monday to Thursday 08:00-16:30, and Friday 08:00 – 13:30. At least two days per week will need to be spent in the office at Grantham, as this is important for team collaboration and hands-on involvement with projects. The role will not be fully remote, and while we do offer a hybrid option for this role, Grantham is the primary base.

There will be a 2 stage interview process; initial interviews will take place via Teams, and will focus on technical ability and relevant experience. If successful at this stage, second interviews will take place on-site in person, with a view to having a tour of site, and meeting the team. This approach gives us a good balance between assessing technical skills and getting to you better in person.

Closing date for applications: Sunday 02nd August 2026.

Requirements

Key Roles and Responsibilities

• Design, develop, and maintain SQL Server databases, tables, views, stored procedures, and ETL/ELT pipelines. 

• Write and optimize complex T-SQL queries for data extraction, transformation, reconciliation, and loading. 

• Build and support integrations with RESTful APIs, including data ingestion, pagination handling, authentication, and error handling. 

• Develop and maintain data interfaces between internal applications, external partners, and third-party systems. 

Qualifications / Experience:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related discipline, or equivalent practical experience. 
• Proven experience in a Data Engineer, SQL Developer, Integration Engineer, or similar role. 
• Advanced knowledge of T-SQL, including joins, CTEs, window functions, stored procedures, functions, and query optimization. 
• Good understanding of JSON, XML, CSV, and other interchange formats. 
• Strong understanding of performance tuning, indexing, execution plans, and database best practices. 
• Ability to document solutions clearly and communicate with technical and non-technical stakeholders. 

Benefits

• Employee Assistance Program / Counselling
• On-site parking
• Training and development
• Company workwear provided
• Gym discount
• Free tea / coffee
• 1:30pm finish on Fridays
• Holidays 24 days + 8 bank holidays (FTE, pro-rated)
• Quarterly bonus scheme
• Specsavers vouchers