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

🏦 Looking for a Senior DWH (Credit Risk Management) Analyst

💰 Salary: from 200,000 RUB net (negotiable) 📍 Format: remote / hybrid 📈 Long-term project in the banking sector

About the project

The team is responsible for calculating credit risks for corporate borrowers and securities in accordance with the requirements of the Bank of Russia (483-P, 199-I).

The project includes: — Management reporting on RWA CCP — Factor and portfolio analysis — Credit risk optimization — Development of mechanisms for hypothesis testing and calculation models

🛠 Responsibilities

— Develop new and enhance existing data marts as part of the Bank's transition to CCP — Create an industrial default mart (default date, recovery date, default events, and other attributes) — Work with historical data and integrate it into existing data flows — Design DB objects — Describe data loading processes (Source2Target) — Prepare technical documentation and specifications

🔍 Requirements

— Higher education in technical, economic, or natural sciences — Experience with DWH and/or Data Lake for 3+ years — Deep knowledge of SQL (Oracle, PostgreSQL) — Ability to write complex queries and read PL/SQL code — Experience in designing DB objects and understanding data warehouse architecture — Experience in building reports using Tableau or MS SQL Reporting Services — Experience in describing data loading processes and preparing Source2Target — Experience with Jira

➕ Will be a plus

— Informatica Power Center — ClickHouse — Greenplum — Experience in banking projects and risk reporting