Marketing Data Analyst
Manila · UTC+8 · remoteIvan Kharlamov
I work with advertising and CRM data: pipelines, metrics, dashboards. Before that, six years in performance marketing, including Yandex and budgets over 1M$ a month.
01What I do
Analytics
Funnel from ad click to CRM revenue: web and app attribution, lead qualification rules, CPA and ROAS by campaign, media plan versus actual.
Data infrastructure
Collecting data from ad platforms and CRMs, storing it in PostgreSQL, scheduled daily ETL, reconciliation and data quality checks.
Automation
Cloud functions that handle the routine without a human: rebuilding product feeds, computing reports, tracking changes and reporting them.
LLM agents
Applied agents for real work: keyword research and cleanup, text and image generation, MCP integrations, and cost control per request.
02Stack
Languages and data
- Python
- SQL
- PostgreSQL
- ClickHouse
- TypeScript
- pandas
Pipelines and infrastructure
- Cloud Functions
- Docker
- S3
- Git
- CI/CD
- Vercel
Models and agents
- OpenAI API
- Anthropic API
- Gemini API
- OpenRouter
- MCP
- RAG
- Vector databases
- LLM output evaluation
Analytics and BI
- Yandex DataLens
- Power BI
- Yandex Metrica
- Google Analytics
- AppsFlyer
- Web and app attribution
- End-to-end attribution
Ad and CRM APIs
- Yandex Direct API
- Google Ads API
- Google Analytics API
- Yandex Metrica API
- Bitrix24 API
- Telegram Bot API
- Wordstat API
03Experience
April 2025 — present
Marketing data analyst
Education company · internal development
- End-to-end analytics: ETL from ad platforms and CRM into PostgreSQL, linking spend to closed deals, lead qualification rules.
- Attribution from ad click to revenue, CPA and ROAS by campaign, media plan versus actual.
- Dashboards and recurring reporting, reconciliation and data quality checks.
- Moved manual operations — feed assembly, reporting, campaign preparation — into automated cloud processes.
- Applied LLM agents for production tasks, MCP integrations, cost control per request.
- Side project in parallel: automation and analytics for a medical education centre.
December 2022 — April 2025
Senior advertising strategist
Yandex
- Analysed ad performance for large advertisers spending over 1M$ a month, found growth and optimisation points.
- Specialised in web plus app scenarios: AppsFlyer, SQL, universal link attribution.
- Built traffic analyses and growth hypotheses, presented them to clients.
- Auction mechanics, algorithms and product internals of Yandex Direct from the platform side.
January 2020 — December 2022
Media buyer
E-commerce · NDA
- Paid acquisition for e-commerce: Google Ads, Facebook Ads.
- Scaled spend while holding target cost per acquisition.
04Projects
→Product feed robot
Rebuilds a product feed for ad platforms every day and tracks catalogue changes.
Python · Yandex Cloud Functions · PostgreSQL
End-to-end analytics
Links ad spend to leads and deals from the CRM to measure cost per lead and cost per sale.
Python · PostgreSQL · ETL
Agent system for marketing work
A set of agents and skills that carry repetitive advertising work end to end.
LLM · MCP · Python
05Certificates
Certifications in ad platforms and analytics.
