#vacancy #analyst #dwh #khd #sql #oracle #postgresql #datalake #banks #fintech

🏦 Senior DWH Analyst (KHD)

We are looking for a Senior DWH (KHD) analyst to join a large banking project team, focused on the development of the corporate data warehouse and credit risk calculation.

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

📊 About the project

The team is responsible for calculating credit risk for the Bank's corporate borrowers and securities portfolio 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 VR — Factor and portfolio analysis — RWA optimization — Development of functionality for testing hypotheses without reflecting results in the Bank's reporting

🛠 Responsibilities

— Develop new and modify existing data marts as part of the Bank's transition to VR — 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, Statement of Work)

🔎 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 in 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 (Statement of Work) — Experience working with Jira

⭐️ Bonus points

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

📩 To apply, send your resume to Telegram: @markeezzzy1