Андрей

🌐 More info on my portfolio website: saprland-12307.web.app

Sapryhin Andrii
📧 [відкрити контакти](див. вище в блоці «контактна інформація»)
📱 [відкрити контакти](див. вище в блоці «контактна інформація»)
🐙 GitHub · 💼 LinkedIn · ✈️ Telegram
📍 Odesa, Ukraine · Open to Remote

ABOUT ME
Analytics Engineer with 4+ years of software development background and strong
specialization in dbt, SQL, and Data Warehouse design. Experienced in building 3-tier
DWH architectures (Staging → Intermediate → Marts), optimizing incremental models,
and implementing CI/CD pipelines. Strong foundation in financial and product analytics
(MRR, Churn, Renewal). Self-taught Data Engineer with hands-on project experience.
SKILLS
Core Tools dbt Core/Cloud, SQL (PostgreSQL, BigQuery), Python 3.x
Data Modeling Dimensional Modeling (Kimball), Star/Snowflake Schema, SCD
Type 2, Incremental Models, Snapshots, Data Marts
Templates Jinja2, dbt_utils, Custom Macros, Schema YAML Tests (not_null,
unique, accepted_values)
DevOps/DataOps Git, GitHub Actions CI/CD, Docker, Dev/Prod Environment Isolation
Additional Linux/macOS CLI, REST APIs, Financial Domain (MRR/Churn
calculations)
AI & GitHub Copilot, ChatGPT, Gemini, Prompt Engineering, Workflow
Automation Automation
Languages English — B1-B2 (Intermediate / Upper-Intermediate)
EXPERIENCE
Software Developer (Full-Stack) May 2022 — Present
Independent / Contract Projects
• Designed and implemented 3-tier DWH architecture (Staging → Intermediate →
Marts) for financial analytics, reducing query complexity by strictly separating raw
data, business logic, and presentation layers.
• Optimized large fact tables using dbt incremental models (is_incremental(),
unique_key, merge strategy), reducing mart build time from minutes to seconds.
• Built financial product analytics marts (MRR, Renewal, New MRR, Churn Rate) with
calendar gap-filling and dbt_utils.pivot for time-series analysis and BI dashboards.
• Implemented comprehensive data quality testing via schema.yml (not_null, unique,
accepted_values, relationships), catching data anomalies before production
deployment.
• Automated CI/CD pipeline with GitHub Actions and isolated PostgreSQL Docker
containers — dbt build runs automatically on every Pull Request with test reporting.
• Developed custom Jinja2 macros (safe division, dynamic pivots), SCD Type 2
snapshots, and isolated dev/prod dbt profile configurations for safe deployments.
PROJECTS
Financial DWH with dbt + PostgreSQL
Personal project implementing complete DWH architecture with 3-tier structure (Staging →
Intermediate → Marts), incremental models for large datasets, comprehensive schema tests,
and automated CI/CD pipeline via GitHub Actions.
EDUCATION
IT Step Academy, Odessa — Bachelor's Degree, Information Technology 2019 —
(with distinction) 2023

🌐 Portfolio: saprland-12307.web.app