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.