Senior SQL/ Reporting Specialist

Luxoft Poland; Polska; On-site; PLN 60,000 - 90,000; Full time

Job summary

Luxoft Poland is seeking skilled QA/Test professionals to join a cross-location project focused on upgrading a financial services reporting platform.

You will write and execute test cases for ETL processes, validate data accuracy across funds and portfolio holdings, and collaborate with Process and Product teams to ensure SIT and Dry Run readiness. Strong SQL, data visualization, and Bitbucket experience are valuable here.

Qualifications

• Experience in Banking/Financial Services and regulatory reporting.
• Understanding financial data (funds, returns, holdings) and valuation.

Responsibilities

• Write and execute test cases with guidance from Process Experts.
• Log defects and verify fixes with delivery teams.
• Prepare test data and test sets with Process Teams.
• Execute SIT test cases and document results and evidence.
• Be primary contact for testing questions from Process/Product Teams.

Skills

SQL

ETL

Finance domain

Data visualization

Git/Bitbucket

Communication

Tools

Bitbucket

Job description

Private Medical & Dental care & Life Insurance

Internal Mobility program - possibility of rotation between projects, locations, accounts

Project Description

Our Customer is one of the world's largest investment management companies. Based in Southern California, our client manages close to $2 trillion in assets and is looking for a new partner to participate in a full scale upgrade of their technology. We are looking for talented and ambitious people to work on crosslocation engagement spread accross Los Angeles, California, Switzerland, Genewa and Krakow. We have a huge opportunity to impress them and earn a large share of their new and existing business.

The team will be responsible for developing and maintaining reporting tool based on SimCorp's Coric solution. Since it is rare and unique knowledge, the position will give opportunity to participate in proper trainings and gather required domain understanding.

Responsibilities

• Write Test Cases with the support and mentoring of Process Experts, based on the process documentation and the agreed macro test scenarios.


• Each Test Case has steps, expected results and test data needs.


• Support Test Case Validation with the Process Teams.


• Help the Product Teams prepare and run the functional Dry Runs before SIT.


• Log defects and retest fixes.


• Prepare test sets and test data needs with the Process Teams.


• Execute SIT Test Cases and record results and evidence.


• Log defects, follow them up with the delivery teams and retest.


• Be the first contact for testing questions from the Process Teams and Product Teams.


• Report progress, defects and blockers to the C&A Test Managers.


• Sign-Off stays with the Process Teams (SIT) and the Product Teams (Dry Runs).

Skills

What is relevant to have

• SQL


• ETL


• Experience in Banking / Financial Services, Regulatory reporting.


• Understanding financial data (e.g. fund and index returns, portfolio holdings and valuation, asset classes: equities, bonds, derivatives etc. and their characteristics)


• Experience with GIT repositories, preferably Bitbucket.


• Experience in creating highly interactive data visualization dashboards.


• Must have good written and verbal communication skills, and be able to communicate effectively in business terms with business partners.