Катерина

KATERINA IAVORSKA
Junior Data Analyst
Proficiency in SQL, Looker Studio and Tableau for data analysis and
visualization Experienced in cleaning, processing and analyzing large data
sets using Excel and Google Sheet. Developed and implemented a data
cleaning and preprocessing infrastructure that improved data quality.
Looking for opportunities to contribute to the company's data-driven
strategy and drive business growth.

PROJECT EXPERIENCE
Analyzing the performance and effectiveness of advertising
[відкрити контакти](див. вище в блоці «контактна інформація») Analyzing data about advertising campaigns, such as clicks, impressions,
[відкрити контакти](див. вище в блоці «контактна інформація») conversions and costs, as well as evaluating the performance and
effectiveness of advertising.
Linkedin
Data collection and processing: combining tables from different sources to
Telegram get a complete picture of campaigns.
Calculation of indicators: calculation of key metrics such as CTR (Click-
Ukraine, Odesa Through Rate), CPC (Cost per Click), CPA (Cost per Acquisition), ROI (Return
on Investment).
HARD SKILLS Segment analysis: distribution of data by audiences, channels or campaigns
to identify the most effective.
SQL Dynamics Tracking: Create queries to compare performance over time,
Python allowing you to assess trends and the impact of changes in strategy.
Microsoft Excel This analysis helps to optimize advertising costs and increase the
Critical thinking effectiveness of campaigns.
Data visualization
Data optimization and visualization in Tableau
Presentation skills
Data connectivity: Integrating data sources, such as databases or tables, to
gather the information you need.
Data processing and preparation: filtering, cleaning, and creating
SOFT SKILLS calculated fields for deeper analysis.
Metrics visualization: Create charts, graphs, and dashboards that show key
metrics like performance, engagement, or user retention.
Attention to detail
Optimization of reports: adaptation of visualizations to increase usability,
Analytical thinking
interactivity and speed of updating reports.
Critical thinking
The result is intuitive and interactive reports that help make decisions to
Problem solving
optimize business processes.
Collaboration

WORK EXPERIENCE
Head of the corporate sales department in an insurance company Euroins
TOOLS
Ukraine
2011-now
Excel
Organization, search, collection and conduct of marketing research;
Tableau
Analyze tender offers;
Power BI
Analysis of the market and competitors, new assortment;
Amplitude
Predict patterns of customer behavior, taking into account the activity of
Google Analytics
competitors and identify market trends.

LANGUAGES EDUCATION
Ukrainian - Native IT School "GoIT" Odesa National Economics University
English - per-Intermediate Data Analist Faculty of international economy
2024 2006 - 2011