Conditions

• Employment: full-time
• Location: Russian Federation
• Citizenship: Russian Federation
• Working hours: MSK ±2 hours
• Format: Remote work

Position

• Role: DWH Analyst
• Level: Senior

Required

• Higher education in natural sciences, engineering, or economics.
• At least 3 years of experience in projects for the implementation and/or development of corporate data warehouses (DWH) and/or Data Lake.
• Proficient in Oracle SQL: experience in writing and analyzing complex SQL queries.
• Ability to read and analyze PL/SQL code.
• Experience in designing database objects, understanding of DWH architecture and organization principles.
• Experience in analyzing and designing data loading and transformation flows (ETL), describing data transformation rules, and preparing Source-to-Target mappings.
• Experience in preparing technical documentation for the development and refinement of data marts (technical specifications).
• Experience working with Informatica PowerCenter.
• Experience in designing and developing reports using MS SQL Reporting Services and/or Tableau.
• Experience working with task management systems (Jira or equivalents).

Desirable

• Familiarity with ClickHouse and/or Greenplum.

Tasks

• Analysis of business requirements, design of new and refinement of existing DWH data marts as part of the Bank's transition to IFRS.
• Design of an industrial default data mart based on developed default criteria: defining data structure, necessary attributes (default and exit from default dates, default events, etc.), rules for data formation and loading.
• Design and refinement of historical data marts, including storage of indicators for previous periods and integration of historical data into current and developing loading and processing.
• Preparation and updating of technical documentation (technical specifications, Source-to-Target mappings, description of data structures and transformation rules).