Юлія

Yuliia Kamenshchykova
DATA ANALYST
[open contact info](look above in the "contact info" section) [open contact info](look above in the "contact info" section) Vinnytsia, Ukraine, remote

Yuliia Kamenshchykova @yuliakam

Profile
Data-driven professional with a strong mathematical background and over a year of hands-on experience in BI.
Expert in querying complex databases via SQL (PostgreSQL, MS SQL) and performing exploratory data analysis
using Python. Certified by Mate Academy and UCU. My extensive experience in graphic design allows me to
master the art of data storytelling, transforming raw numbers into clear, aesthetic business insights. Highly
responsible, communicative, and fluent in English.

Skills
Spreadsheets: Pivot Tables, Data Cleaning, SQL: Advanced Queries, Window Functions, Query
Visualization Optimization, Common Table Expressions (CTE)

Python: Pandas, NumPy, Matplotlib, Seaborn, BI Tools: Tableau (Advanced), Power BI (Basic), Looker
Exploratory Data Analysis (EDA) Studio

Statistics: Sampling, Hypothesis Testing, Correlation, A/B Testing: Planning, Analysis, Reporting
Statistical Significance
Languages: English (Upper-Intermediate)
Other Tools: Jupyter Notebooks, Google Analytics,
Excel, Git

Professional Experience
Data Analyst | (Project-Based) 11/2025 – 03/2026
E-commerce Sales Analysis: Developed comprehensive interactive dashboards to
•

track key performance indicators (KPIs), user behavior, and revenue trends, enabling
data-driven decision-making.
Data Pipeline & ETL: Automated data collection and transformation processes using
•

Python (Pandas, NumPy) and complex SQL queries to ensure data integrity and
readiness for analysis.
A/B Testing & Statistical Analysis: Designed and analyzed A/​B tests to evaluate
•

product features, calculating statistical significance and providing actionable
recommendations for conversion rate optimization.

Project Coordinator | Open Society – Institute of Local Democracy 2024 – 2025
Analytical Reporting: Developed financial models and impact assessments,
•

translating complex project data into insights for international donors.
KPI Management: Monitored budgets and resource allocation using data-driven
•

tracking, ensuring 100% milestone fulfillment.

Design & Visualization Expert 2008 – 2024
Companies: SoftServe (2016–2017), Bikehunter, Sophino, Gurmania.
•

Web & Email Marketing: Designed websites and managed email marketing
•

campaigns, focusing on user engagement and conversion-driven layouts.
Print Design: Expert in book design and printed collateral, ensuring high precision in
•

typography and complex grid systems.
Data Storytelling: Leveraged 12+ years in graphic and web design to create high-
•

clarity visual systems and structured data layouts.
Marketing Project Manager | PrivatBank 2005 – 2008
Performance Analytics: Engineered a campaign tracking system using Advanced
•

Excel for statistical processing and trend analysis of marketing activities.
Operational Management: Coordinated the nationwide production and logistics of
•

advertising materials, ensuring 100% timely delivery across the extensive branch
network.
Data-Driven Reporting: Synthesized key performance metrics and production data
•

into executive reports, enabling strategic pivots based on quantitative evidence.

Projects
End-to-End Analytical Solution | BigQuery & Looker Studio⁠
Description: Engineered an end-to-end analytical pipeline using BigQuery SQL to aggregate raw e-commerce
•

data into a unified schema, tracking user lifecycle and email funnel performance.
Key Tech: BigQuery SQL, Looker Studio, CRM Data Modeling.
•

Impact: Automated churn and acquisition reporting; enabled data-driven strategy optimization by segmenting
•

users by verification status and geographic performance.

Sales & Customer Analytics Dashboard (Tableau)⁠
Description: Developed a multi-page executive dashboard in Tableau to monitor regional sales performance
•

and YoY growth using advanced parameters, calculated fields, and heat maps.
Key Tech: Tableau Desktop, RFM Analysis, Advanced Data Visualization.
•

Impact: Identified a 15% profit margin drop in specific categories, leading to a pricing strategy review;
•

implemented RFM segmentation to enhance targeted marketing for "At Risk" and "Loyal" customers.

End-to-End Analytical Solution | BigQuery & Looker Studio⁠
Description: Engineered an end-to-end analytical pipeline using BigQuery SQL to aggregate raw e-commerce
•

data into a unified schema, tracking user lifecycle and email funnel performance.
Key Tech: BigQuery SQL, Looker Studio, CRM Data Modeling.
•

Impact: Automated churn and acquisition reporting; enabled data-driven strategy optimization by segmenting
•

users by verification status and geographic performance.

Education
Specialist of Science in Mathematics, 2002 – 2007
Institution Dnipropetrovsk National University, Dnipro, Ukraine

Courses
Data Analyst course, Mate academy 11/2025 – 03/2026

Data Analytics 1 (Intro), Ukrainian Catholic University 04/2022 – 06/2022

Languages
Ukrainian English
Native/​Bilingue Proficient

ACHIEVEMENTS
Project Management & Coordination: Successfully organized and executed a mural project in Vinnytsia
dedicated to the 300th anniversary of Hryhorii Skovoroda, managing stakeholders and artistic teams.

Social Initiative Leadership: Established and managed a volunteer workshop dedicated to producing
specialized adaptive clothing for wounded soldiers, coordinating logistics and volunteer efforts.

Community Impact: Initiated and facilitated multiple cultural and environmental projects, demonstrating
strong organizational skills, public speaking, and a commitment to sustainable community development.