SQL Developer

Delta Capita; Greater London; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Delta Capita in London is seeking a SQL Developer to design performant SQL assets, data models, and high-quality queries within a governed environment. You will collaborate with analysts, product and engineering teams to deliver reliable solutions in a smart work stack and structured consulting delivery model.

Key responsibilities include designing and optimising SQL objects, developing data models, tuning performance, and implementing validation checks.

Qualifications

• Advanced SQL development experience (T-SQL, PL/SQL, or equivalent) with strong performance-tuning skills.
• Strong data modelling knowledge (star/snowflake schemas, indexing strategies, optimisation).
• Experience in structured consulting or delivery environments with clear processes and standards.
• Understanding of CI/CD practices, version control (Git), and database change management.
• Strong troubleshooting, analytical, and communication skills.

Responsibilities

• Design, build, and optimise SQL objects including tables, views, stored procedures, functions, and ETL/ELT logic.
• Develop logical and physical data models and maintain ERDs and data dictionaries.
• Tune SQL performance (indexing, partitioning, query optimisation).
• Implement validation rules, constraints, and reconciliation checks to ensure data quality.

Skills

Advanced SQL development

Data modelling

Consulting / delivery environments

CI/CD practices

Git / version control

Analytical & troubleshooting

Communication skills

Tools

Git

Job description

We are seeking a SQL Developer to support a major client project, working within a smart work stack and structured consulting delivery model. The role focuses on designing performant SQL assets and data models, tuning high‑quality application queries, and collaborating closely with analysts, product, and engineering teams to deliver reliably in a governed environment.

Key Responsibilities:

• Design, build, and optimise SQL objects including tables, views, stored procedures, functions, and ETL/ELT logic.
• Develop logical and physical data models and maintain ERDs and data dictionaries.
• Tune SQL performance (indexing, partitioning, query optimisation).
• Implement validation rules, constraints, and reconciliation checks to ensure data quality.

Pipelines & Environments

• Contribute to ETL/ELT pipelines and environment promotion using standardised patterns.
• Use version control (Git) and CI/CD workflows for database changes.
• Collaborate with platform/DevOps teams on capacity management, monitoring, and backup/recovery strategies.

Smart Work Stack & Delivery Discipline

• Work within a structured delivery approach (story backlog, layered delivery model, reusable components).
• Apply consulting‑grade practices such as documentation, peer reviews, test execution, and quality checkpoints.
• Participate in Agile ceremonies (stand‑ups, planning, retros).

Collaboration & Stakeholder Engagement

• Partner with BAs, product owners, and downstream consumers to translate requirements into robust SQL designs.
• Support UAT, investigate defects, and resolve logic issues quickly.
• Produce runbooks, knowledge‑transfer materials, and follow governance/security standards.

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.

Required Skills & Experience:

• Advanced SQL development experience (T‑SQL, PL/SQL, or equivalent) with strong performance‑tuning skills.
• Strong data modelling knowledge (star/snowflake schemas, indexing strategies, optimisation).
• Experience working in structured consulting or delivery environments with clear processes and standards.
• Understanding of CI/CD practices, version control (Git), and database change management.
• Strong troubleshooting, analytical, and communication skills.

This is a fixed-term position located in London with hybrid working. 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.