Senior SQL Developer

Delta Capita; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading professional services organization in London seeks an experienced SQL Developer for an initial 3-month contract role. You will design and develop SQL logic for financial redress calculations, ensuring compliance with FCA guidelines. The ideal candidate has expert-level SQL Server development skills and proven experience in financial services. Applications in English are encouraged and a valid UK working permit is required.

Qualifications

• Expert-level SQL Server development including stored procedures and tuning.
• Experience in financial services, ideally within consumer credit.
• Ability to implement regulatory requirements into technical solutions.

Responsibilities

• Design and develop SQL Server-based redress calculation logic.
• Collaborate with business analysts for accurate implementation.
• Ensure data integrity and compliance with FCA guidelines.

Skills

Expert-level SQL Server development

Proven experience in financial services

Strong understanding of data modelling

Experience working with Excel/VBA integration

Ability to interpret regulatory requirements

Excellent communication skills

Tools

SSIS

Excel

Python

Job description

Contract role

Day rate. Location: London

Duration - Initial 3-month contract with potential to extend

Overview

An experienced SQL Developer is required to join a leading professional services organisation to work on a time critical programme. In January 2024, the FCA announced a review into whether motor finance customers have been overcharged because of the past use of discretionary commission arrangements (DCA).

In October 2024, the Court of Appeal held that motor dealers, acting as credit brokers, owe particular duties to customers to disclose commission paid by lenders to them. Lenders were also deemed to be liable for any deficiencies in the dealers’ disclosure of these commissions.

The programme has been initiated to resolve the complaints for the Discretionary Commission Arrangements (DCA), post the CoA judgement.

Joining the solutions engineering team, you will work alongside the existing development and change management teams to build robust redress calculators capable of handling both bulk and individual calculations.

Key Responsibilities

• Design and develop SQL Server-based redress calculation logic, including stored procedures, views, and functions.
• Translate complex financial rules (e.g. commission rates, interest calculations) into efficient SQL logic.
• Build scalable solutions to support bulk processing of customer agreements.
• Collaborate with business analysts and regulatory SMEs to ensure accurate implementation of redress rules.
• Ensure data integrity, performance optimization, and compliance with FCA guidelines.
• Support integration with Excel/VBA-based front-end tools or alternative platforms.
• Participate in testing, validation, and deployment phases.
• Provide documentation and knowledge transfer to internal teams.

Required Skills & Experience

• Expert-level SQL Server development, including advanced stored procedures, indexing, and performance tuning.
• Proven experience in financial services, ideally within consumer credit, motor finance, or regulatory remediation.
• Strong understanding of data modelling, ETL processes, and bulk data operations.
• Experience working with Excel/VBA integration or similar front-end tools.
• Ability to interpret and implement regulatory requirements into technical solutions.
• Familiarity with FCA regulations, especially around Consumer Credit Act and redress schemes (preferred).
• Excellent communication and documentation skills.

Desirable Skills

• Experience with SSIS/SSRS or other reporting tools.
• Knowledge of Python or R for data validation and analytics.
• Exposure to cloud-based SQL environments (e.g. Azure SQL).
• Experience working in Agile delivery environments.

How We Work

Delta Capita is an equal opportunity employer. We positively encourage applications from suitably qualified and eligible candidates regardless of age, colour, disability, national origin, ancestry, race, religion, gender, sexual orientation, gender identity and/or expression, veteran status, genetic information, or any other status protected by applicable law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. If you require any reasonable adjustments through your interview process, please use the designated space within the application questionnaire.

This is a fixed term full time position located in London. As the selection and interview process is ongoing, please submit your application in English as soon as possible. If your profile is selected, a member of our team will contact you within 4 weeks. For this role a valid working permit for the UK is mandatory.

Who We Are

Delta Capita Group (a member of the Prytek Group) is a global managed services, consulting and solutions provider with a unique combination of experience in Financial Services and technology innovation capability. Our mission is to reinvent the financial services value chain providing technology based mutualized services for financial institutions for non-differentiating services.

Our Offerings

• Managed Services
• Consulting & Solutions
• Technology

To know more about Delta Capita and our culture, remove the link text above as needed.