Description
We are looking for a data analyst to create data mart prototypes. Understanding of business processes in the banking industry for individuals is required.
Responsibilities
- analysis of data from existing automated systems
- development of SQL prototypes and preparation of reference data
- designing mappings (S2T) and ETL logic for loading into the detailed layer, unloading into higher layers of the warehouse
- designing logic for integration and deduplication of source system data
- participation in testing own and validating others' prototypes based on development results
- support for development/testing team, experience with 3-tier architecture
- participation in the analysis of data quality incidents.
Requirements
- experience in writing and analyzing complex SQL queries;
- ability to unify data, experience in writing data mappings (S2T transformations source-to-target)
- understanding of software development stages in enterprise projects (analysis, development, testing, implementation)
- communication and presentation skills
- desirable - experience using Hadoop software platforms (HDFS, Hive, Spark, Kafka).
Conditions
- stable salary and performance-based bonuses, annual salary review
- comfortable modern office near Kutuzovskaya metro station
- office-based work format
- corporate gym and relaxation areas
- Sber's unique training system for professional and career development
- adaptation program and manager's assistance at the start
- extended voluntary health insurance (VHI) and preferential family insurance
- flexible mortgage discount equal to 1/3 of the Central Bank's key rate
- free SberPrime+ subscription, discounts on partner company products
- referral bonus for recommending friends to the Sber team
- corporate pension program
