
Business Tester – Investment Products
Spyrosoft • Warsaw, Masovian Voivodeship, Poland
-
Role & seniority
- Business/functional Test Analyst (investment services), mid-level (implied by scope and cross-team execution)
-
Stack/tools
-
SQL (direct DB verification of balances/holdings/transactions)
-
Excel (independent calculation + compare to system outputs)
-
Jira (test/defect management)
-
SIT/UAT participation (defect logging/retest/closure)
-
Test artifacts: test plans, scenarios, test data/results
-
-
Top 3 responsibilities
-
Design, document, and execute end-to-end whole-journey test cases for investment products (account opening → order → execution/settlement → servicing events/tax outcomes).
-
Validate financial correctness: valuations, rates of return, commissions/fees, client/supervisor statements, regulatory reporting; reproduce calculations in Excel and verify via SQL.
-
Coordinate within scope: run SIT/UAT, manage defects in Jira, report status/risks, and ensure traceable documentation/results.
-
-
Must-have skills
-
Financial-sector experience in business/functional testing with investment products/processes.
-
Understanding of investment lifecycle: placement, funding checks, execution, settlement, then servicing (income distributions, unit adjustments).
-
Ability to query databases with SQL for independent validation.
-
Strong Excel for calculation replication and catching rounding/numerical drift.
-
Comfort operating between **product owners and engi
-
Full Description
This is a long-running programme around the bank's investment offering: extending what clients can buy and how they are served, and keeping the underlying journeys and applications current as regulation and commercial priorities move. You will work across a portfolio of initiatives rather than a single release. You will be a good fit if you have tested investment-services change before, are comfortable operating between product owners and engineers, and can take a scenario from design through execution to a clear status report.
Required Qualifications
- Experience in business or functional testing in the financial sector, ideally with investment products and processes
- An understanding of how an investment order progresses – placement, funding checks, execution and settlement – together with the servicing events that follow, such as income distributions and unit adjustments
- Ability to design, document and run test cases, including whole-journey scenarios that follow a client from account opening through to correct financial and tax outcomes
- Ability to query the database directly – using SQL to confirm balances, holdings and transaction history independently of the application interface
- Strong Excel skills – able to reproduce a calculation independently and hold the result up against the system's own output
- Comfortable working in a test and defect management tool such as Jira
- Patience for detailed, repetitive verification, with a low tolerance for rounding differences and numerical drift
Nice to Have
- Familiarity with the compliance layer around investment sales – suitability assessment, client risk classification and transaction monitoring for AML purposes
- Understanding of the tax aspects of investment products, including the settlement of investment income and tax-efficient account types
- Experience proving out a data migration – confirming that historical records, balances, holdings and client profiles arrived intact in the target system
- Experience testing change that originates in an audit finding or a new regulatory requirement rather than in a product idea
- Experience testing across system boundaries, where the investment platform depends on core banking, CRM or an external provider
- Prior work on digital investment channels, or on digitalising investment processes end to end
Scope of Services
- Design, document and execute test cases and end-to-end scenarios for investment products and the applications supporting them
- Confirm that the system's numbers hold – portfolio valuations, rates of return, commissions and management fees
- Confirm the accuracy of everything the system issues to clients and supervisors – statements, transaction listings and regulatory reporting
- Verify data at source in the database and independently reproduce bulk financial operations to confirm the system's output
- Participate in SIT and UAT – log and document defects, retest fixes and track them through to resolution
- Coordinate testing activity within your scope and report progress, status and risks
- Prepare and maintain test documentation, including test plans, scenarios, test data and results