Yurii

Yurii Chihur Summary

DATA ANALYST I am a Data Analyst with a background in law and
investigations. I have experience working with relational
[відкрити контакти](див. вище в блоці «контактна інформація») databases and preparing data for analysis. I use SQL and
Python (Pandas, NumPy) to analyze user behavior, work with
[відкрити контакти](див. вище в блоці «контактна інформація») cohort analysis, and check A/B test results. I also build clear
dashboards in Tableau and Power BI. My legal experience
Milan, Italy (Remote,
helps me work with complex logic, pay attention to details,
Relocate)
and solve non-standard problems.
LinkedIn
GitHub Professional Experience
Telegram
Data Analyst
04/2026 – Present
Skills •Analyzed complex datasets using SQL and Python to
extract actionable business insights and identify growth
Spreadsheets: Pivot Tables,
•

trends.
Data Cleaning, Visualization •Designed and developed interactive Tableau dashboards to
SQL: Advanced Queries,
•

track key performance metrics (KPIs) and visualize data.
Window Functions, Query •Performed Exploratory Data Analysis (EDA), data cleaning,
Optimization, Common and preprocessing to ensure data accuracy and integrity.
Table Expressions (CTE) •Formulated and tested hypotheses, conducted A/B testing
Python: Pandas, NumPy,
•

analysis, and delivered data-driven recommendations.
Matplotlib, Seaborn,
Exploratory Data Analysis Legal Analytics & Investigative Specialist
(EDA) 04/2024 – 10/2025
Tableau / Power BI:
•

Interactive Dashboards, Data Technologies or Tools: Advanced Excel, Google Sheets,
Storytelling, Publishing OSINT, Public Registries, Legal Databases.
Statistics: Sampling,
•

Case Pipeline & Dynamics Analytics: Processed and
Hypothesis Testing,
•

analyzed structured case data across 1,000+ legal
Correlation, Statistical proceedings using Advanced Excel and Google Sheets,
Significance tracking case statuses, closure rates, and procedural
A/B Testing: Planning,
•

timelines to optimize workflow distribution.
Analysis, Reporting Jurisdictional & Regional Risk Mapping: Conducted
Other Tools: Jupyter
•

•

multi-regional comparative analytics on legal activity,
Notebooks, Google Analytics, identifying high-volume risk zones and delivering monthly
Excel, Git. reporting dashboards for management.
Classification & Severity Categorization: Developed an
•

Education analytical framework for filtering and categorizing legal
cases by risk severity, reducing response and processing
Bachelor Degree in Law, Lviv times for critical proceedings by 15%.
State University of Internal Affairs Open-Data & OSINT Research: Cross-referenced entity
•

08/2020 – 04/2024 profiles using open-source intelligence (OSINT) and public
Lviv, Ukraine administrative registries, ensuring compliance, identity
verification, and data accuracy across analytical reports.
Reporting & Data Consolidation: Consolidated
•

Courses heterogeneous legal data into standardized spreadsheet
reporting models, improving reporting accuracy and
Data Analytics Course , supporting data-driven decision-making.
Mate academy
Languages Projects

Ukrainian (Native)
• E-Commerce-Data-Analytics-Statistical-Hypothesis-
English (Intermediate - B1)
• Testing
Italian (Elementary - A1)
•

A-B-Testing-Product-Experimentation-Analytics

Achievements Exploratory Data Analysis (EDA) for Online Store

Volleyball — Achieved First User Engagement & Business Performance Analytics (SQL
Adult Rank in Competitive / BigQuery)
Volleyball, demonstrating long-
term discipline, high-stress B2B Sales Pipeline & CRM Analytics Case Study
resilience, and effective team
coordination. Executive-B2B-Sales-Pipeline-Revenue-Analysis

E-Commerce Data Quality, Cohort & Retention
Analysis