#vacancy #analyst #dwh
Company: Zontik ☂️
Vacancy: DWH Analyst
Location: strictly RF
Level: Middle+/Senior
Salary Range: 220-320k gross (as individual entrepreneur/labor contract)
Requirements:
- Experience with data warehouses - mandatory.
- Higher technical education
- Experience in banking/fintech projects‼️
- Understanding of the task lifecycle and ETL processes.
- Strong PostgreSQL: queries, optimization, VACUUM, logs, replication; preferably experience with modern versions, e.g., PostgreSQL 17.5.
- Experience with Greenplum.
- Python for writing DAGs.
- Experience in developing data marts.
- Understanding of multidimensional modeling basics.
- Understanding the differences between databases and DWH.
- Willingness to develop in related areas: monitoring, circuit support, PostgreSQL infrastructure aspects.
- Experience with ClickHouse or willingness to quickly master it.
- Understanding of the financial subject area.
Tasks:
- Analyze new customer requirements for reporting development.
- Implement changes and conduct testing on the DWH side.
- Interact with internal customers and system analysts from other departments.
- Prepare technical tasks for the development of detailed and data mart levels of DWH.
- Analyze and control the quality of data loading into DWH.
- Describe the logical and physical models of DWH and maintain documentation.
- Develop ETL/ELT flows for forming external DWH exports.
- Develop data marts.
- Work with DWH and participate in migration to a new storage.
📩 If the vacancy is interesting and matches your experience — send your resume in private messages to @NataUIT