> Markdown version of [/jobs/ext/1435182-sql-developer-lead](https://www.wearedevelopers.com/jobs/ext/1435182-sql-developer-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SQL Developer lead

- **Company:** Capgemini
- **Location:** Paisley, UK (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Software Quality, Computer Programming, Data Control, Data Distribution Service, Data Infrastructure, Data Profiling, Data Security, Data Systems, Database Development, Identity and Access Management, Microsoft SQL Server, Performance Tuning, SQL Stored Procedures, SQL Databases, Transact-SQL, Data Processing, Concurrency, Indexer, Software Coding, Stream Processing
- **Published:** July 25, 2026
- **Apply:** https://www.apply4u.co.uk/jobs/x/41898617/

## About the Role

We are a Disability Confident Employer:Capgemini is proud to be a Disability Confident Employer (Level 2) under the UK Government's Disability Confident scheme. As part of our commitment to inclusive recruitment, we will offer an interview to all candidates who:Declare they have a disability, andMeet the minimum essential criteria for the role.Please opt in during the application process.

## Description

About the Job you are considering:We are seeking an experienced SQL Developer Lead with strong expertise in database development, performance optimization, and data solutions within the Financial Services (FS) domain. The candidate will lead the design, development, and maintenance of SQL-based data applications, collaborate with business and technology stakeholders, and ensure high-quality, scalable, and secure data solutions that support financial operations, reporting, risk management, and regulatory compliance.
Hybrid working:The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time.
Your Role:Senior SQL Server developer with experience in programming, design and integration of data warehouse and data distribution platformsDesigns, builds and optimises T-SQL code (stored procedures, functions, views) and data models to produce trusted security/risk reporting and records-management-aligned datasetsEngineers resilient batch and near-real-time data processing, with strong data profiling, root-cause analysis and incident/problem management.Owns performance tuning and capacity considerations for SOL Server workloads (query plans, indexing strategy, partitioning, statistics, IO/CPU optimisation) to meet SLAs.Works with engineers, analysts and control owners to translate security, risk and records-management requirements into robust schemas, data quality rules, lineage and reconciliations; ensures solutions are testable, supportable and compliant.Leads by example through peer reviews, coding standards, release discipline and mentoring; proactively manages delivery risks and
dependencies across data platform, security, risk and governance stakeholders.
Your Skills:Expert T-SQL development (complex query design, stored procedures/functions, set-based approaches) with strong code quality and review discipline.Strong SQL Server performance engineering (execution plans, indexing, partitioning, temedh, concurrency) and ability to diagnose production issues under pressure.Testing mindset and automation: SOLt (or equivalent), data quality assertions, and ability to produce repeatable evidence for security/risk/control reportingGood understanding of secure database development and data controls (access management, auditing, sensitive data handling) and confidence engaging with security and risk stakeholders.


## Related Videos

- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Concurrency with Go](https://www.wearedevelopers.com/videos/191-concurrency-with-go)
- [Your Code as a Crime Scene](https://www.wearedevelopers.com/videos/1342-your-code-as-a-crime-scene)
- [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops)
- [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)

## Related Articles

- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)