Alexey
Data Analyst with 2.5 years of experience in building reporting and visualisation solutions using Power BI, Looker Studio, and Visiology.
Proficient in writing complex SQL queries across ClickHouse, Greenplum, and Google BigQuery, with hands-on experience developing data marts in GP and GBQ. Skilled in automating data workflows and creating dashboards with Python. Actively studying modern AI methods with a solid foundation in classical machine learning algorithms. Academic background includes designing data models (star/snowflake schemas) and implementing triggers and transactions.
Data AnalystMegamarket
Alexey's cases
Show more
Alexey's timeline
Web AnalystMegamarket
- Developed customer profiles for various traffic channels to strategize campaign development.
- Conducted event research, built funnels, and identified user behavior anomalies on the website.
- Analyzed marketing campaign effectiveness monthly, preparing reports for strategic decision-making.
- Created a Telegram bot for alerting analysts about errors in scheduled queries and wrote DAG in Airflow for scheduling tasks.
- Compiled data marts in Google Big Query and GreenPlum for reporting and ad-hoc analyses.
- Developed reports from scratch in Looker Studio and Visiology, and transferred reports between BI tools. Wrote ETL processes for data migration across different databases.
BI AnalystMaxim Technology
- Designed over 5 major reports in Power BI for various operational metrics used by more than 30 users daily.
- Constructed primary data marts in PostgreSQL for order entity reporting.
- Set up daily, weekly, and monthly email distributions with extracts for the operations team using Python.
- Conducted ad-hoc analytics multiple times.
Show more
All Alexey's tags