SQL Server Lead

This job is with Capgemini, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

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 platforms
• Designs, builds and optimises T-SQL code (stored procedures, functions, views) and data models to produce trusted security/risk reporting and records-management-aligned datasets
• Engineers 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 reporting
• Good understanding of secure database development and data controls (access management, auditing, sensitive data handling) and confidence engaging with security and risk stakeholders.

We are a Disability Confident Employer:

Capgemini is proud to be a