📎 We are looking for a Senior Analyst for the KHD team

Duration: long-term Salary: up to 370 thousand (net, for individual entrepreneur)

Project Description: Calculation of credit risk amount for the loan portfolio of claims to corporate borrowers and securities of the Bank based on internal ratings (Bank of Russia Regulation 483-P) and in accordance with the Bank of Russia Instruction. Management reporting on RWA for Expected Losses (PD), factor and portfolio analysis, RWA optimization. Functionality for test calculations of hypotheses without reflecting in the Bank's reporting.

General description of tasks for KHD analysts: • Development of new data marts, refinement of existing data marts in the Bank based on Business Requirements within the framework of the Bank's transition to Expected Losses; • Develop and implement an industrial database (data mart) of defaults, based on the developed default criteria, including necessary attributes (e.g., default date, recovery date, default events, etc.); • Develop data marts with historical data, certain constants for past periods; • Integration of historical data marts into current (future) processes and data flows.

What you will need to do: • interact with business customers; • design target data marts (develop logical and physical structure of data marts); • prepare detailed documentation (FSD, s2t); • develop data quality controls; • conduct User Acceptance Testing (UAT) of data marts.

Requirements: ✔️ Higher education in natural sciences, technical, or economics; ✔️ 3+ years of experience in data warehouse and/or Data Lake implementation/development projects; ✔️ Deep knowledge of SQL (Oracle, PostgreSQL dialects), writing complex queries, reading PL\SQL code; ✔️ Experience in designing DB objects in all layers, understanding of data warehouse architecture; ✔️ Skills in describing data loading processes for the data warehouse (DWH), preparing technical documentation (Source2Target, Technical Specification, FSD); ✔️ Desirable experience with ETL tools, preferably Informatica Power Center; ✔️ Experience working with business customers and clarifying business requirements; ✔️ Experience in managing a team of 2+ people, building processes within the team, team training and mentoring; ✔️ Experience in approving FSD and conducting Code Reviews; ✔️ Understand the purpose of preliminary and final testing (PMI and PSI); ✔️ Experience with tracking systems, specifically JIRA.

Will be a plus: ✔️ Knowledge of reporting principles for regulators, understanding of PD, LGD, EAD, EL; ✔️ At least 5 years of experience in FinTech in a DWH team.