Дмитро

Dmytro Savka
DB / BI Developer
■ Lviv, Ukraine
■ [open contact info](look above in the "contact info" section)
✉ [open contact info](look above in the "contact info" section)
■ [open contact info](look above in the "contact info" section)

PROFESSIONAL SUMMARY

Business Intelligence and Database Developer with 7.5+ years of experience designing and optimizing data
solutions for enterprise-scale environments. Hands-on expertise in ETL pipeline development, data modeling, dbt,
Databricks, and SQL Server. Proven track record of improving data quality through automated testing and
refactored pipelines. Comfortable with direct client communication in English and cross-functional collaboration in
Agile teams.

TECHNICAL SKILLS

Core Technologies
MS SQL · SQL Server · T-SQL · MySQL · dbt · Databricks
ETL & Data Modeling
SSIS · Stored Procedures · Incremental Loads · Delta Lake
BI & Reporting
SSRS · Tableau
Testing & Quality
dbt tests · Data validation · Data quality automation
Version Control
dbt built-in version control · Git basics
Project Management
Jira · Confluence · Agile (Scrum) · Waterfall
Languages
SQL · HTML/CSS · Basic JavaScript
English Level
B2 — written & spoken (direct client communication)

WORK EXPERIENCE

DWH / ETL Developer
Proffiz | Client: Avanquest (Claranova Group, France)
Nov 2020 – Present · 5 yrs 7 mos · Remote
• Designed and maintained dbt data models with incremental load strategies, processing millions of rows daily across
multiple product lines (PDF software, photo editing, PC utilities).
• Developed and optimized ETL pipelines using SQL Server stored procedures and dbt; refactored legacy code reducing
codebase size and improving maintainability.
• Built reusable dbt macros (custom functions, CASE replacement logic) that standardized transformation patterns across
the project.
• Implemented dbt data quality tests (not-null, uniqueness, referential integrity, custom validations), significantly reducing
data quality incidents across pipelines.
• Used Databricks as a data exploration and validation layer to verify pipeline outputs and investigate data anomalies.

• Conducted direct client communication in English (written and verbal) — clarified requirements, reported progress,
and discussed technical solutions.
• Worked in a 6-person Agile team, tracked tasks in Jira / Confluence, participated in sprint planning and retrospectives.
Stack: SQL Server · dbt · Databricks · Jira · Confluence

DB Developer
SoftServe | Internal Management Project
May 2019 – Nov 2020 · 1 yr 7 mos
• Designed end-to-end database architecture: OLTP system, Staging DB, and Data Warehouse — including schemas,
tables, indexes, constraints, triggers, views, stored procedures, and functions.
• Built SSRS reports and Tableau dashboards from Data Mart layer for business analytics across a retail shop network.
• Managed SSIS packages for data loading and transformation between operational and analytical layers.
• Participated in requirement analysis and contributed to data model design decisions.
Stack: SQL Server · SSIS · SSRS · Tableau

EDUCATION

SoftServe IT Academy
Data Modeling, Warehousing & Database Administration
Lviv State University of Physical Culture
Specialist — Physical Rehabilitation
College of Lviv State Institute (Chornovil)
Junior Specialist — Business Economics