Особисті дані приховані

Shubin Mykhailo
Nitra, Slovakia ✉ [відкрити контакти](див. вище в блоці «контактна інформація») mykhailo-shubin shubinmykhailo

PROFILE HIGHLIGHTS
• Trainee Data Analyst
• Tech stack: Python (pandas, matplotlib, seaborn), SQL, Snowflake, GitHub, Excel, Power BI, DAX,
Power Query, Power Automate, SharePoint

WORK EXPERIENCE

Trainee Data Analyst / Remote Research Assistant
Schulich School of Business – York University | Toronto, Canada Feb 2026 – now
• Data visualization in Power BI, Excel. Data transformation in DAX and Power Query.
• Performed exploratory data analysis in Python on datasets ranging from ~400K records, identifying key trends
and data quality issues.
• Data Engineering: Built ETL pipelines to extract historical industrial data, clean it, and structure it for
analytical models.
• Built a 15-year population forecasting model using the Cohort Component Method, based on 3–4 years of
historical data.
• Introduced Claude Code into the team's workflow and trained colleagues on using AI-assisted development for
Python, SQL, and analytics tasks.
• Automation: Set up automatic data backups using Power Automate.

PERSONAL PROJECTS

Slovak Presidential Elections 2024 Dashboard (Power BI)
• Built an interactive dashboard with custom Topo JSON maps for 49 districts, Field Parameters, drill-through,
and custom tooltips.
• Analyzed voting patterns across both election rounds, identifying a turnout shift from 51.9% to 61.2% and a
geographic reversal where the Round 1 leader lost Round 2 to the eventual winner.
Eurostat Minimum Wage Analysis (Python, pandas, matplotlib)
• Analyzed 25+ years of Eurostat minimum wage data (1999–2026) across European countries using CAGR to
correct for distorted growth rates from low starting bases and short data histories.
• Identified an inverse relationship between wage level and growth rate, and a post-2022 divergence between
Ukraine and Moldova despite comparable starting conditions.
Job Market ELT Pipeline (Snowflake, SQL)
• Designed a star schema (1 fact table, 4-dimension tables) and built an ELT pipeline in Snowflake to process
job posting data.
• Implemented SCD types 1/2, deduplication via window functions and QUALIFY, and used the model to
analyze hiring trends by country, industry, and occupation.

EDUCATION

Bc., Applied Informatics, University of Constantine the Philosopher in Nitra, Slovakia Sep 2024 – now
Relevant Coursework: Database Systems & Technologies, Data Processing in Python, Mathematical Principles of
Machine Learning, Modeling & Simulation, Data Representation & Encoding, Algorithms & Data Structures.