Senior SQL & Reporting Specialist — Data & Dashboards in Katowice

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 o SQL o ETL o Experience in Banking / Financial Services, Regulatory reporting. o Understanding financial data (e.g. fund and index returns, portfolio holdings and valuation, asset classes: equities, bonds, derivatives etc. and their characteristics) o Experience with GIT repositories, preferably Bitbucket. o Experience in creating highly interactive data visualization dashboards. o Must have good written and verbal communication skills, and be able to communicate effectively in business terms with business partners.