Job Details

DWH Analyst position at Zontik, remote, Middle+/Senior level. Salary 250-380k gross. Requires strong SQL, Oracle, Greenplum/PostgreSQL, and banking experience. Migration and reporting tasks.

Analyze current DWH and business processes for migration. Collect and analyze requirements for reporting development. Implement changes and test in DWH. Set technical tasks (detailed and data mart layers). Control data loading quality. Interact with customers and related teams.

Mandatory (critical): - Confident SQL (Middle / Junior 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 reporting (regulatory - as a plus) - Experience with DWH data and data marts - Understanding of business and functional requirements - Ability to work in an intensive mode and with multiple tasks simultaneously without loss of quality - Developed communication skills: requirements gathering, conducting interviews, interacting with different types of customers Will be a plus: - Experience with ABS CFT (structure, relationships, tables) - Experience in building data marts for regulatory reporting (forms 0409135, 0409118, 0409101, 0409102, etc.) - Experience in DWH migration (Oracle → Greenplum / PostgreSQL / Arenadata) - PL/SQL skills - Ability to visualize data schemas (draw.io or similar)

Location: Russia Format: remote Level: Middle+/Senior Salary range: 250-380k gross (for individual entrepreneur/labor contract) SPECIALISTS WITHOUT PRIOR EXPERIENCE IN BANKING OR FINTECH ARE NOT ACCEPTED.