Denis Golikov RU
Denis Golikov Open to work

Denis Golikov · Python Developer (Backend / Data Engineer)

Data Engineer (Python / SQL / Airflow)

Data engineer — Airflow, SQL optimization, ETL, Data Vault 2.0

pythonsqlpostgresqlmssqlairflowetldata vault
Kazan, RussiaExperience: 2 years 4 monthsExpected: $2,000–2,400 / month (net)Open to relocating to Moscow
Download this CV (PDF) On hh.ru
drakonniravgol@gmail.com+7 919 0391379@D4eNsthh.ru

Python/SQL data engineer with 2 years 4 months of experience. On my current project (Rostelecom group, government contract) I run Airflow data pipelines, optimize heavy SQL queries and develop a Data Vault 2.0 reporting subsystem.

Relevant experience:

  • Airflow pipelines for regular data processing; stabilized by handling edge cases.
  • Deep SQL: CTEs, window functions, aggregations, temp tables; sped up heavy queries by 30–70%, some from tens of minutes to a few minutes.
  • PostgreSQL and MS SQL; migrated and adapted SQL logic from MS SQL to PostgreSQL.
  • Data Vault 2.0 — contributed to the reporting subsystem.
  • Automated manual data preparation for reporting (−40–60%).
  • Worked in a corporate project with legacy logic and production data; responsible for calculation correctness.

Experience

Python Backend Developer (automation & reporting)

May 2025 — present
RTK — Digital Document Management (Rostelecom group, government contract)
  • Backend logic and automation in Python
  • Airflow pipelines for regular data processing
  • PostgreSQL and MS SQL; optimized heavy raw SQL queries (30–70% faster)
  • Migrated and adapted SQL logic from MS SQL to PostgreSQL
  • Reporting subsystem built with Data Vault 2.0
  • Automated report preparation in Airflow, reducing manual work by 40–60%
  • Advanced SQL — CTEs, window functions, aggregations, temp tables; reverse-engineering legacy code
PythonAirflowPostgreSQLMS SQLSQLData VaultETLGit

Backend Developer

March 2024 — May 2025
Production Reserves LLC (Kazan)
  • Backend for a mobile app — API, DB, integrations with external services
  • REST API on Django REST Framework for internal and external services
  • SQL and DB optimization (PostgreSQL, Django ORM, SQLAlchemy) — average API response time −30%
  • CI/CD on GitLab CI — manual deploy time cut by more than 2×
  • Deferred/periodic tasks on Celery + RabbitMQ
  • Containerization (Docker, docker-compose), logging & monitoring (ELK, Prometheus, Grafana)
  • Auto API docs via drf-spectacular; unit and integration tests
PythonDjangoDRFPostgreSQLSQLAlchemyCeleryRabbitMQDockerGitLab CIPytestELKPrometheusGrafanaREST API

Skills

Languages & DB

PythonSQLPostgreSQLMS SQLSQLAlchemy

Data & ETL

Apache AirflowETLData VaultSQL optimization

Backend

FastAPIDjangoDjango REST FrameworkREST APICeleryRabbitMQRedisMicroservicesAPI integration

Infrastructure

DockerGitGitLab CICI/CDLinuxPytest

Education & languages

Education

BSc 2025, Kazan Federal University — Computational Mathematics & IT (Information Systems & Technologies)

Languages

Russian (native), English B1, Spanish A2

Contacts

drakonniravgol@gmail.com+7 919 0391379@D4eNsthh.ru