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.