Олег

OLEH MARCHUK
DATA ANALYST | MARKETING & WEB ANALYTICS
Lviv, Ukraine | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)
PROFESSIONAL SUMMARY
Analytically focused professional with 3+ years of digital marketing experience, turning website and campaign data into KPI
reporting, performance insights and budget recommendations. Previously supported data cleaning and statistical reporting as a Data
Analyst. Hands-on experience building a Power BI education analytics dashboard; practical SQL skills and cross-market leadership
experience. Seeking Data Analyst / Marketing Data Analyst roles.

ANALYTICAL & TECHNICAL SKILLS
SQL JOINs, CTEs, subqueries, CASE, aggregations, window functions and date functions (coursework / practice).
Power BI Power Query, data cleaning and transformation, report design, KPIs, slicers, matrices and conditional
formatting.
Analytics Data quality checks, descriptive statistics, school- and campaign-level comparisons, trend and KPI analysis.
Additional tools Excel, Google Analytics, Google Search Console, Google Tag Manager, Ahrefs and SEMrush.

SELECTED ANALYTICS PROJECT
Municipal School Network Dashboard | Power BI | 2026 VIEW CASE STUDY
Built a school-network reporting prototype covering 31 institutions, 10,455 pupils and 466 classes for the 2026/27 academic year.
Imported and cleaned municipal Excel tables in Power Query; handled data types, null values, school names and grade-stage
grouping.
Combined school and after-school care indicators (930 pupils, 31 groups); calculated and displayed key metrics including 22.44
pupils per class.
Designed KPI cards, school rankings, grade-stage comparisons, a conditional-format enrollment matrix and report slicers.
Validated totals against source records and examined missing upper-secondary grade values; additional appendices are planned.

PROFESSIONAL EXPERIENCE
Link Building Team Lead | MAKEUP Mar 2026 - Present
Lead a 3-person team across 14 markets; coordinate workflows, KPI monitoring, resource planning and reports.
Analyse organic traffic, search visibility and link-placement quality to prioritise markets and budgets.
Translate performance trends into actionable campaign recommendations for cross-market execution.
Senior Off-Page SEO Specialist | SEOprofy Jun 2023 - Mar 2026
Analysed referral traffic, backlink datasets, domain metrics and search performance using Ahrefs, SEMrush and Search Console.
Compared websites and campaign performance over time; used findings to adjust outreach strategies and reporting.
SEO Assistant | EMRG Capital May 2022 - Jun 2023
Monitored website traffic, impressions and organic performance; prepared inputs for recurring reporting.
Performed technical and content audits to identify metadata, speed and broken-link issues.
Data Analyst | Tourism Development Center of Lviv Jan 2022 - Mar 2022
Collected, cleaned and validated project records; supported dataset consistency and data-quality reviews.
Prepared descriptive statistics and structured internal reports under supervision.

EDUCATION & RESEARCH
PhD studies, Economics & International Economic Relations | Drohobych Ivan Franko State Pedagogical University | 2025-present
Master's in Marketing (2024); Bachelor's in Marketing (2023) | Ivan Franko National University of Lviv
Co-author of peer-reviewed research on SEO vs. PPC investment outcomes | Economics, Entrepreneurship, Management (2025) |
doi.org/10.56318/eem2025.01.049

CERTIFICATIONS
Sololearn: SQL Intermediate (Sep 2026, CC-P2IF2GDD) | Introduction to SQL (Sep 2026, CC-JNXS2HH1)

English: B2 | Ukrainian: Native