Ярослав

Yaroslav Mykytyn
Email: [открыть контакты](см. выше в блоке «контактная информация») ​ LinkedIn: [открыть контакты](см. выше в блоке «контактная информация»)
Phone: [открыть контакты](см. выше в блоке «контактная информация»)​ City: Lviv
Date of birth: 09/10/2002​ Telegram: @yaroslav_mykytyn

Working Experience

Yalantis | Data Engineer | April 2026 – Present
●​ Engineered and maintained end-to-end data pipelines involving ClickHouse and Snowflake, leveraging dbt
models to ensure robust data transformations.
●​ Implemented and managed Airflow workflows to automate data orchestration and validate data consistency
between Snowflake dynamic tables and dbt models.
●​ Developed ad-hoc Python and Pandas scripts for comprehensive data profiling, exploration, and validation,
ensuring high data quality and reliability.
●​ Conducted in-depth data research and distribution analysis to define data structure and optimize storage
and retrieval processes.

VisiQuate | Junior Data Engineer | March 2025 - April 2026
●​ Completed intensive Data Engineering training with focus on SQL Server, SSIS, and ETL workflows
●​ Designed and maintained foundational ETL pipelines using SSIS, ensuring reliable data movement and
transformation
●​ Acquired practical knowledge of Kimball methodology and core data warehouse architecture principles
●​ Contributed to building and testing pipelines, as well as automating processes under guidance of senior
engineers
●​ Interacted with cloud storage platforms (Azure Blob Storage, AWS S3), gaining foundational knowledge
and hands-on familiarity with their interfaces

PwC | Junior Data Analyst | October 2024 – March 2025
●​ Utilized Alteryx, SQL, Klik/Halo, and Excel to perform data transformations and automate processes for
financial data analysis.
●​ Conducted Completeness tests to ensure data accuracy and reliability, working with large datasets in .csv,
.xlsx, and .txt file formats.

SKILLS

SQL: Programming Document Editors: Cloud Languages: Orchestration:
Microsoft Languages: Microsoft Excel Technologies: Ukrainian: SSIS packages,
SQL Server, Python (Data Types, (VLOOKUP, Basic knowledge native, Airflow, dbt.
Snowflake, Manipulating Excel HLOOKUP ), of Azure, AWS English: C1
ClickHouse. Sheets, Pandas, Word,
Numpy) Google Sheets & Docs,
MS PowerPoint

Pet-Projects

Pizza Sales Analysis ​
●​ Leveraged Power BI to perform comprehensive data analysis for a Pizza Store, discovering valuable insights
about various pizza types and sales patterns.
●​ Used various visualizations, including column charts, area charts, donut charts, and cards, to effectively
show monthly trends, total orders, and total sales by category.
●​ Utilized advanced DAX functions and measures to calculate key performance indicators (KPIs) and
implemented time and category slicers to contribute a deeper understanding of specific pizza types.

EDUCATION

Lviv Polytechnic National University | Bachelor of Computer Science ​ Lviv | September 2020 - January 2022