DWH Analyst
Company: Zontik ☂️
Location: strictly Russian Federation
Level: Middle+/Senior
Salary Range: 300-420k gross (as individual entrepreneur/labor contract)
Requirements:
- Higher education in natural sciences, technical, or economics.
- Fintech/Banking experience ONLY ‼️
- Experience in DWH and/or Data Lake implementation/development projects for at least 3 years.
- Deep knowledge of SQL (Oracle, PostgreSQL), ability to write complex queries and read PL/SQL code.
- Experience in designing database objects and understanding data warehouse architecture.
- Experience in designing and developing reports using MS SQL Reporting Services or Tableau.
- Experience in describing data loading processes into DWH.
- Experience in preparing technical documentation (Source2Target, ToR).
- Desirable experience with ETL tools, preferably Informatica PowerCenter.
- Knowledge of ClickHouse and GreenPlum will be a plus.
- Experience with JIRA.
Responsibilities:
- Develop new data marts and modify existing Bank data marts based on business requirements within the framework of the Bank's transition to the PwC project.
- Develop and implement an industrial default data mart considering default criteria and necessary attributes (default date, recovery date, default events, etc.).
- Develop data marts with historical data and constants for past periods.
- Integrate historical data marts into current and future processes and data flows.
- Describe data loading processes into DWH.
- Prepare technical documentation (Source2Target, ToR).
