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.