Senior
- Citizenship: Russian Federation.
- Location: Russian Federation, Moscow, Regions of the Russian Federation.
- Work format: hybrid, 1 week in the office / 1 week remote, office in Moscow.
Responsibilities
- Formation of data marts for launching marketing and CRM campaigns (Arenadata DB).
- Description of requirements for data marts.
- Data mart modeling.
- Data analysis at sources (Hadoop, Kafka).
- Performing analytical tasks (data quality checks, comparison of data at sources, etc.).
- Monitoring data mart loading together with developers, studying problems and errors in data mart assembly.
- Communication with clients and the team.
Mandatory Requirements
- Excellent knowledge of SQL (join, window functions, regular expressions, script optimization, etc.).
- Experience with databases in building data warehouses/reports/data marts for 1 year or more.
- Understanding of database architecture.
- Ability to gather requirements from business and IT departments.
- Experience in researching data sources and forming requirements.
Desirable Requirements
- Experience in designing data marts.
- Experience with PostgreSQL/Greenplum/Arenadata DB.
- Knowledge of the banking subject area.
- Conducting GAP analysis.
Soft Skills Requirements
- Communication skills.
- Logical thinking.
- Structuring information.
List of mandatory technology knowledge
SQL, PostgreSQL, Kafka, Greenplum, Hadoop, Apache Kafka, DB, Hadoop/Hive, Arenadata DB
List of desirable technology knowledge
GAP Analysis, Oracle, banking subject area
