Lead Data Engineer / Data Platform Architect
Denis Lomakov
Helping companies design and build scalable data platforms with Spark, ClickHouse, Airflow, PostgreSQL and Superset.
About
I'm a Lead Data Engineer with 7+ years in data engineering, focused on building scalable data platforms, data warehouses, and analytical systems for fintech, banking, and growing businesses.
Expertise
From ingestion and modeling to reliable analytical products
Data Platforms
Spark, Hive, Airflow, dbt, Hadoop, PostgreSQL, ClickHouse, HDFS, Apache Ozone, Superset.
Ingestion
Airbyte, Kafka, NiFi, API integrations, batch and streaming ingestion patterns, source system mapping.
Modeling
Star and snowflake schema, 3NF, Data Vault, SCD2/SCD4, Raw / Core / Mart layers and medallion architecture.
Governance
Data quality, data lineage and maintenance, security.
Optimization
Spark performance, ETL redesign, cost/performance tuning, pipeline reliability.
Consulting
DWH from scratch, BI migration, open-source data platform design.
Selected projects
Case studies across banking, fintech and growing businesses
Major bank
Migration BI system in BigTech
BI system migrated from Qlik Sense to ClickHouse and Superset, improving platform openness and long-term maintainability.
Major bank
Migration data platform: Teradata to Greenplum
Transfer of 4 TB of data between analytical platforms with focus on reliability, validation and business continuity.
Performance
Pipeline optimization - 8h to 4h
Critical regulatory reporting pipeline redesigned and optimized for reliability and faster delivery.
Fintech
Near-real-time reporting platform
Non-bank credit organization: 100 employees, 7 sources, 1-2 hour data freshness and 15 regular reports.
EdTech
Talk Academy analytics platform
20 teachers, 200+ students, finance dashboards, LTV analytics and student performance tracking.
Articles / GitHub / Talks
Notes, blueprints and engineering ideas
Contact
Let's discuss your data platform
I can help with data platform architecture, DWH implementation, BI migration, performance optimization and data engineering consulting.