Контакты

MS SQL Engineer

Prague, Czech Republic

Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.

DESCRIPTION


Currently we are looking for an MS SQL Engineer for our Prague office to make the team even stronger.

ABOUT PROJECT


Our client is an investment bank which provides large corporate, government and institutional clients with a full spectrum of solutions to their strategic advisory, financing and risk management needs.

The main function of project is to consolidate, streamline and simplify the generation, analysis and visualization of risk within the investment bank onto strategic, cross-asset platforms. The migration from a legacy, siloed, asset class specific environment to a shared, cross-asset, platform is a complex one and we are running that work as a program.

The candidate will join the project delivering regulatory driven improvements in credit risk methodology with significant impact on the bank’s RWA. As part of the program, the project is delivering new credit risk valuation and simulation capability as well as infrastructure components. The scope includes large spectrum of products across the asset classes (Fixed Income, FX, and Equities) with varying degree of complexity presenting highly interesting technology challenges.

Responsibilities

  • Design and implement changes to Risk Engine valuation results data store in SQL Server DB;
  • Design and implement ETL processes, using SSIS services;
  • Design, review and implement a scalable data model for CR framework;
  • Be responsible for performance tuning and re-factoring of the existing DB processing routines.

Requirements

  • University degree;
  • At least 2 years of IT development experience with RDBMS;
  • Experience in data modelling with excellent SQL skills in at least several enterprise grade RDMBS;
  • Experience with huge data volumes & complex ETL processes;
  • Programming knowledge of T-SQL & SSIS;
  • Preferably hands-on experience with PowerShell or Python scripting language;
  • Experience in Test/Behavior-Driven Development (including test automation and mocking tools);
  • Understanding of Agile methodologies and SDLC phases;
  • Keen, enthusiastic and willing to learn;
  • Strong team player with ability to work independently and proactively;
  • Strive to own end-to-end solutions to problems;
  • Ability to build productive working relationships with other IT groups, business users and support teams in multiple geographic locations;
  • Excellent problem solver;
  • Professional presentation and communication skills.

Nice to have

  • Understanding of the investment banking business; willingness and capacity to learn complex financial concepts;
  • Specific product knowledge of any of the following: equities (preferred), FX, commodities, debt products, credit derivatives, other derivative financial instruments;
  • Understanding of the investment banking business; willingness and capacity to learn complex financial concepts;
  • Knowledge of and experience with QlikView;
  • Knowledge of and experience with SAP BO;
  • Knowledge of C# is very nice to have.

We offer

  • We offer the possibility to work on full product lifecycle – from concept to delivery into production;
  • We are open for innovations and modern technologies;
  • We offer guaranteed professional growth through the technology trainings and technology communities inside EPAM;
  • We are proactive Agile/Scrum/XP practitioners;
  • We propose to realize your ideas and potential within the democratic environment;
  • Using English on a daily basis, communication with people from different countries;
  • As a team - we bring in all our empathy, synergy and drive to focus on the client – bringing world class experience online;
  • Competitive compensation depending on experience and skills;
  • Comfortable and modern offices in Prague 4;
  • Benefit program (5 weeks of vacation, 5 sick days, wage compensation for the first three days of illness, meal vouchers, flexi pass, annual coupon of Prague city public transport, multisport cards);
  • Start ASAP/negotiable.