Олег

Kovalkov Oleh
Analytics Engineer / Data Engineer
Analytics & Data Engineer experienced in building end-to-end data
pipelines, modern data warehouses, and automated marketing analytics
across various business domains.

CONTACTS WORK EXPERIENCE
Analytics / Data Engineer | Marketing Analytics Agency
[відкрити контакти](див. вище в блоці «контактна інформація»)
2024 – Present
[відкрити контакти](див. вище в блоці «контактна інформація») ● Production DWH & dbt Architecture: Built and maintained
multi-layer data warehouses in BigQuery (staging,
Telegram intermediate, marts) using dbt with unit tests, data quality
assertions, and automated CI/CD checks across 90+
Linkedin repositories for 17+ clients.
Kharkov, Ukraine ● Idempotent ELT Pipelines: Designed robust Python & SQL
ETL/ELT pipelines for Meta Ads, Google Ads, GA4, RedTrack,
and CRMs (KeyCRM, Zoho, Kommo, Planfix) using staging
HARD SKILLS tables with MERGE logic ensuring zero-duplication on reruns.
● Python (Pandas, LightGBM) ● Backend & Integration Microservices: Developed
● SQL microservices on NestJS (TypeScript strict) and GCP Cloud
● ETL,ELT Functions for server-side event tracking, webhooks
● Business Intelligence processing, and automated Meta CAPI / GA4 conversion
● Git dispatching.
● LangChain ● Predictive ML & Applied AI Workflows: Built demand
● dbt (Unit Testing & Data forecasting models (LightGBM) and production RAG AI
Contracts) marketing assistants (pgvector, LangGraph, OpenAI API) for
● Airflow automated chat and lead categorization.
● NestJS / TypeScript ● Reliability & Observability: Established automated GCP
budget controls, Telegram alert channels for pipeline failures,
● GCP / BigQuery and pre-commit secret scanning (gitleaks).
● CI/CD (GitHub Actions)
● PostgreSQL Product Data Analyst | GMC group (2023 – 2024)

TOOLS ● Analyzed product and user behavior metrics across Web,
● Looker Studio Mobile, and Smart TV streaming platforms (DAU/MAU,
● Google Analytics 4 (GA4) Retention, LTV, CAC, Churn, MRR, ARPPU).
● GCP (GCF, BigQuery) ● Designed and maintained ELT pipelines on AWS and built
● KeyCRM, Zoho CRM, Planfix executive dashboards in Tableau / Looker Studio.
CRM, ImooxCRM ● Modeled unit economics and user conversion funnels,
identifying key growth points that directly boosted ARPPU and
● Docker
subscriber Retention.
● Cloud Build
● Conducted anomaly detection in user behavior profiles to
● Secret Manager
optimize product onboarding and customer journeys.
● Poetry
Technical Founder & Lead Architect | (2012 – 2023)
CERTIFICATES
● ETL and Data Pipelines with ● Founded and scaled an OTT Internet Television service from
Shell, Airflow and Kafka scratch to tens of thousands of active subscribers across
● Data Analytics and Databases Ukraine.
on AWS ● Built and led a cross-functional engineering and product team
● Introduction to Statistics to deliver applications for Smart TV, iOS, Android, and Web
Stanford University platforms.
● Introduction to NoSQL ● Managed product architecture, unit economics, P&L, financial
Databases planning, and operational strategy.
● Introduction to Information
Technology and the AWS Cloud EDUCATION
National Aerospace University IT School "GoIT"
SOFT SKILLS Kharkiv Aviation Institute Data Analytics & M.S. in
● Calm Engineering Design Engineering (2023)
● Conscientious LANGUAGES
● Decision making skills ● Ukrainian - Fluent
● Organizational skills ● English - English - Intermediate (Technical & Written)
● Good sense of humour
● Russian - Native