Senior SQL Test Analyst

Squareone; Greater London; Presencial; GBP 83.000 - 120.000; Jornada completa

Descripción de la vacante

Square One Resources Limited is seeking an experienced Senior SQL Test Analyst to join a financial services organisation on a six-month contract in London. You will own testing across complex financial applications, using SQL to verify data accuracy and consistency across systems, and to support releases with stakeholders.

The role requires hands-on SQL, relational database testing (Oracle/SQL Server) and experience within banking, investments, asset management or capital markets environments,

Formación

• Proven experience delivering functional and database testing within financial services environments.
• Strong hands-on SQL skills to independently investigate complex data issues.
• Experience testing relational databases, ideally Oracle or SQL Server.
• Understanding of data reconciliation, validation and testing across interconnected systems.
• Knowledge of financial products and processes in banking, investments or asset management.
• Experience with structured testing lifecycles and Agile delivery.
• Familiarity with defect tracking and test management tools (Jira, Azure DevOps).

Responsabilidades

• Take ownership of testing activities across financial applications, from interpreting requirements through to execution and defect resolution.
• Use SQL to investigate underlying data, verify financial calculations and identify inconsistencies between systems.
• Assess data quality and integrity across databases, interfaces and reporting environments.
• Carry out functional, integration and regression testing to ensure systems operate reliably across business processes.
• Examine data movements and transformations, investigating discrepancies and working with technical teams to resolve issues.
• Produce test documentation, record defects and communicate testing progress to project stakeholders.
• Work alongside developers, business analysts and end users to support testing activities and successful releases.

Conocimientos

SQL Testing

Financial Services Testing

Data Reconciliation

Agile Testing

Test Lifecycle

Herramientas

Oracle

SQL Server

Jira

Azure DevOps

Descripción del empleo

Job Title:Senior SQL Test Analyst
Location: London
Start Date: November
Job Type: Inside IR35

We are seeking an experienced Senior SQL Test Analyst to join a financial services organisation on an initial six-month contract.

The role will involve working across complex financial applications, ensuring that business processes function correctly and that information is accurately processed, transferred and maintained across multiple systems.

We are particularly interested in candidates who combine strong SQL and database testing capabilities with a solid understanding of financial services, ideally gained within banking, investment management, asset management or capital markets environments.

Key Responsibilities

• Take ownership of testing activities across financial applications, from interpreting requirements through to execution and defect resolution.
• Use SQL to investigate underlying data, verify financial calculations and identify inconsistencies between systems.
• Assess data quality and integrity across databases, interfaces and reporting environments.
• Carry out functional, integration and regression testing to ensure systems operate reliably across business processes.
• Examine data movements and transformations, investigating discrepancies and working with technical teams to resolve issues.
• Produce test documentation, record defects and communicate testing progress to project stakeholders.
• Work alongside developers, business analysts and end users to support testing activities and successful releases.

Required Skills & Experience

• Proven experience delivering functional and database testing within financial services environments.
• Strong hands-on SQL skills, with the ability to independently investigate complex data issues.
• Experience testing relational databases, ideally Oracle or SQL Server.
• A solid understanding of data reconciliation, validation and testing across interconnected systems.
• Knowledge of financial products, transactions or processes within banking, investments, asset management, trading, risk or compliance.
• Experience working within structured testing lifecycles, including Agile delivery environments.
• Familiarity with defect tracking and test management tools such as Jira or Azure DevOps.

Advantageous Experience

• Testing ETL processes, data warehouses or large-scale data migrations.
• Experience validating stored procedures and complex data transformations.
• API testing or exposure to test automation frameworks.

Disclaimer

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.