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.

Requirements

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:; Who We Are:; 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 .