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

Senior CDH (DWH) Analyst

We are looking for a Senior CDH Analyst for a large banking project team focused on developing the corporate data warehouse and calculating 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 borrowers' loan 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 PCR — Factor and portfolio analysis — RWA optimization — Development of functionality for test calculations of hypotheses without reflecting results in the Bank's reporting

Responsibilities

— Develop new and improve existing data marts within the framework of the Bank's transition to PCR — Develop and implement an industrial default data mart based on developed default criteria (default date, recovery date, default events, and other attributes) — Develop data marts with historical data and constants for past periods — Integrate historical data 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 — Experience preparing technical documentation (ToR) — Experience working with Jira

Will be a plus

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

To apply, please send your resume to Telegram: markeezzzy1