Data Engineer with 20+ years of experience designing and delivering enterprise data platforms, data warehouses, and ETL/ELT pipelines across banking and technology domains. Experienced with Oracle, SAP BW, IBM Cognos, and modern cloud data engineering stacks. Most recently, focused on Python-based data engineering and identity graph solutions using Neo4j (Cypher, GDS), Airbyte, Kafka, BigQuery, dbt, and automation with GitHub Actions. Enjoys building scalable, reliable data models and transforming complex data into actionable analytics.

Konstantin Lofichenko

Data Engineer with 20+ years of experience designing and delivering enterprise data platforms, data warehouses, and ETL/ELT pipelines across banking and technology domains. Experienced with Oracle, SAP BW, IBM Cognos, and modern cloud data engineering stacks. Most recently, focused on Python-based data engineering and identity graph solutions using Neo4j (Cypher, GDS), Airbyte, Kafka, BigQuery, dbt, and automation with GitHub Actions. Enjoys building scalable, reliable data models and transforming complex data into actionable analytics.

Available to hire

Data Engineer with 20+ years of experience designing and delivering enterprise data platforms, data warehouses, and ETL/ELT pipelines across banking and technology domains. Experienced with Oracle, SAP BW, IBM Cognos, and modern cloud data engineering stacks.

Most recently, focused on Python-based data engineering and identity graph solutions using Neo4j (Cypher, GDS), Airbyte, Kafka, BigQuery, dbt, and automation with GitHub Actions. Enjoys building scalable, reliable data models and transforming complex data into actionable analytics.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
See more

Language

English
Advanced

Work Experience

Data Engineer at Marketing Technology Company
October 1, 2022 - June 1, 2026
Designed, developed, and maintained scalable data pipelines for an Identity Graph platform supporting customer identity resolution and customer intelligence/community detection. Built and optimized a Neo4j graph data model to represent complex identity relationships at scale, and developed Cypher queries and graph traversals to improve performance and analytical capabilities. Implemented graph analytics using Neo4j Graph Data Science (GDS) for identity matching and relationship analysis. Optimized large-scale graph import processes using APOC procedures. Created ETL/ELT workflows using Airbyte, Python, and SQL to ingest, validate, transform, and enrich data from multiple sources. Automated pipeline execution/deployment with GitHub Actions; built REST API integrations with third-party and internal services. Developed Metabase dashboards for operational and business analytics. Worked with AWS, Google Cloud Platform, BigQuery, Kafka, and dbt in a remote Agile environment to improve data q
Team Lead (Data & Reporting) at BKC Group
September 1, 2019 - September 1, 2022
Led a team of 5 developers delivering financial calculation and reporting solutions. Managed project planning and task allocation to ensure on-time delivery. Designed and implemented ETL processes to extract and load financial data from multiple source systems. Developed data transformation logic using Microsoft SQL Server and stored procedures to support business reporting and financial calculations. Partnered with stakeholders to clarify requirements and ensure reliable reporting. Monitored data quality and optimized SQL-based processing to improve performance and accuracy.
SAP BI Analyst at Promsvyazbank
January 1, 2011 - August 1, 2019
Designed and implemented enterprise Data Warehouse solutions on SAP BW. Developed data models for retail and corporate banking domains (loans, deposits, savings accounts, repos, treasury). Defined ETL rules for extracting, transforming, and loading data from multiple banking systems. Worked with business users to ensure data quality and reporting accuracy. Developed SAP BEx reports and analytical dashboards. Designed and implemented Funds Transfer Pricing (FTP) calculations for Treasury. Built ALM data marts and reporting solutions for financial risk management.
Risk Management Analyst at Kamakura Risk Management
May 1, 2008 - December 1, 2010
Participated in the implementation of Kamakura Risk Management for enterprise risk analysis. Gathered requirements and prepared Business Requirement Documents (BRDs) for market risk, credit rating, and provisioning processes. Designed ETL workflows to load data from banking systems into the risk platform. Extended the application database schema to support custom reporting. Developed analytical reports and business models using IBM Cognos. Coordinated with the software vendor to resolve implementation and integration issues.
DWH / BI Analyst at Raiffeisen Bank Russia
August 1, 2006 - April 1, 2008
Participated in implementation of an enterprise Data Warehouse based on Oracle dimensional modeling. Performed source system analysis and data mapping across core banking, retail, card processing, lending, deposits, and payment systems. Designed ETL mapping specifications for IBM DataStage development. Conducted data quality analysis and validation throughout the ETL lifecycle. Designed business models for Cognos reporting and worked with stakeholders to define reporting requirements. Collaborated with international teams in Vienna during delivery.
Senior Oracle Developer at Luxoft
November 1, 2005 - July 1, 2006
Developed Oracle PL/SQL solutions for a CRM implementation project for Deutsche Bank. Designed and implemented database objects including tables, views, packages, procedures, triggers, and indexes. Built ETL processes to import data from external systems using SQL*Loader and custom PL/SQL. Produced functional and technical specifications for database components. Collaborated with Deutsche Bank IT teams to troubleshoot issues and ensure successful data integration.

Education

Engineer’s Degree, Elektromekhanicheskie tekhnologii / elektromekhanika at Moscow State Technological University "Stankin"
January 1, 1983 - January 1, 1989
Master's degree, Computer Science at Kennedy Western University
January 1, 1999 - January 1, 2001
Engineer’s Degree, Электромеханические технологии/электромеханика at Moscow State Technological University "Stankin"
January 1, 1983 - January 1, 1989
Master's degree, Computer Science at Kennedy Western University
January 1, 1999 - January 1, 2001

Qualifications

Microsoft Certified Systems Engineer
January 11, 2030 - August 24, 2026
Oracle Certified Professional
January 11, 2030 - August 24, 2026
Microsoft Certified Systems Engineer
January 11, 2030 - August 24, 2026
Oracle Certified Professional
January 11, 2030 - August 24, 2026

Industry Experience

Financial Services, Software & Internet, Professional Services