Summary
Overview
Work history
Education
Skills
Languages
Timeline
Generic

Andrii Sokolov

Lisbon,Portugal

Summary

Experienced Data Architect with a strong focus on Cloud Computing, Data Warehousing, and Analytics. Proven track record in optimizing data pipelines and designing scalable data solutions for global companies in the pharmaceutical, telecommunications, and investment banking industries. Key achievements include architecting a Data Warehouse from scratch for a major pharmaceutical company and enhancing data transfer speeds by over 90% for a leading investment bank. Skilled in driving operational efficiency and cost savings using top-tier tools and platforms such as DBT, Spark, Fivetran, Snowflake, AWS Redshift, AWS Athena and Oracle

Overview

12
12
years of professional experience
5
5
years of post-secondary education

Work history

Data warehouse architect

Remobi
Lisbon, Lisbon
08.2024 - Current
  • Developed Data Warehouse from scratch for big Energy Company(including Logical and Physical data model, orchestration layer, ETL pipeline, BI layer)
  • Achieved streamlined data flow by designing and implementing effective ETL processes.
  • Led development of robust, scalable data warehouse structures for enhanced business intelligence.
  • Developed complex data transformations and calculations using dbt, enabling efficient data aggregation, filtering, and cleansing processes.
  • Increased performance of legacy ETL pipeline to 75%
  • Architected new databases, tables and dictionaries for project-specific requirements.

Senior Data Engineer

Erbis
Lisbon, Portugal
06.2021 - 10.2024
  • Optimized incremental data transfer from Oracle to Redshift, resulting in significant speed improvement. Incremental load time was reduced from 15 minutes to 30 seconds.
  • Utilised industry-leading tools to support ETL operations.
  • Identified issues within databases, troubleshooting technical problems and implementing practical solutions.
  • Evaluated, designed and modified databases and database applications to meet business needs.
  • Implemented utilisation, throughput and latency testing to maximise network capacity.

Senior DWH Engineer

DataMola
Kyiv, Ukraine
02.2019 - 07.2024
  • Developed Data Warehouse from scratch for big Pharma Company(including Logical and Physical data model, orchestration layer, ETL pipeline, BI layer)
  • Designed and implemented complete BI solution by leveraging dbt (Data Build Tool) for data transformations and modeling, integrating it with AWS Athena for querying data stored in S3.
  • Developed complex data transformations and calculations using dbt, enabling efficient data aggregation, filtering, and cleansing processes.
  • Utilized AWS Athena to perform scalable SQL queries on large datasets in Amazon S3, ensuring efficient data processing and analysis without need for complex ETL pipelines.
  • Optimized performance and cost-efficiency by utilizing dbt's capabilities to modularize data workflows and enabling automated, incremental updates.
  • Increased performance of legacy ETL pipeline to 80%

Senior Software Engineer

GlobalLogic
Kyiv, Ukraine
12.2016 - 02.2019
  • During migration to Oracle RDBMS 12.2 for one of company's largest clients, successfully improved performance of over 1,000 problematic queries, meeting client's requirements.
  • Worked with product managers to define software requirements and project scopes accurately.
  • Adapted current software platforms to incorporate new functionality.
  • Identified issues within databases, troubleshooting technical problems and implementing practical solutions.
  • Evaluated, designed and modified databases and database applications to meet business needs.

Software Engineer

Luxoft
Kyiv, Ukraine
11.2014 - 12.2016
  • Optimized main calculation on Database side, resulting in approximately 100,000 executions per second
  • Automated testing of PL/SQL code using Ruby Frameworks
  • Collaborated with other developers to identify and alleviate software bugs.
  • Produced clean, error-free code in line with internal quality standards.
  • Collaborated with cross-functional development teams to raise technical standards for ongoing projects.
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
  • Identified issues within databases, troubleshooting technical problems and implementing practical solutions.
  • Evaluated, designed and modified databases and database applications to meet business needs.

Software Engineer

Epam
Kyiv, Ukraine
11.2013 - 11.2014
  • Working on project of big investment bank, improved performance of investment risk hierarchy validation on 97%
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
  • Wrote queries using SQL to retrieve, build, delete or update information in database.
  • Evaluated, designed and modified databases and database applications to meet business needs.
  • Kept database balanced and performing optimally with regular maintenance.

Education

Master of Science - Information technology

Ukrainian Academy of Customs
Dnipro, Ukraine
06.2006 - 07.2011

Skills

  • Cloud Computing & Data Architecture
  • Data Warehousing & ETL/ELT Optimization
  • Database Modelling & Optimization
  • Performance Tuning & Optimization
  • Snowflake, Oracle Database, MySQL, AWS Redshift, AWS Athena, IBM DB2, PostgreSQL
  • Python, SQL, DBT, PL/SQL, Spark, Fivetran
  • AWS Services (S3, Glue, SNS)
  • Apache Airflow

Languages

English
Advanced
Russian
Fluent
Ukrainian
Fluent

Timeline

Data warehouse architect

Remobi
08.2024 - Current

Senior Data Engineer

Erbis
06.2021 - 10.2024

Senior DWH Engineer

DataMola
02.2019 - 07.2024

Senior Software Engineer

GlobalLogic
12.2016 - 02.2019

Software Engineer

Luxoft
11.2014 - 12.2016

Software Engineer

Epam
11.2013 - 11.2014

Master of Science - Information technology

Ukrainian Academy of Customs
06.2006 - 07.2011

Similar Profiles

Create profile
Andrii Sokolov