🏦 Senior DWH Analyst (КХД)

We are looking for a Senior DWH Analyst for a large banking project team, focused on the development of the corporate data warehouse and the calculation of credit risks.

🌍 Location: Russian Federation 📍 Work format: remote / hybrid 💵 Salary: from 200,000 ₽ net

📊 About the project

The team is responsible for calculating the credit risk amount for the corporate borrower loan portfolio and Bank's securities based on internal ratings in accordance with Bank of Russia Regulation 483-P and Bank of Russia Instruction 199-I.

The project includes:

— Management reporting on RWA PV R — Factor and portfolio analysis — RWA optimization — Development of functionality for test calculations of hypotheses without reflecting the results in the Bank's reporting

🛠 Responsibilities

— Develop new and refine existing data marts as part of the Bank's transition to PV R — Develop and implement an industrial default mart based on developed default criteria (default date, recovery date, default events, and other attributes) — Develop marts with historical data and constants for past periods — Integrate historical marts into current and future data loading processes — Design database objects — Describe data loading flows into DWH — Prepare technical documentation (Source2Target, ToR)

🔎 Requirements

— Higher education in technical, economic, or natural sciences — At least 3 years of experience in DWH and/or Data Lake implementation or development projects — Deep knowledge of SQL (Oracle, PostgreSQL) — Experience writing complex SQL queries — Ability to read PL/SQL code — Experience in designing DB objects — Understanding of data warehouse architecture — Experience designing reports in MS SQL Reporting Services or Tableau — Experience describing data loading flows and preparing Source2Target documentation — Experience in preparing technical documentation (ToR) — Experience working with Jira

⭐️ Bonus points

— Experience with ETL tools (preferably Informatica Power Center) — Experience with ClickHouse — Experience with Greenplum