6+ years of experience · since 2020

PavloSiryi

Web analyst and Python backend developer · Kyiv, Ukraine

I build data pipelines and marketing integrations: API connectors for advertising platforms, ETL workflows into BigQuery, and automated reporting.

Self-taught Python developer writing code since 2020. With a formal background in real estate and land valuation, my earliest Python projects focused on property market analytics.

Currently

MixDigital

Marketing agency, Analytics and PPC team

Working here as a web analyst and backend developer since April 2023.

  • API connectors for about twenty advertising platforms (Google Ads, Meta, TikTok, DV360, LinkedIn, AppsFlyer, and others) in a shared Python monorepo.
  • Scheduled ETL services on Google Cloud ingesting advertising statistics, client CRM orders, and product feeds with hundreds of thousands of items into BigQuery.
  • Multi-thousand-line SQL pipelines and layered views in BigQuery powering 5+ end-to-end analytics systems combining advertising, web analytics, and CRM data.
  • Automated client reporting and dashboards in Google Sheets and Looker Studio.
  • Web analytics: GA4, GTM, server-side tracking, and offline conversion imports into ad platforms.
  • Forwarding leads from ad forms to client CRMs via APIs, including Microsoft Dynamics 365.
  • Hundreds of Google Apps Script automations sharing a common library: triggering cloud functions from Google Sheets and auditing planned vs. actual ad campaign performance.
  • Internal agency tooling: a billing dashboard built with React and TypeScript, a Telegram notification bot for client chats, and a knowledge-base RAG bot.

Past Experience

newage. digital agency

Python backend developer, analyst · October 2021 – March 2023

  • ETL pipelines on Python and Google Cloud with Cloud Functions and virtual machine backends.
  • Automated reporting system on Python, BigQuery, and Looker Studio: maintenance, query optimization, and feature development.
  • API integrations with multiple services, primarily Google, Meta, and payment providers Wise and Paysera.
  • Dashboards in Looker Studio, Google Analytics, Google Optimize, and GTM setup with JavaScript; workflow automation using Apps Script.

VERITEX LTD with FC

Python backend developer, database administrator, market data analyst · January 2020 – September 2021

  • Asynchronous web scrapers for two major property marketplaces.
  • Ukrainian real estate market analytics, statistical modeling, and hypothesis testing.
  • Machine learning models predicting real estate market prices from marketplace data; partial automation of property appraisal workflows.
  • PostgreSQL and Linux server administration, lightweight client REST APIs, and a web application for valuation specialists.

Siryi Ads Reporter

Siryi Ads Reporter is a private reporting automation tool built and operated by Pavlo Siryi, an independent developer and web analyst. With the explicit permission of the account owner, it reads Google Ads account data — campaign performance metrics and Keyword Planner keyword ideas and forecasts — and delivers scheduled reports to that advertiser's own Google Cloud project (BigQuery) or Google Sheets. It does not create, modify or delete campaigns, ads, budgets or billing settings.

Privacy Policy  ·  Terms of Service

Education

National Transport University

Master's Degree, Land and Real Estate Valuation, 2019–2020

Skills

Languages: Ukrainian and Russian — fluent, English — reading and writing.

Writing

In my spare time, I write fiction: a dark fantasy crossover The Second Apocalypse × Chainsaw Man.

Contact