About the project:
Support and development of the bank's regulatory reporting system (Central Bank of the Russian Federation) based on a unified data warehouse (EDH).
What you will be doing:
- Analysis of Central Bank of the Russian Federation requirements and translation into data requirements
- Searching and analyzing data in source systems and DWH
- Building data lineage (from source to reporting form)
- Developing reporting logic
- Preparing technical specifications and SQL prototypes
- Assigning tasks for ETL and monitoring implementation
- Performing reconciliations and monitoring data quality
- Analyzing and correcting discrepancies and errors in reporting
- Analyzing the impact of changes in regulatory documents of the Central Bank of the Russian Federation on reporting
- Testing enhancements (functional and data)
- Interaction with the business (accounting, reporting)
What we expect from the candidate:
- Experience with regulatory reporting of the Central Bank of the Russian Federation is mandatory
- Understanding of banking accounting (accounts, entries, balances)
- Proficient SQL (writing complex queries, data reconciliations)
- Experience with data warehouses (DWH / EDH)
- Experience in analyzing data sources and building data chains (data lineage)
- Experience in preparing technical specifications for development
- Testing experience (including data verification)
- Experience with regulatory reporting systems (Flextera / Diasoft / similar)
Will be a plus:
- Oracle / PL SQL
- ETL tools
- Experience with APEX
- Experience with CBS (CFT or similar)
- Experience with large data volumes