Senior DWH Developer (Data Warehouse Engineer)

#vacancy #DWH #Senior #Moscow #office #Bank #DataWarehouse #ETL #SQL

Vacancy: Senior DWH Developer (Data Warehouse Engineer) Company: Zontik Location: Moscow, strictly office-based work (5 days a week) Work Format: Full-time in the office Employment: Full time Salary Range: up to 270k gross according to Labor Code, up to 360k gross according to Individual Entrepreneur contract

Key Requirements (Mandatory): Experience and Education: Higher technical education, commercial DWH development experience of 3+ years. Scale and Architecture: Experience in developing data marts for warehouses with a total volume of from 100 Tb. Deep architectural understanding of models (Star, Snowflake, Data Vault). Database Work: Excellent command of relational DBMS: Oracle, PostgreSQL, MS SQL. Proficient SQL and mandatory experience in optimizing complex queries. ETL and CDC: Experience in developing ETL jobs in Pentaho DI / Informatica PC. Mandatory experience with CDC tools (Oracle Golden Gate and similar). Banking Specifics (Critical): Strictly mandatory experience in preparing data for regulatory (Central Bank) and operational reporting. Important: we are looking for a candidate at the intersection of a developer and an analyst who understands the essence of data, not just transfers it according to specifications. This point is key. Documentation: Ability to create competent, detailed documentation for DWH objects in Confluence. **Experience in banks, fintech

Desirable Requirements (will be a plus):** Experience in development with Apache Kafka. Experience in implementing data exports for the Central Bank (knowledge of formats and regulations). Understanding of the principles of warehouse core maintenance (ODS and detailed layer).