Igor

CONTACTS
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
Telegram
Linkedin
Vinnytsia, Ukraine
Igor Shchur
Data Analyst
Junior Data Analyst with practical experience in SQL, Python, BigQuery, Tableau, Looker Studio and Google Sheets.
Skilled in comprehensive Product Analytics, including Customer Journey Mapping (CJM), cohort analysis, A/B test setup and evaluation, and deep analysis of user engagement and conversion funnels. Proficient in leveraging specialized tools like Google Analytics (GA) for traffic and marketing attribution, and Amplitude for in-depth behavioural analysis and retention tracking.
Experienced in analyzing advertising campaigns, product performance, and transforming raw data into clear, actionable business insights. Highly proficient in SQL (CTEs, window functions, regex) and data preprocessing for ad-hoc and customer cohort reporting.
Seeking a role where I can apply strong analytical thinking and technical skills to support data-driven product decisions and optimize business performance.

PROJECT EXPERIENCE
Marketing Campaign Performance Dashboard
Tools: PostgreSQL, Looker Studio.
Description: Built a dashboard providing a comprehensive overview of marketing campaign effectiveness.
My tasks: calculate five key metrics - Sum Ad Spend, CPC , CPM , CTR , ROMI and build core Visualizations - “Campaign Performance”, “Sum Ad Spend & ROMI”, “Campaign number”.
Result: The end-user can : Quickly identify the most and least effective advertising campaigns (thanks to ROMI and CTR in the table); Analyze the dynamics of ad spend and its return over time; Use filters for detailed investigation of specific periods or campaigns.

Revenue and User Metrics Deep Dive
Tools: SQL, Tableau.
Description: Built a dashboard providing a multi-dimensional analysis of revenue and user behavior.
My tasks: build core Visualizations - “Total Revenue by Location & Product”, “Transaction Amounts Distribution (Box Plot)”, “Total Revenue by Location”, “Revenue Share by Location Over Time”, “Total Revenue by Month and Product”, “ARPPU & Paid Users (Monthly)”.
Result: The end-user can : Identify top-performing (and underperforming) products and regions; Track monthly revenue trends and understand their product mix; Monitor monetization efficiency (ARPPU) in relation to user base growth (Paid Users); Analyze the statistical spread of transaction values; Observe shifts in market dynamics over time through the revenue share chart; The global filters allow for seamless drill-downs and cross-functional analysis across all visualizations.

Game Engagement Analysis Dashboard
Tools: SQL, Tableau.
Description: Built a dashboard to analyze player activity and engagement patterns.
My tasks: build core Visualizations - “Heatmap of Average Game Time by Age Group and Quarter”, “Average Play Time per User (Monthly) HH:MM”, “Unique 'BattlePass' Users % vs. Total Unique Users”.
Result: The end user can dynamically filter the entire dashboard by Age Group, Game Activity Name, Language, and Activity Date. This provides a powerful tool for analyzing player engagement from multiple perspectives who is playing (age/language), how long they play (average time) and which features they use (Battle Pass).
SaaS Revenue & Cohort Retention Analysis
Tools: SQL, Tableau.
Description: Built a dashboard that provides a deep dive into key revenue metrics. The dashboard is interactive, featuring global filters on the right side for Month, Year of Payment Date, and Location.
My tasks: build core Visualizations – “New MRR by Month”, “Total Revenue and Monthly Growth Rate in %”, “Cohort Revenue Retention Table”.
Result: The dashboard effectively visualizes the company's revenue health from three critical perspectives: Acquisition: New MRR by Month shows the revenue generated from new customers; Growth: Total Revenue and Monthly Growth Rate tracks overall performance and momentum; Retention: The Cohort Revenue Retention Table provides a clear view of long-term customer value and how well the product retains revenue from different cohorts.
HARD SKILLS
• SQL, Python
• Advertasing companies analysis
• Data cleaning & preprocessing
• Exploratory Data Analysis
• Statistic A/B Tests
• Product analytics
• Cohort analysis and retention analysis
• Dashboarding & data storytelling
• Funnel analysis and conversion analysis

TOOLS
• BigQuery(SQL)
• Python
• Tableau
• Looker Studio
• Google Sheets
• Google Analytics
• Amplitude
• Jupyter Notebook
• DBeaver

SOFT SKILLS
• Strong analytical thinking
• Logical thinking
• Attention to detail
• Task prioritising
• Ability to explain complex things simply
• Curiosity and eagerness to learn
• Being proactive
• Time management
• Teamwork
• Collaboration with cross-functional teams
• Honesty
• Stress resistance
• Working well under pressure
• Customer focus
• Information seeking
• Multitasking

LANGUAGES
• English - Intermediate
• Ukrainian – Native
• Swedish - Pre-Intermediate

WORK EXPERIENCE
Voltage Group LLC, Vinnytsia
August 2025 – Present: Supply Manager (FEA)
• Managed domestic procurement (Ukraine) and international imports from Europe, China, USA.
• Sourced production materials, spare parts, photomodules, Energy Storage Systems (ESS), inverters and other electronic components.
KNESS GROUP LLC, Vinnytsia
December 2021 – July 2024: Supply Manager (FEA)
• Handled domestic procurement (Ukraine) and international imports from Europe, China, USA.
• Sourced production materials, spare parts, microchips, electrical equipment and other goods for RnD department.
Trading House Ukrservice, Vinnytsia
October 2019 – December 2021: Supply Manager (FEA)
• Managed the ordering of spare parts from China and Europe for power tools, petrol/diesel equipment, gardening machinery, warehouse equipment, and pneumatic tools.

EDUCATION
• IT School GoIT - Data Analysis, 2025
• Vinnytsia Social and Economic Institute of the "Ukraine" Open International University of Human Development - Master's degree, Specialty: Management; Field: Public Management and Administration, 2022-2024
• Taras Shevchenko National University of Kyiv - Master's degree, Faculty: Radiophysics, Department: Physical Electronics, 2005-2010