We are BGSstaff, operating in an IT outstaffing format. This means you cooperate with us as an individual entrepreneur (IE), and we connect you to our clients' projects. We currently have an active request from a fintech company.
Full-time, remote from the Russian Federation
Responsibilities:
- Design new data marts, refine existing data marts in the Bank based on business requirements within the framework of the Bank's transition to PVR (Project Value Realization)
- Design data warehouse objects for corporate and retail risks within the PVR project:
- Communicate with business stakeholders
- Clarify business requirements
- Propagate data from the source system to the Data Mart layer
- Write technical documentation for all data warehouse layers (FSD, S2T)
- Coordinate the concept of designing data warehouse objects with the architect
- Conduct acceptance testing of data marts
Requirements:
- Higher education in natural sciences, engineering, or economics
- 5+ years of experience in data warehouse and/or Data Lake implementation/development projects
- 5+ years of experience in fintech within a DWH team
- Experience working with business stakeholders and clarifying business requirements
- Experience designing data marts for business stakeholders in a bank
- Deep knowledge of SQL (Oracle dialects), writing complex queries, reading PL/SQL code
- Experience designing database objects across all layers, understanding of data warehouse architecture
- Skills in describing data loading flows into DWH, compiling technical documentation (Source2Target, TOR, FSD)
- Experience in approving FSD and conducting Code Reviews
Will be a plus:
- Experience with ETL tools, specifically Informatica Power Center
- Experience with Open Metadata tool (or any other similar tool)
- Knowledge of reporting principles for regulators, understanding of PD, LGD, EAD, EL
Critical: Experience in banking projects, strong SQL, understanding of Data Warehousing
If you are ready to cooperate in an outstaff format, we await your response.
