SQL Server Database & Integration Developer

We’re looking for an experienced SQL Server and T-SQL developer, ideally with 5+ years, to own and evolve the database and integration layer of our Clarity platform and to support our PA-IQ healthcare products.

What you’ll do

• Develop, troubleshoot and optimise SQL Server databases, T-SQL, stored procedures, functions and views

• Read execution plans, tune indexes and queries, and fix data quality problems at the root

• Build and maintain client integrations, imports, transformations, reconciliation and scheduled processes

• Document mappings for unfamiliar source systems and make data feeds reliable and supportable

• Use AI coding tools (Claude or similar) day to day, and test and challenge their output

• Strong hands-on Microsoft SQL Server and T-SQL, ideally 5+ years

• Query optimisation, performance tuning and data modelling

• Integrating disparate client systems and keeping live feeds reliable

• Practical AI-assisted development experience

• Source control, deployment processes and automated testing

• Clear communication with clients

Desirable

Azure SQL Database, Azure Data Factory, SSIS or other ETL, REST APIs / JSON / XML, React with TypeScript or .NET, and energy, healthcare or operational-data experience.

£40,000-£60,000 depending on experience · 9-day fortnight · hybrid working (remote / Scotland) · all tools, licences and subscriptions provided · real ownership and client contact

How we assess

A friendly technical conversation plus a short practical exercise: troubleshoot and tune some SQL, and review a piece of AI-generated code.