
Senior SQL Developer
- Hybrid
- London, Greater London, United Kingdom
- Consulting
Job description
Contract role
Day rate. Location: London
Duration - Initial 3-month contract with potential to extend
Role 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.
Job requirements
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 3 offerings are:
Managed Services
Consulting & Solutions
Technology
To know more about Delta Capita and our culture click here: Working at DC - Delta Capita.
or
All done!
Your application has been successfully submitted!