Company: Top Selection
Location: Moscow, Russia
Employment: full-time
Work format: remote possible
Salary: 250000–270000 RUB per month
Qualification: Senior
Specialization: Data Analyst
Requirements:
- Analysis of business needs for prepared data
- Preparation of requirements for the methodology of indicator calculation
- Design of data models for presentation and detailed data layers
- Search for relevant data sources, profiling data in sources, as well as within the data platform environment
- Development of algorithms for creating data marts and detailed layer objects
- Development of prototypes in data marts and their approval with the consumer
- Support for the development of data marts at all stages of the workflow: flow development, testing, UAT, handover to support, incident resolution in 3rd line support
- Estimation of computational resources required to solve the task (storage and compute sizing)
- Estimation of labor costs for performing modifications
- Definition of data quality check logic and its implementation for created data marts
Responsibilities:
- Solid understanding of data platform construction principles (DWH, OLAP, Data Lake, Lakehouse)
- Knowledge of data model design methodologies (Kimball, Data Vault), practical experience in applying them to data model design
- Skills in working with large volumes of data (billions of records, TBs of data)
- Expert knowledge of SQL
- Knowledge of RDBMS (PostgreSQL, Oracle, MS SQL)
- Understanding of principles and experience with MPP systems (GreenPlum, Clickhouse, Trino)
- Ability to analyze existing data flows, their dependencies (ETL/ELT, Airflow)
- Ability to systematize unstructured requirements in the format of data mart descriptions
- Strong communication skills for interacting with: business customers, developers, admins)
- Experience in optimizing complex queries
- Planning and time management skills
- Skills in assigning tasks to adjacent departments
- Experience with distributed storage systems (Hadoop, S3)
- Proficient spoken and written Russian
