Maksym Pavlov Email & Phone Number

Czechia

As a Technical Engineering Manager, I lead the development and modernization of data warehouse (DWH) systems, ensuring they are scalable, reliable, and efficient in supporting growing business needs. I drive key initiatives, such as the migration from ClickHouse to Snowflake, and design robust application architectures to support complex data operations like data ingestion, data pipelines, and moreI also define strategies for data modeling and system architecture, while managing multiple teams, which includes hiring, mentoring, and providing technical leadership to ensure project success. In addition, I focus on cost optimization and process improvements, such as optimizing CI/CD pipelines, enhancing SRE practices, and maximizing the use of GKEI regularly collaborate with senior leadership, evaluate new technologies, and recommend innovations for data-related initiatives. I also work with auditors and consultants to ensure data accuracy, compliance, and the successful delivery of analytics projects. My focus is on fostering knowledge sharing and promoting best practices across the organization

Одесса, Одесская Область, Украина

I was responsible for designing and building a DWH architecture based on ClickHouse, managing over 500TB of compressed data and handling more than 250 million queries per month. My core responsibilities included data ingestion, modeling, security, availability, archiving, deletion, and implementing CDC ingest from multiple sourcesI configured a data catalog using Alation and established data lineage. Additionally, I managed infrastructure setup, ensured SLA compliance, and monitored metricsTo enhance system performance, I optimized and configured Airflow, writing DAGs and custom operators while managing alerting systems. I also implemented a sensitive data warehouse and collaborated with data stewards to define policies for archiving, deletion, naming, and moreAs both a developer and architect, I contributed to various data-related subprojects, including notifications, validation, and data quality. I designed a Product Master Data Management system using Golang and introduced unit and integration testing into several internal projects. Collaboration with stakeholders and cross-functional teams was key to achieving our objectivesMoreover, I optimized DWH queries, monitored their performance, and provided training for staff. I integrated external data via S3 and HTTP APIs, optimized CI/CD pipelines, and contributed to building the backlog while providing technical leadership to the teams

Odesa, Odessa, Ukraine

In this position, I designed a data warehouse capable of ingesting a high volume of click-stream events, handling over 10 billion events per day using ClickHouse, MongoDB, and Redis. I organized data pipelines, optimized query performance, and managed data storage. Additionally, I developed an internal reporting system that ensured high data availability across various dimensions and time periods. This included data analytics, newsletters, alerts, and moreI also implemented and designed various data grabbers, including those for extracting data and statistics from emails, APIs, and other sourcesI was responsible for developing various internal and external subprojects using a service-oriented architectureAs a team manager, I oversaw the technical backlog and coordinated the team’s activities

Odesa, Odessa, Ukraine

Worked on projects for Live Nation and TicketmasterConducted code reviews to ensure code quality and adherence to best practicesFacilitated cross-team collaboration to achieve project objectivesLed the team and managed communication with stakeholders

Odesa, Odessa, Ukraine

B2B marketplace for multimedia content and license rightsResponsible for building an internal cloud systemManaged a team to achieve project goalsDeveloped internal systems using PHP

Odesa, Odessa, Ukraine

Development and maintenance of an internal billing system/personal account systemImplementation of low-level network monitoring using C/C++Development of data aggregation systems to collect information from AIS vessel tracking data Creation of internal projects using C#