Dmytro

Lychahin Dmitry

Data Analyst

Remote, Ukraine
Linkedin

[open contact info](look above in the "contact info" section) TG:@nextd35

[open contact info](look above in the "contact info" section)

Hard Skills Profile
Data Analyst with hands-on experience in retail analytics,
Advanced SQL — BigQuery,

demand forecasting, and building analytical infrastructure from
MySQL, SQLite (window

functions, CTEs, data modeling )
scratch. Proficient in SQL, Python, and BI tools. Also experienced

in data engineering — building automated ingestion pipelines
Python (Pandas, NumPy,

)

(Google Cloud, Python). Skilled in cohort analysis, customer
openpyxl, gspread
segmentation, and tracking key business metrics (ROI, CAC, LTV).

GA4, Ads tools, Google Sheets,
Passionate about turning raw data into actionable insights and

API(Poster, NBU, etc )
automating reporting workflows.

Agile Methodologies

Employment history
Looker Studio, Tableau, Power B I

Descriptive Statistics

Prod uc /
t Mar k
etin g l
Data ana yst – B zh
a ane bq
t .

2025 – Presen t

Data visuali atio z n

Built the analytics department from scratch: established reporting

JavaScript(ES6 )
workflows, documentation, and data infrastructure

Git H / /
ub GitLab GitBucke t
Developed automated Python pipelines for stock forecasting and

inventory analytics using sales and order data

Google Cloud (BigQuery, GCP
Conducted cohort analysis of customer purchasing behaviour (e.g.
pipelines )

segmentation by first purchase value), tracking repeat purchase

rates and conversion patterns

Built SQL-based data marts and implemented data modeling (dbt,

CTEs, window functions) based on Fivetran exports

Tools Mentored a junior analyst and maintained structured documentation

in Notion for team

VS Code

Built Looker Studio and Tableau dashboards tracking CAC, ROI, LTV,

/
DataGrip DBeave r
stock levels, and demand forecasts

Linux /W indows
Automated data ingestion from Google Ads and GA4 into BigQuery;

configured GCP service accounts and pipelines
/
Notion Trello Jir / a

Front-End Dev. Trainee, EPAM Systems
Soft Skills
2022 - 2023

Experienced in mentoring and

building team documentatio n
Gained foundational experience in JavaScript (ES6), version

control (Git), and software development workflows

Languages

Ukrainian (Native )
Education

Russian (Native )
National Aerospace University "Kharkiv Aviation Institute", Kharkiv
Master of Computer Science and Engineering, 2021–2022 Bachelor,
2018–2021

English (Intermediate+)

Courses

Аналіз даних та статистичне виведення — Prometheus, 2022–
2023

Data Analysis — EPAM University, 2022–2023

QATestLab

Secondary School — Poltava Polytechnic College, 2014 - 2018