Ігор

Makartsov Ihor
Data Analyst
Ostrava, Czech Republic |[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) | [Link to Portfolio]

PERSONAL SUMMARY
Data Analyst with commercial experience in risk analytics and a professional background in finance and audit,
including KPMG and Baker Tilly. Experienced in SQL, Python and BI tools for financial data analysis, reporting
automation, KPI monitoring and root-cause analysis. Hands-on experience includes automating reporting
workflows, optimizing SQL processes, building dashboards and analyzing financial and risk metrics. Combining
financial domain knowledge with technical analytics skills to turn complex data into actionable business
insights.

HARD SKILLS
Data Analysis • SQL & Database Querying • Python Programming • Data Cleaning & Validation • Financial
Analysis • Risk Analysis • Statistical Analysis • Hypothesis Testing • KPI Reporting • Dashboard Development •
Data Visualization • Reporting Automation • Unit Economics & Financial Modeling • Cohort & Conversion
Funnel Analysis • Customer Segmentation (RFM) • A/B Testing

TOOLS
PostgreSQL • Google BigQuery • Python (Pandas, NumPy, Matplotlib, Seaborn) • Microsoft Power BI • Tableau •
Metabase • Looker Studio • Excel (Power Query, Pivot Tables) • Google Sheets • GA4 • Amplitude

SOFT SKILLS
Analytical Thinking • Problem Solving • Cross-Functional Communication • Team Collaboration • Proactive
Mindset • Critical Thinking • Adaptability

PROJECT EXPERIENCE

User Conversion & Retention Insights
[Link to Code] [Link to Tableau Dashboard]
Tools: SQL (BigQuery), Tableau, Google Analytics 4
Description: Engineered an end-to-end product analytics dashboard using raw GA4 event-level data
to diagnose user drop-offs, platform disparities, and customer retention dynamics.
My tasks: Extracted and aggregated raw database events using SQL, implemented cohort retention
analysis (weekly churn tracking), designed multi-stage conversion funnels, segmented acquisition
channels, and established market benchmarks for ARPU/ARPPU.
Result: Pinpointed a critical 81% drop-off between product views and cart additions, identified a
massive Week 2 cohort retention cliff where the majority of new users churn

US Tech Sector ESG Investment Strategy & Market Valuation
[Link to Code] [Link to Tableau Dashboard]
Tools: SQL, Tableau, Excel, Python (Pandas, NumPy, SciPy, Statsmodels, Seaborn, Matplotlib).
Description: Built an investment decision-making framework analyzing the impact of ESG
(Environmental, Social, Governance) performance on the market valuation and financial risk of 22
major US tech companies.
My tasks: Performed non-linear regression analysis (OLS, VIF, Hypothesis Testing), calculated
financial metrics (ROA, Tobin's Q, Leverage, Price-to-Book), segmented industry sub-sectors using
SASB and IFRS S2 standards, and built correlation matrixes.
Result: Proven an inverted U-shaped relationship between ESG and corporate value with a strict
financial optimum at 58.42 points (beyond which ESG spending destroys FCF), identified a 27.54%
"social penalty" driven by non-core philanthropy

WORK EXPERIENCE

BitCapital, Risk Analyst March 2026 - October 2026
Automated SQL data extraction and Google Sheets workflows via Python scripts, accelerating report
generation by 3x and saving 15+ manual hours weekly.
Co-designed and analyzed an A/B test (80/20 split) for a updated credit scoring model, increasing
approval rates for first-time borrowers and boosting repeat client retention.
Conducted root-cause analysis on credit metric deviations, delivering actionable insights that improved
monitoring
Refactored legacy SQL workflows for large-scale financial datasets, cutting query execution time by 50%
and improving overall analytical performance.
Consolidated diverse data sources into automated Metabase dashboards, expanding tracked KPIs to 15+ and
improving data availability for 3+ key stakeholders.

KPMG Ukraine, Junior Audit Data Analyst February 2025 - November 2025
Analyzed and validated complex financial datasets during audits of 30+ international and local enterprises,
ensuring high data integrity and compliance.
Performed data reconciliation, financial risk assessment, and variance analysis to identify discrepancies
and anomalies across large-scale accounting systems.
Optimized data verification procedures and designed analytical sampling models, accelerating the
preparation of final risk assessment reports.
Led data collection and digital reporting processes (XBRL), streamlining confirmation request workflows
and cross-checking data accuracy across multiple clients.
BakerTilly, Junior Accountant-Auditor July 2024 - January 2025
Conducted financial data verification, analytical procedures, and variance analysis across large datasets for
major clients in the tech and defense sectors.
Automated routine data cross-checking and sampling procedures using advanced Excel techniques (Power
Query, Pivot Tables), significantly reducing processing time.
Executed data matching and reconciliation between physical asset records and internal accounting
databases to eliminate reporting discrepancies.

EDUCATION

National University of Kyiv-Mohyla Academy [Link] 2022 - 2026
Bachelor's degree; Finance, banking and insurance. GPA: 92
Virtual International Program, Justus Liebig [Link] October 2025 - February 2026
University Giessen, Germany
Completed an accredited mobility course in Competition Policy and Strategy with top grades, focusing on
market analysis and strategic decision-making.
Data Analyst, IT School GoIT [Link] June 2025 - January 2026
Acquired hands-on experience in SQL, Python, Power BI, and statistical analysis for business decision-making.
Scrum and Agile practices, Skillsetter July 2025 - September 2025
Mastered Agile frameworks and Scrum workflows to optimize project management and cross-functional team
delivery

LANGUAGES
English - Intermediate Ukrainian - Native Czech - Beginner Russian - Advanced

SOCIAL ACTIVITIES

Copywriter Participant
East West Business business environment Balakun, Engine