Middle Data Analyst

На данный момент Data Analyst.

Мои компетенции и опыт

2025—2025 LowKick Data Analyst

Main stack: SQL (Clickhouse), Superset, AirFlow, Python, Git.

Project: World Shards, independent MMO video game with WEB3 elements

Developed end-to-end BI solutions using SQL, Superset, and Airflow: from data extraction and transformation (ETL/ELT) to dashboard visualization and reporting.

Automated data ingestion from third-party services by integrating with external APIs, including reviewing API documentation and building or modifying Airflow DAGs for scheduled data collection.

Improved performance and reliability of existing SQL queries and Airflow tasks, leading to faster execution and reduced resource usage.

Delivered ad-hoc analyses to support business decisions, providing quick insights and actionable data for stakeholders.

2020—2024 Garage IT, Data Analyst

Main stack: SQL (Google BigQuery, MySQL, PostgreSQL), Tableau, Amplitude, AirFlow, Python, Git.

I spent most of my time working on two areas:

Developing a social network for investors for Web, Android, and iOS:

• Analysis of user interaction with the content: duration and depth of feed reading, involvement in different types of content, duration and frequency of user sessions;
• Analysis of user needs based on survey and interview results;
• A/B test design and analysis of their results;
• User segmentation (RFM, ABC XYZ, LTV);
• Analysis of product profitability;
• Development of an attribution model to determine the effectiveness of meeting user needs;
• Creating reports and dashboards for all of the above;
• Ad-hoc research.

Developing an internal solution for creating and sending messages via different channels (email, mobile push notifications, etc.) and tracking user interactions with them:

• Analysis and research of the effectiveness of direct communications with users;
• Research of seasonality of interaction with communications;
• Building dashboards for business reporting, tracking product status and for the internal needs of the team;
• A/B test design and analysis of results;
• Ad-hoc research;
• Product profitability analysis.

To support my work, I partially performed the functions of a Data Engineer:

• Writing large and complex SQL queries (500+ lines, with CTEs, window functions, multiple JOINs and aggregations and other things that can describe a "complex query");
• Optimization of my own and other people's queries to increase execution speed and reduce the volume of data used;
• Organization and maintenance of data consistency in DWH;
• Creating ETL/ELT tasks for DWH: collecting data from production databases for uploading to Data Lake, creating data marts for use in creating reports and dashboards, collecting and structuring events for Amplitude.

2014—2020:

Manual and auto testing in B2C and B2B E-Commerce and FinTech domains

Before 2015:

Helpdesk, Support

Languages:

• Russian — Native
• English — B2
• Spanish — A1
• Serbian — A2