Data Engineer / Lead Data Analyst

Principals task - Write ETL scripts for DWH (batch and streaming) - Administration infrastructure (jupyterhub, airflow, superset) - Help analytics in writing SQL and Python - Support and administration DB (postgres, clickhouse) Projects - Deployed infrastructure (jupyterhub, airflow, superset) - Developed DWH (clickouse) Tech. stack - Docker, Git, Ubuntu, Bash - ClickHouse, Postgres, MsSQL, RabbitMQ - Airflow, SuperSet, Python

Principals task - Wrote ETL scripts for DWH (only batch) - Ad-Hoc tasks (most of part) Projects - Developed web application for DWH (shiny) - Developed forecast model for LTV - Refactored BI and DWH systems - Wrote calculator for unit-economic Tech. stack - ClickHouse, Postgres, MsSQL - Python, R, Slemma

Principals task - Prepared marketing reports - Prepared product reports Tech. stack - Appsflyer/Twitter/Facebook/Google/Yandex/MyTarget API - MySQL, Postgres, Python

Principals task - Controlled marketing tasks (such PM) - Launched marketing campaigns (such PM) - Prepared dashboards for marketing department (such MA) - Worked in OLAP cubes (such MA) Projects - Developed end to end analytics system (GA + OLAP cubes) - Wrote tech documentation about marketing processes Tech. stack - MsSQL, OLAP cubes, R, Power BI - Google Analytics/Yandex Metrica API

Worked web-master (launched CMS, edited JS and PHP code, make up the site), digital marketer (Google AdWords, Yandex Direct, other). Also, I had my own company, we repaired and sold used technics. But I had wanted being IT specialists and sold it. Few projects (it might not opened) - Build houses (https://bania-msk.ru/) - Selling clothes (http://bewarm.ru/) - Selling dresses (https://princessdress.ru/)