Senior DWH Analyst

🏦 Senior DWH Analyst

We are looking for a Senior DWH analyst for a large banking project focused on the development of a corporate data warehouse and credit risk calculation.

🌍 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 borrowers' credit portfolio and the Bank's securities based on internal ratings in accordance with Regulation of the Bank of Russia 483-P and Instruction of the Bank of Russia 199-I.

The project includes:

— Management reporting on RWA PVPR — Factor and portfolio analysis — RWA optimization — Development of functionality for testing hypothesis calculations without reflecting results in the Bank's reporting

🛠 Responsibilities

— Develop new and improve existing data marts within the scope of the Bank's transition to PVPR — 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, Technical Specifications)

🔎 Requirements

— Higher education in technical, economic, or natural sciences — Minimum 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 database object design — 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 preparing technical documentation (Technical Specifications) — Experience working with Jira

⭐️ Bonus points

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