Аналитик данных/Data analyst

X5 Group is a Russian retail company managing grocery chains «Пятёрочка», «Перекрёсток», and «Чижик», as well as digital services «Vprok.ru Перекрёсток», 5Post, «Много Лосося», and the media platform Food.ru. X5 Tech is the IT company and primary digital partner for X5 Group’s retail networks and businesses. A team of over 5,000 specialists develops solutions that help 372,000 employees work with maximum technological comfort and enable millions of customers to quickly and conveniently purchase fresh products.

About the role

The Data Management Directorate is looking for a Data Analyst. Our tech stack includes Greenplum, Trino, Apache Airflow, ClickHouse, Python, Spark, SQL (dbt), and S3.

Responsibilities

• Collect prototypes of data marts;
• Develop and optimize SQL queries to extract data from various sources;
• Analyze and interpret large volumes of data to identify trends, patterns, and insights;
• Formulate and test hypotheses;
• Document developed solutions;
• Collaborate with development and product management teams to define data requirements;
• Participate in projects to improve data quality and automate analytical processes.

Requirements

• Relevant work experience of at least 3 years;
• Strong SQL knowledge and experience with relational databases (PostgreSQL, MySQL, MS SQL, etc.);
• Ability to write and optimize complex SQL queries (window functions, recursion, array functions and operators, temporary tables);
• Ability to understand and review others' code;
• Knowledge and experience with data warehouse architecture (Data Vault 2.0);
• Experience with the stack: Greenplum, Hive, ClickHouse, S3, Trino;
• Good communication skills and ability to work in a team;
• Experience with BI tools (Qlik Sense, Superset);
• Basic Python data skills (pandas, numpy, sqlalchemy, psycopg2, requests);
• Experience with Airflow, including writing DAGs and knowledge of core components;
• Experience with Ataccama.

Benefits

• Official employment with a white salary and biannual performance-based bonuses;
• Option to work remotely or in a hybrid format;
• Comprehensive health insurance (including international coverage and dental), life and health insurance;
• Opportunities for learning and development at the company’s expense: external training and seminars on professional topics, participation in major industry conferences, digital and managerial skill development programs (Digital Academy, Team Lead School), online and offline master classes, corporate university «X5 Polka», mentorship school, and more;
• Motivation programs for speakers and authors: internal Speak Up School, Write Up, achievements and points for presentations, speaker preparation for major conferences, a community of authors on Habr, and opportunities to share experience with internal and external experts;
• Experience exchange through communities;
• Vibrant corporate life with numerous events, competitions, and opportunities for creative realization: regular internal meetups, demo days, open mic sessions, IT Specialist Day, volunteering programs, and corporate entrepreneurship X5 Idea Challenge.