Reach out directly about this role
#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
from 200,000 RUB
per month
from 3 years
Experience
Full-time
Employment
remote/hybrid
Work Format
Senior
Grade
System Analytics
Specialization
FinTech
Industry
By country
System Analytics
Specialization
FinTech
Industry