Hybrid SQL Developer: Data Modeling & Performance Tuning

Delta Capita; Greater London; Hybrid; 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

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.