Tetiana

TETIANA LOZOVA
Junior Marketing Analyst / Data Analyst
tel: [відкрити контакти](див. вище в блоці «контактна інформація») e-mail: [відкрити контакти](див. вище в блоці «контактна інформація») location: Kharkiv, Ukraine
[відкрити контакти](див. вище в блоці «контактна інформація»)
https:t.me/Tetiana132

SUMMARY
Data Analyst with practical experience in marketing analytics, campaign performance
tracking, and data visualization. Skilled in SQL (BigQuery, PostgreSQL), Python, and BI
dashboards (Tableau, Power BI). Hands-on experience analyzing GA4 logs, building customer
acquisition funnels, evaluating campaign ROI/ROAS, and conducting A/B tests. Proven ability
to translate complex digital marketing data into actionable business recommendations to
optimize ad spend. Backed by a strong engineering background (14 years) focused on
process efficiency.

SKILLS
Marketing Analytics & Metrics: Customer Acquisition Cost (CAC), ROAS/ROI, Conversion
Rate (CR), CTR, CPA, LTV, Retention, Churn, Funnel Optimization.
Web & Data Tools: GA4 (Google Analytics 4), Google BigQuery, SQL (CTEs, Window
Functions), DBeaver.
BI & Data Visualization: Tableau, Power BI, Looker Studio, Google Sheets.
Programming & Statistical Tools: Python (Pandas, NumPy, Matplotlib, SciPy - A/B Testing),
Jupyter Notebook.
TOOLS
Excel
Google Sheets
DBeaver
Jupyter Notebook
BI Tools: Tableau, Power BI , Looker Studio
Python: Pandas, NumPy, Matplotlib, Seaborn
BigQuery

SOFT SKILLS
Thinking
Problem Solving
Team Collaboration
Adaptability
Communication Skills

PROJECT EXPERIENCE
E-commerce Marketing Funnel Analysis | [View on Google Drive]
Tools: BigQuery (SQL), Tableau, GA4 Data
Processed raw GA4 event logs in BigQuery using SQL (CTEs, Window Functions) to trace user
acquisition paths and build a full customer journey map.
Built an interactive Tableau dashboard visualizing conversion rates across each funnel stage
(from session_start to purchase).
Identified key drop-off points in the user journey, generating insights to optimize landing
pages and improve overall marketing campaign ROI.

E-Commerce A/B Testing & Dashboarding | | [View on GitHub]
Tools: Python, Pandas, Jupyter Notebook, Power BI
Statistical Analysis: Conducted A/B test analysis in Python using Z-tests ($p < 0.0001$) to
evaluate website redesign impact on Conversion Rate, Session Duration, and Pages Visited.
Audience Insights: Uncovered a statistically significant conversion uplift (+34.65%) and
pinpointed target group anomalies (specifically in the 25–34 age segment).
Business Decision Support: Built a multi-page interactive Power BI dashboard with
demographic slicers and DAX KPIs to help product and marketing teams optimize target
campaigns.
E-commerce Business & Sales Performance Dashboard | [link to Tableau Public]
Tools: SQL, Google Sheets
Cleaned and processed raw e-commerce transaction data using SQL.
Tracked and visualized key business KPIs including Revenue, Average Order Value (AOV), and
Conversion Rates.
Analyzed product category performance to highlight high-margin items and seasonal trends.

Stack Overflow Developer Survey Analysis | [View on Google Drive]
Tools: Python, Pandas, Jupyter Notebook
Analyzed large real-world developer survey dataset using Pandas
Performed data cleaning, handling missing values, filtering, and grouping
Calculated descriptive statistics (mean, median, mode) and percentiles
Measured Python adoption rates and remote work distribution
Conducted compensation analysis by country for Python developers
Identified top-paid professionals and analyzed their education levels

WORK EXPERIENCE
JSC “Ukrainian Railways” | 2010-2024
Technological Engineer / Engineer
Analyzed technical processes and optimized workflows
Worked with documentation and technical reporting
Collaborated with cross-functional teams
Improved operational efficiency

EDUCATION
IT School GoIT | 2025-2026
Data Analytics Program
National Technical University “Kharkiv Polytechnic Institute”| 1999 – 2005
Master’s Degree in Mechanical Engineering

LANGUAGES
English -intermediate
Ukrainian- native