statusopen to new roles
roleAnalytics Engineer · Data Engineer
locationAugsburg, Bavaria, Germany
experience7 yrs commercial
backgroundElectronics → Marketing → Data
languagesEN (fluent) · DE (B1)
Analytics Engineer·Data·Engineering

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.

Portrait of Ivan Yermakov
Summary

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.

7+
years exp.
18.85
peak ROAS
40+
domains automated
300%
revenue growth
Work

Experience

Jan 2025
— Now

current
Elithair
Analytics EngineerBerlin, Germany · remote
  • 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.
BigQuerySQLdbtPythonETLLooker StudioGTMStape.ioGDPR
Aug 2023
— Jun 2025
Mix
Marketing Analytics EngineerRemote · Freelance
  • 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.
Google AdsMeta AdsLooker StudioGTMAnalyticsE-commerce
Oct 2022
— Dec 2023
Comtogether
Digital Marketing ManagerGeneva, Switzerland · remote
  • 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.
NestléRenaultGAGTMSEOPPCProgrammatic
Oct 2018
— Feb 2022
Nikos Media
PPC Analyst · Digital Marketing ManagerKharkiv · USA, Australia, UK, EU markets
  • 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.
Google AdsFacebook AdsGAGTMHotjarPower BIData Studio
Stack

Skills

Data Warehousing & Modeling
BigQuerySQLdbtDuckDBData ModelingData QualityIncremental LoadsScheduled Queries
ETL & Orchestration
PythonPandasPolarsMageAIAirbyteDagsterWebhooksZoho CRM API
Tracking & Collection
GA4Server-side GTMStape.ioMeta PixelTikTok Pixel
BI & Visualisation
Looker StudioZoho AnalyticsPower BIStreamlitData Studio
Infrastructure & DevOps
DockerPortainerProxmoxCronicleDebian LXCGitCI/CD
Advertising APIs
Google Ads APIMeta Ads APIOffline Conversions
Academic

Education

2014 – 2016
Master's in Physical and Biomedical Electronics
NTU 'Kharkiv Polytechnic Institute' — Kharkiv, Ukraine
2010 – 2014
Bachelor's in Micro- and Nanoelectronics
NTU 'Kharkiv Polytechnic Institute' — Kharkiv, Ukraine
EnglishFluent
GermanB1 · Zertifikat
Ukrainian / RussianNative
Writing

Latest notes