BA SQL Consultant

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.

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. For this role, a valid working permit for the UK is mandatory.

Expectations regarding hybrid working: 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.