BA SQL Consultant at Delta Capita | GB | Rezi

BA SQL Consultant at Delta Capita

BA SQL Consultant

Delta Capita · GB

1 weeks ago

BA SQL Consultant

Delta Capita · GB

13 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Seeking a Technical Business Analyst with SQL experience to support a data remediation and operational controls program within a regulated banking environment. This hybrid role requires bridging business requirements and technical data activities, including documenting requirements, developing SQL-based controls, supporting data operations, and ensuring robust governance.

Responsibilities

  • 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.
  • 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.
  • 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.
  • 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, and MI production and reporting activities.
  • Ensure all processes are documented, controlled, and aligned to regulatory expectations.

Requirements

  • 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.
  • A valid working permit for the UK is mandatory.

Skills

  • SQL
  • Business Analysis
  • Data Analysis
  • Data Validation
  • Reconciliation
  • Stakeholder Management
  • Communication
  • BRD creation
  • SOP creation
  • Process Documentation
  • SQL Query Writing
  • SQL Troubleshooting
  • SQL Joins
  • Data Extraction
  • Root Cause Analysis
  • Management Information (MI) Reporting
  • Population Controls
  • Governance
  • Audit Trails
  • Sanctions Screening
  • CRA Pre-check Activities
  • Customer Communications
  • SharePoint
  • Third-party Supplier Management

Location

  • London

Work Type

  • Hybrid
  • Fixed-term

Experience Level

  • Minimum 3 days per week in the office, 2 days from home

About the Company

  • Delta Capita Group (a member of the Prytek Group) is a global managed services, consulting, and solutions provider with a unique combination of experience in Financial Services and technology innovation capability.
  • Our mission is to reinvent the financial services value chain providing technology based mutualized services for financial institutions for non-differentiating services.
  • Our 3 offerings are: Managed Services, Consulting & Solutions, Technology.

Equal Opportunity

  • Delta Capita is an equal opportunity employer. We positively encourage applications from suitably qualified and eligible candidates regardless of age, colour, disability, national origin, ancestry, race, religion, gender, sexual orientation, gender identity and/or expression, veteran status, genetic information, or any other status protected by applicable law.
  • We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. If you require any reasonable adjustments through your interview process, please use the designated space within the application questionnaire.