BA SQL Consultant

Delta-Capita

Greater London

Hybrid

GBP 50,000 - 70,000

Full time

12 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Hybrid working

Job summary

Delta Capita in London is seeking a Technical Business Analyst with SQL experience to support a data remediation and controls programme within a regulated banking environment.

The role bridges business requirements and data activities, documenting BRDs, SOPs, validating SQL-based populations, and ensuring governance and audit trails across data processes.

Qualifications

Proven experience as a Business Analyst with strong SQL skills.
Ability to write, understand, and troubleshoot SQL queries, including joins and data validation activities.
Experience producing BRDs, process maps, SOPs, and operational documentation.
Strong data analysis and reconciliation experience.
Experience working within banking, financial services, or other regulated environments.
Strong stakeholder management and communication skills.
Excellent attention to detail and governance mindset.

Responsibilities

Complete and maintain BRDs for data population control processes.
Elicit and document business and technical requirements from stakeholders.
Translate regulatory requirements into structured process documentation.
Create and maintain SOPs for recurring data activities and controls.
Support process improvement initiatives and identify efficiency opportunities.
Write and execute SQL queries including complex joins.
Document SQL logic used to identify and extract populations.
Perform data validation, testing, and reconciliation to ensure accuracy.

Skills

Business Analysis

SQL

Documentation

Stakeholder Management

Regulatory Compliance

Data Validation

Tools

SQL Tools

Job description

Role Overview:

We are seeking a Technical Business Analyst with SQL experience to support a data remediation and operational controls programme within a regulated banking environment.

This is a hybrid BA/SQL role requiring someone who can bridge business requirements and technical data activities. The successful candidate will be responsible for documenting requirements and processes, developing and validating SQL-based population controls, supporting regular data operations, and ensuring robust governance and operational controls are in place.

Key Responsibilities:

Business Analysis & Documentation

Complete and maintain Business Requirement Documents (BRDs) for data population control processes.
Elicit and document business and technical requirements from stakeholders.
Translate operational and regulatory requirements into clear, structured process documentation.
Create and maintain Standard Operating Procedures (SOPs) for recurring data activities and controls.
Support process improvement initiatives and identify opportunities to enhance operational efficiency.

SQL & Data Analysis

Write and execute SQL queries, including complex joins and data extraction activities.
Document SQL logic used to identify and extract customer populations.
Perform data validation, sample testing, and reconciliation activities to ensure outputs are accurate and fit for purpose.
Investigate data issues and support root-cause analysis.
Produce and maintain management information (MI) and reporting outputs.

Population Controls & Data Processes

Design and implement population control processes.
Validate data populations and ensure appropriate governance and audit trails are maintained.
Support sanctions screening, CRA pre-check activities, customer communications, and operational data processes.
Manage and monitor regular data runs, ensuring all controls are completed and evidenced.

Process Governance & Operational Support

Create and enhance SOPs covering:
- SharePoint operational processes and data outputs
- Sanctions screening updates
- CRA pre-check work item management
- Third-party supplier input/output processes
- MI production and reporting activities
Ensure all processes are documented, controlled, and aligned to regulatory expectations.

Essential Skills & Experience

Proven experience as a Business Analyst with strong SQL skills.
Ability to write, understand, and troubleshoot SQL queries, including joins and data validation activities.
Experience producing BRDs, process maps, SOPs, and operational documentation.
Strong data analysis and reconciliation experience.
Experience working within banking, financial services, or other regulated environments.
Strong stakeholder management and communication skills.
Excellent attention to detail and governance mindset.

Desirable Experience

Remediation, complaints, customer outcomes, or regulatory change programmes.
Data quality, data controls, or population control activities.
Exposure to sanctions screening, customer remediation, or operational risk programmes.
SharePoint and MI reporting experience.
Experience working with third-party suppliers and operational delivery teams.

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 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.

Expectations regarding hybrid working:

As we are a Service Provider and Consulting firm servicing clients, our policy for physically working from the office (which may be the clients' offices or our own offices depending on the client) aligns to what our clients' policies and expectations are and these vary. Most of our clients now require a minimum of 3 days per week in the office, 2 days from home, and accordingly this is also the minimum expectation that Delta Capita require.

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: