Worked as a data engineer / analytics engineer in a modern and well-known consultancy agency providing analytics consulting to large digital companies.My key achievements:- created a complete data project from scratch in the cloud ecosystem for a large HR-tech client using Airflow, S3, ClickHouse, dbt, GitHub & DataLens. After 3 months, users were able to get business value from 12 different data sources and about 2TB of data.- maintained and developed a mature dbt project for an e-pharmacy client with 200+ models. Made a custom metric monitoring system using BigQuery Remote Functions. Created 20+ product and marketing reports using PowerBI, Metabase, and Streamlit. Reduced monthly BigQuery expenses by $300 (about 15%) - rewrote outdated reports of a big e-grocery client from BigQuery Scheduled Queries + Looker Studio to dbt-bigquery + Power BI, which helped significantly reduce costs in BigQuery and save up to 8 hours of specialist time per month on maintenance. - mentored more than 100 junior analysts about the basics of ETL, data pipelines and how to work in BigQuery as a teacher in 3 streams of Realweb Camp for analysts.- solved various web analytics tasks using Google Analytics, Yandex Metrika, Google & Matomo tag managers, etc., and product analytics tasks like implementing Amplitude, metrics forecasting, finding Aha moment, etc.

Worked as a data analyst at the main provider of medical analysis and medical statistics in Udmurtia.Tasks I did:- built reports on public health using Python & SQL- automated routine procedures for employees using Python and Excel, significantly reducing the time spent on preparing regular reports- helped to collect and analyze public health data during the outbreak of COVID-19