Ivan
Yermakov.
Analytics Engineer specialising in BigQuery data warehouses, Python ETL pipelines, and server-side tracking infrastructure. 7 years across global brands, agencies, and high-growth e-commerce.

Analytics Engineer with 7 years of commercial experience designing and maintaining production-grade data infrastructure for performance marketing environments. Specialised in BigQuery SQL, Python-based ETL pipelines, and server-side event collection architectures (GTM, Stape.io).
Builds end-to-end data systems — from raw event ingestion and incremental data modelling to multi-touch attribution reporting and automated BI delivery — across stacks processing data from 40+ web domains. Experienced shipping GDPR-compliant tracking solutions for cookie-less environments. Worked with clients including Nestlé, Renault, MSC, and the world's largest hair transplant clinic.
Experience
— Now
current
- Architected and maintain a BigQuery data warehouse integrating event streams from 40+ web domains, enabling centralised cross-domain performance analytics.
- Designed production-grade data models and incremental ETL pipelines using parameterised SQL and BigQuery scheduled queries, powering a real-time funnel daily summary table and replacing manual reporting.
- Implemented data quality validation checks and governance protocols across the warehouse, ensuring consistent and reliable data for executive-level stakeholder reporting.
- Built a multi-touch attribution system in BigQuery with Looker Studio dashboards, giving the marketing team channel-level ROI visibility for the first time.
- Implemented offline conversion tracking pipeline from Zoho CRM to Google Ads and Meta Ads via server-side GTM webhook integrations, bridging CRM lead data with paid media spend.
- Deployed 100% GDPR-compliant server-side tracking infrastructure (GTM + Stape.io) across all digital touchpoints.
- Built a Python async scraper (Docker + Cronicle + Telegram) for Google Ads data collection, automating performance alerting and eliminating daily manual data pulls.
— Jun 2025
- Built multi-channel performance dashboards integrating Google Ads, Meta Ads, and organic data into unified reporting for e-commerce executive teams.
- Delivered analytics-led campaign optimisation driving measurable revenue impact: Gas Bikes +300% revenue, ROAS 250% → 850%; WR Performance +676% revenue in 2 months; RiRoo Cars +262% ROAS.
- Implemented GTM tracking architectures, conversion funnel analysis, and tag audits across multiple client properties.
— Dec 2023
- Delivered campaign analytics and BI reporting for Tier-1 clients: Nestlé, Renault Swiss, GÉMO Suisse, MSC, and Maurice Lacroix.
- Built cross-channel analytics frameworks integrating GA, GTM, and social platform data to attribute ROI across SEO, PPC, and programmatic channels.
- Implemented tracking setups and structured performance reports enabling data-driven decisions across cross-functional agency teams in Switzerland.
— Feb 2022
- Managed analytics and paid media infrastructure for international e-commerce clients; achieved 18.85 ROAS (Coffeehit UK), $6.30 CPS (AddPopular), and scaled Minnow Designs (AU) from launch to sustained profitability.
- Built digital analytics stacks using GA, GTM, Hotjar, Data Studio, and Power BI for campaign measurement across Google Ads and Facebook Ads.