Functional & Database Test Analyst

Charles Jenson Recruitment Ltd; City Of London; On-site; GBP 45,000 - 65,000; Full time

Job summary

Charles Jenson Recruitment Ltd in London seeks a seasoned Functional & Database Test Analyst to validate applications and ensure data integrity across integrated systems in a financial services environment.

You will collaborate with business analysts, developers and product owners, designing test plans, writing SQL queries and supporting UAT to deliver reliable software that meets complex data requirements.

Qualifications

• Bachelor’s or Master’s degree in engineering or a related discipline.
• Financial services domain knowledge is advantageous.
• Solid understanding of SDLC, STLC, test design techniques and Agile Scrum.
• Ability to translate requirements into test scenarios and coverage.
• Experience validating data across applications and databases.

Responsibilities

• Analyse requirements, specifications, user stories and data mappings to set testing objectives and acceptance criteria.
• Design and maintain test plans, scenarios, test cases and test data for positive/negative scenarios.
• Execute smoke, sanity, system, integration, regression and end-to-end tests.
• Write and execute SQL queries to validate data, calculations and business rules.
• Investigate data issues using logs and database records, document defects with steps and evidence.
• Triage defects with development teams, verify fixes and support resolution.
• Maintain traceability between requirements, tests and defects; report progress and risks.
• Support UAT by preparing business scenarios and collaborating with stakeholders.

Skills

Functional testing

SQL

Data validation

UAT support

Education

Bachelor's or Master's in engineering or related discipline

Tools

Jira

Azure DevOps

Job description

Functional & Database Test Analyst

Location: London

The Opportunity

Are you an experienced QA professional with strong functional testing and SQL skills? We're looking for a Functional & Database Test Analyst to help ensure applications perform as expected and business-critical data is accurate, consistent and reliable.

Working closely with business analysts, developers, product owners and end users, you'll play a key role in validating application functionality, testing end-to-end business workflows and investigating data issues across integrated systems.

This is an opportunity to apply your technical testing expertise within a financial services environment, helping deliver high-quality applications that meet complex business and data requirements.

Key Responsibilities

• Analyse business requirements, functional specifications, user stories and data mappings to establish clear testing objectives and acceptance criteria.
• Design and maintain test plans, scenarios, test cases and test data covering positive and negative scenarios, boundary conditions and exception handling.
• Execute smoke, sanity, system, integration, regression and end-to-end testing across applications and connected systems.
• Write and execute SQL queries using joins, subqueries, grouping and aggregate functions to validate data, calculations and business rules.
• Perform source-to-target data reconciliation, identifying missing, duplicate, inaccurate or inconsistent records and verifying data transformation rules.
• Investigate application and data issues using system behaviour, logs and database records, documenting defects with clear reproduction steps and supporting evidence.
• Work with development teams to triage defects, verify fixes and support effective resolution.
• Maintain traceability between requirements, test cases and defects, assess the impact of changes, and report test progress, coverage, blockers and release risks.
• Support User Acceptance Testing (UAT) by preparing business scenarios, investigating reported issues and collaborating with business stakeholders throughout the delivery lifecycle.

About You

You'll be a detail-oriented and analytical testing professional who can combine functional testing expertise with strong database validation skills. You'll be comfortable working with technical teams and business stakeholders to understand requirements, investigate issues and deliver reliable results.

You’ll ideally bring:

• A bachelor's or master's degree in engineering or a related discipline, alongside relevant experience in manual functional and database testing.
• Financial services domain knowledge, particularly in one or more of the following areas: finance, investments, portfolio management, portfolio construction, Outsourced Chief Investment Officer (OCIO) applications, trading, cash management, compliance, risk or capital markets.
• A strong understanding of the Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), test design techniques, defect management and Agile Scrum methodologies.
• The ability to translate business requirements and acceptance criteria into effective test scenarios, expected results and comprehensive test coverage.
• Hands-on experience testing application functionality, business workflows, calculations, role-based access and system integrations.
• Experience validating data across applications, reports, database tables and integrated systems, including source-to-target reconciliation.
• Strong SQL skills, including joins, subqueries, grouping and aggregate functions, with experience using a relational database such as Oracle, SQL Server, PostgreSQL or MySQL.
• A practical understanding of database tables, keys, relationships, constraints and transactions, with the ability to investigate data integrity issues.
• Experience using Jira, Azure DevOps or equivalent tools for test management, defect tracking and progress reporting.
• Experience supporting UAT and collaborating effectively with business analysts, developers, product owners and business users.
• Strong analytical and problem-solving skills, excellent attention to detail, clear communication and the ability to manage competing priorities.

Desirable Experience

Experience in any of the following areas would be an advantage:

• Testing stored procedures, ETL processes, data migrations or data warehouse workflows.
• API testing using tools such as Postman or Bruno.
• Functional test automation.