BA SQL Consultant

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: 

• Managed Services 

• Consulting & Solutions 

• Technology 

To know more about Delta Capita and our culture click here: Working at DC - Delta Capita.