BGStaff
Senior/Tech Lead DWH Analyst (5+ years banking experience), outstaff, remote
up to 350,000 ₽
Full-time
Work format: remote possible
☑️ Responsibilities
- design of new data marts, enhancement of existing data marts in the Bank based on business requirements within the scope of the Bank's transition to the PVR project
- design of data warehouse objects for corporate and retail risks within the scope of the PVR project:
- communication with business stakeholders
☑️ Candidate Requirements
- data flow from source system to Data Mart layer
- writing technical documentation for all data warehouse layers (FSD, S2T)
- approval of data warehouse object design concept with the architect
- conducting PSI of data marts
- higher education in natural sciences, technical, or economics
- experience in data warehouse and/or Data Lake implementation/development projects for 5+ years
- experience in fintech in a DWH team for at least 5 years
- experience working with business stakeholders and clarifying business requirements
- experience in designing data marts for business stakeholders in a bank
- deep knowledge of SQL (Oracle dialects), writing complex queries, reading PL\SQL code
- experience in designing DB objects across all layers, understanding of data warehouse architecture
- skills in describing data loading processes into DWH, compiling technical documentation (Source2Target, ToR, FSD)
- experience in approving FSD and conducting Code Review
-Will be a plus:
- experience with ETL tools, with Informatica Power Center
- experience with Open Metadata tool (or any other similar tool)
- knowledge of reporting principles for regulators, understanding what PD, LGD, EAD, EL are
-Critical: experience in banking projects, strong SQL, understanding of DWH
-If you are ready to cooperate in an outstaff format, we look forward to your application
Contacts: recruiter contact
