Company: Zontik ☂️
Position: Data Analyst/DWH
Location: Russian Federation
Format: remote
Level: Middle+/Senior
Salary Range: 250-380k gross (as self-employed/employee contract)
❗️SPECIALISTS WITHOUT BANKING OR FINTECH EXPERIENCE WILL NOT BE CONSIDERED❗️
Responsibilities:
- Analysis of current DWH and business processes for migration
- Gathering and analyzing requirements for reporting development
- Implementation of changes and testing in DWH
- Creating technical tasks (detailed and data mart layers)
- Data loading quality control
- Interaction with clients and adjacent teams
❗️Mandatory Requirements (Critical)❗️
- Proficient SQL (Middle / entry-level Senior):
window functions, ranking, grouping, subqueries, decomposition and optimization of complex queries
- Experience with Oracle: ability to read, understand, and analyze stored procedures and packages
- Experience with Greenplum / PostgreSQL
- Experience in the banking sector
- Higher education
Mandatory Requirements:
- Understanding of banking reports (regulatory reporting is a plus)
- Experience with DWH data and data marts
- Understanding of business and functional requirements
- Ability to work in an intensive mode and handle multiple tasks simultaneously without loss of quality
- Developed communication skills: requirement gathering, conducting interviews, interaction with different types of clients
Will be a plus:
- Experience with CFT Core Banking System (structure, relationships, tables)
- Experience building data marts for regulatory reporting (forms 0409135, 0409118, 0409101, 0409102, etc.)
- Experience with DWH migration (Oracle → Greenplum / PostgreSQL / Arenadata)
- PL/SQL skills
- Ability to visualize data schemas (draw.io or similar)
