DWH Architect-Analyst

• Development of new and refinement of existing data marts as part of the Bank's transition to PWR
• Design of the logical and physical structure of target data marts
• Development of an industrial default database with necessary attributes: default date, recovery date, default events, etc.
• Development of data marts with historical data and constants for previous periods
• Integration of historical data marts into current and future DWH processes
• Interaction with business stakeholders
• Preparation of detailed technical documentation: FSD, S2T
• Development and implementation of data quality controls
• Conducting PSI (Pre-Shipment Inspection) of data marts

• 5+ years of experience in FinTech within a DWH team
• 2+ years of team management experience: process building, training, and mentoring
• Higher education in technical, natural sciences, or economics
• 3+ years of experience in implementing and developing DWH and/or Data Lake
• Deep SQL knowledge: Oracle, PostgreSQL
• Experience in writing complex SQL queries and reading PL/SQL code
• Experience in designing database objects across all DWH layers
• Deep understanding of data warehouse architecture
• Experience in describing data loading flows and preparing documentation: Source2Target, S2T, Technical Specification, FSD
• Experience interacting with business stakeholders and clarifying business requirements
• Experience in approving FSD and conducting Code Reviews
• Understanding of PMI (Process-based Management Information) and PSI processes
• Knowledge of regulatory reporting principles
• Understanding of PD, LGD, EAD, EL metrics
• Experience with Jira

from 320,000 to 340,000 ₽ Full-time Work format: remote possible