Delta Capita Logo

Delta Capita

BA SQL Consultant

Posted 8 Days Ago
Be an Early Applicant
Hybrid
London, Greater London, England, GBR
Mid level
Hybrid
London, Greater London, England, GBR
Mid level
Technical Business Analyst role bridging business requirements and SQL-based data activities for a banking remediation programme. Responsibilities include BRDs, SOPs, SQL query development and validation, population controls, data reconciliation, MI/reporting, stakeholder engagement, and ensuring governance and audit-ready processes within a regulated environment.
The summary above was generated by AI

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.

Essential Skills & Experience
  • 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.

Desirable Experience
  • Remediation, complaints, customer outcomes, or regulatory change programmes.

  • Data quality, data controls, or population control activities.

  • Exposure to sanctions screening, customer remediation, or operational risk programmes.

  • SharePoint and MI reporting experience.

  • Experience working with third-party suppliers and operational delivery teams.

How We Work:  

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.  

This is a fixed-term position located in London. As the selection and interview process is ongoing, please submit your application in English as soon as possible, if your profile is selected, a member of our team will contact you within 4 weeks. For this role, a valid working permit for the UK is mandatory.  

Expectations regarding hybrid working: As we are a Service Provider and Consulting firm servicing clients, our policy for physically working from the office (which may be the clients' offices or our own offices depending on the client) aligns to what our clients' policies and expectations are and these vary. Most of our clients now require a minimum of 3 days per week in the office, 2 days from home, and accordingly this is also the minimum expectation that Delta Capita require. 

Who We Are:  

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  

To know more about Delta Capita and our culture click here: Working at DC - Delta Capita.  

Similar Jobs

5 Minutes Ago
Hybrid
London, Greater London, England, GBR
Senior level
Senior level
AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Own the end-to-end design, development, deployment, and operation of high-throughput, low-latency distributed pricing services. The role involves architecture reviews, API design, coding, testing, documentation, code reviews, operational excellence, resiliency, scalability, and caching. Partner with business stakeholders, solve complex technical problems, recommend architectural improvements, and mentor team members while collaborating on globally distributed Agile teams.
Top Skills: AgileAWSContinuous DeliveryContinuous IntegrationCouchbaseDynamoDBGitJavaKotlinMemcachedMicroservicesMicrosoft Sql ServerRedisScalaSpring
30 Minutes Ago
Remote or Hybrid
UK
Senior level
Senior level
HR Tech • Information Technology • Professional Services • Sales • Software
Own the full enterprise SaaS sales cycle in the UK, from outbound prospecting and discovery through negotiation and close. Build relationships with companies of 1,000+ employees, manage multiple stakeholders, partner with Sales Engineering on demonstrations, maintain Salesforce data, attend industry events, and collaborate cross-functionally to drive revenue growth.
Top Skills: SaaSSalesforce
30 Minutes Ago
Remote or Hybrid
UK
Expert/Leader
Expert/Leader
HR Tech • Information Technology • Professional Services • Sales • Software
Manage multiple complex UK payrolls end to end for outsourced-service customers. Provide expert guidance on UK payroll legislation, statutory payments, pensions, benefits in kind, share schemes, taxation, reconciliations, HMRC submissions, and year-end processing. Resolve discrepancies, advise enterprise customers, build trusted relationships, mentor colleagues, and contribute to documentation and continuous improvement.
Top Skills: AsanaAuto EnrolmentHmrcNational InsuranceP11DPayePayroll ApisPayroll IntegrationsReal Time Information (Rti)SlackZendesk

What you need to know about the London Tech Scene

London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account