About this role
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.