KHOD/DWH Analyst

Conditions

• Employment: full-time
• Location: Russian Federation, Moscow
• Citizenship: Russian Federation
• Working schedule: MSK
• Format: Hybrid

Position

• Role: KHOD/DWH Analyst
• Level: Senior

Must-have

• Excellent knowledge of SQL (join, window functions, regular expressions, script optimization, etc.).
• Experience with databases in building data warehouses/reporting/data marts for at least 1 year.
• Understanding of database architecture - Ability to gather requirements from business and IT departments.
• Experience in researching data sources and forming requirements.

Nice-to-have

• Experience in designing data marts.
• Experience with PostgreSQL/GreenPlum/Arenadata DB.
• Knowledge of the banking subject area.
• Conducting GAP analysis.

Tasks

• Form data marts for launching marketing and CRM campaigns (Arenadata DB).
• Describe requirements for data marts.
• Model data marts.
• Analyze data at sources (Hadoop, Kafka).
• Perform analytical tasks (data quality checks, comparison of data at sources, etc.).
• Monitor data mart loading together with developers, study problems and errors in data mart assembly.
• Communicate with clients and the team.