Data Warehouse Analyst

Project: fintech

Mandatory requirements:

• Higher education in natural sciences, technical, or economics

• Experience as an analyst on data warehousing projects

• Experience with banking reporting, knowledge of Bank of Russia reporting

• Knowledge of the methodology for calculating mandatory ratios of the Bank of Russia

• Understanding of the reporting automation lifecycle: from gathering and formalizing requirements to implementing changes and accepting results

• Experience in gathering, analyzing, and formalizing customer requirements

• Experience in preparing technical specifications for the development and refinement of data warehouses

• Understanding of data warehouse architecture and main construction approaches

• Understanding of the structure and purpose of different data warehouse layers

• Confident SQL skills: writing complex queries for data analysis and verification

• Ability to read and analyze existing PL/SQL code

• Experience interacting with developers and other team members during DWH changes implementation

• Experience with Confluence and Jira

• Knowledge of requirements 135-F and 220-I

• Knowledge of the methodology for calculating components of the N1 ratio

• Understanding of data quality control principles (Data Quality)

• Experience in analyzing and identifying data quality issues

• Experience in designing database objects in different data warehouse layers

Work format: remote Citizenship, location: RF Salary range: 180-220