Personal information hidden

Mark Ilchuk Data Analyst
Kyiv, Ukraine. Open to remote, relocate [open contact info](look above in the "contact info" section)

[open contact info](look above in the "contact info" section) [open contact info](look above in the "contact info" section) t.me/markilchuk

SUMMARY
Data-driven analyst with a background in business analysis. I focus on end-to-end data analysis: from writing
complex SQL queries and structuring raw datasets to building clean Tableau dashboards and analyzing user behavior.
Much of my work centers on looking beneath the surface to find hidden patterns, map system dependencies, and help
teams turn chaotic metrics into structured insights.

SKILLS
Spreadsheets: Pivot Tables, Data Cleaning, Visualization
SQL: Advanced Queries, Window Functions, Query Optimization, Common Table Expressions (CTE)
Python: Pandas, NumPy, Matplotlib, Seaborn, Exploratory Data Analysis (EDA)
Tableau: Interactive Dashboards, Data Storytelling, Publishing
Statistics: Sampling, Hypothesis Testing, Correlation, Statistical Significance
A/B Testing: Planning, Analysis, Reporting
Other Tools: Jupyter Notebooks, Cursor, Excel, Git

EXPERIENCE
Data Analyst, Freelance 02/2026 – Present
Responsibilities:
Write and optimize complex SQL queries (CTEs, window functions) to transform raw
•

pipelines into structured datasets.
Build and maintain interactive Tableau dashboards to deliver clear, actionable insights
•

to cross-functional teams.
Perform deep-dive exploratory data analysis (EDA) using Python (Pandas, NumPy) to
•

uncover key user behavior trends.
Design and analyze A/B tests using statistical hypothesis testing to validate and
•

optimize product features.
Audit database and spreadsheet workflows to improve query performance and ensure
•

high data quality.

PORTFOLIO
Project 1 (SQL Projects)
Advanced database queries utilizing complex CTEs and window functions to clean raw transactional datasets and
optimize query performance for business metrics.
Link to review
•

Project 2 (Tableau Projects)
Interactive, end-to-end business dashboards designed to map system dependencies, analyze user behavior, and
translate chaotic metrics into clear, visual stories.
Link to review
•

Project 3 (Python Projects)
Exploratory data analysis (EDA) and statistical deep-dives using Pandas and NumPy to uncover hidden patterns and
evaluate A/B testing experiments.
Link to review
•

Mark Ilchuk
 PREVIOUS EXPERIENCE
Risk Management Intern, Namecheap 12/2025 – 03/2026
Key Responsibilities & Achievements:
•

Risk & Fraud Analysis: Monitored and analyzed user account activity, transaction
•

patterns, and support tickets to identify potential security threats and fraudulent
behavior.
Data & Problem Solving: Utilized internal monitoring tools and databases to gather
•

evidence, trace anomalies, and resolve complex account issues systematically.
Process Optimization: Categorized and tracked recurring risk factors, providing
•

actionable feedback to senior teams to improve internal support workflows and
security protocols.

LANGUAGES
English: Upper-Intermediate
Ukrainian: Native
German: Intermediate
Polish: Intermediate

EDUCATION
State University of Trade & Economics, Bachelor Degree in Data Science 2025 – Present

ADDITIONAL EDUCATION
Data Analyst course, Mate academy

Fundamental Analysis of Market Structures & Microeconomics, Coursera

Multi-Channel Marketing & Growth Analytics

Mark Ilchuk