Automation Engineer (Python / Airflow / SQL)

Python automation of reports and recurring tasks — Airflow, SQL, CI/CD, scripts

pythonairflowsqletldockergitlab cicelery

Kazan, RussiaExperience: 2 years 4 monthsExpected: $2,000–2,400 / month (net)Open to relocating to Moscow

Python developer; I automate manual processes, calculations and reporting. On my current project — recurring operations and data preparation.

Relevant experience:

Automated manual report preparation (−40–60%) and recurring checks/calculations via Airflow.
Python scripts that replaced manual operations.
Stabilized recurring pipelines: handled edge cases, fewer manual interventions.
CI/CD on GitLab CI (manual deploy time cut by more than 2×), containerization in Docker.
Optimized heavy SQL queries and processing stages (30–70%).
Worked with production processes and legacy code.

Experience

May 2025 — present

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

March 2024 — May 2025

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

PythonSQLPostgreSQLMS SQLSQLAlchemy

Apache AirflowETLData VaultSQL optimization

FastAPIDjangoDjango REST FrameworkREST APICeleryRabbitMQRedisMicroservicesAPI integration

DockerGitGitLab CICI/CDLinuxPytest

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

Russian (native), English B1, Spanish A2