Description
The Applied Analytics Platform of the Risk Block is a solution that enables the creation of analytical data marts on the Data Cloud for various business areas such as:
- calculation of optimal collection strategies
- calculation of restructuring proposals
- calculation of credit risk components PD, LGD, EAD
- acceleration of RWA calculation
- the process of calibrating industrial models
- portfolio, collection, and fraud analytics
We have over 120 data marts, 2000+ data loading streams, 1200 nodes, 40,000 cores, and 25+ petabytes of data.
Responsibilities
- participation in designing and developing data marts and warehouses
- participation in designing and implementing development automation tools
- participation in modifying industrial data marts.
Requirements
- at least 2 years of experience with one or more DBMS: Oracle, MS SQL, Teradata or Big Data stack DBMS
- experience in an analyst role with the function of preparing data extracts for the customer
- solid knowledge of SQL: complex queries, analytical functions, understanding of the physical implementation of joins, query performance optimization
- knowledge of one or more programming languages: PL/SQL, T-SQL, Java, Python, Scala at the level of variables, procedures, functions, loops, conditional operators
- knowledge of one or more ETL tools: Informatica, MS SSIS, SAS, ODI
- understanding of data warehouse organization principles, logical and physical model design approaches, understanding of the main challenges of data warehouses and approaches to solving them.
Conditions
- ability to choose an office near Kutuzovskaya or Tulskaya metro station
- work format: full-time office
- annual salary review and annual bonus
- corporate gym and relaxation areas
- more than 400 educational programs from SberUniversity for professional and career development
- extended VHI (Voluntary Health Insurance), preferential insurance for family members and corporate pension program
- flexible mortgage discount equal to 1/3 of the Central Bank's key rate
- free SberPrime+ subscription, discounts on products from partner companies
- referral bonus for recommending friends to join the Sber team
