# Roman Leonovich

Roman Leonovich is a remote worker on Himalayas, Analytics Engineer / Data Engineer at Evercode Lab, based in Georgia.

Source: https://himalayas.app/@romich

```text
I build PostgreSQL data warehouses, reliable ETL pipelines, and analytics layers at tens-of-terabytes scale.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Georgia |
| Authorized to work in | Russian Federation |
| Salary expectations | 70k+ USD |
| Job categories | Data Engineer, Analytics Engineer, Business intelligence Engineer |
| Skills | Analytics Engineering, Data Engineering, Data Warehouse, Data Modeling, Data Marts, Business Intelligence, Business metrics, Self Service Analytics, Ad hoc Analysis, SQL, PostgreSQL, Greenplum, Clickhouse, ETL, ELT, CTEs, Window Functions, Stored Procedures, Functions, Query Optimization, Indexes, Partitioning, Data Quality, Data Completeness Checks, Data Freshness Checks, Source To DWH Reconciliation, Duplicate detection, Gap Detection, Automated Backfills, Discrepancy Investigation, Python, Pandas, NumPy, Psycopg2, MongoDB, requests, Multiprocessing, Airflow, DBT, Spark SQL, Kafka, REST APIs, JSON, XML, Google Analytics, Git, Linux, Liquibase, Cron, Metabase, Jira, Confluence, AI assisted Development, Data Lineage, Production Monitoring, Technical Documentation, Code Review, Mentorship |

## About

```text
At Evercode Lab, I built a corporate PostgreSQL-based DWH from scratch at tens-of-terabytes scale, integrating dozens of sources and hundreds of tables. I design data marts and dedicated databases for BI, operations, engineering, and management reporting.

I build and monitor ETL/ELT pipelines, data-quality checks, and production-ready data processes using SQL, PostgreSQL, Python, Airflow, dbt, Kafka, and Spark. I also optimize large-volume workloads, document systems, review code, and mentor junior specialists.
```

## Experience

### Analytics Engineer / Data Engineer (current)

Evercode Lab. Apr 2023 - Present

```text
Built a corporate PostgreSQL-based DWH from scratch at a scale of tens of TB, integrating dozens of sources and hundreds of tables. Designed analytical data marts and automated recurring reports, significantly reducing turnaround time for complex ad hoc data extracts.
```

Skills: SQL, PostgreSQL, Python, Airflow, DBT, Kafka, Spark, BIツール, Data-Quality, ETL-ELT, Data-Modeling, Query-Optimization, Partitioning, Indexes, CTEs, Window-Functions, Pandas, Psycopg2, MongoDB, requests, Multiprocessing, Spark-SQL, REST-APIs, JSON, XML, Git, Linux, Liquibase, Cron, Metabase, Google-Analytics, Jira, Confluence

### ML Data Collection Specialist

ID R&D. Jul 2022 - Apr 2023

```text
Collected and structured photo, video, and audio datasets for training and testing biometric systems. Controlled data quality and scenario completeness.
```

Skills: Data-Collection, Data-Quality, Biometric-Systems, Dataset-Structuring

## Education

### Saint Petersburg State University

Master's Degree, Computer Science. 2020 - 2023

```text
Master's degree in Computer Science from Saint Petersburg State University, completed in 2023.
```

### Admiral Makarov State University

Bachelor's Degree, Computer Science. 2016 - 2020

```text
Bachelor's degree in Computer Science from Admiral Makarov State University, completed in 2020.
```

## Tech stack

- Metabase
- NumPy
- Pandas
- dbt
- Liquibase
- PostgreSQL
- MongoDB
- Google Analytics
- Jira
- Python
- JSON
- XML
- Kafka
- Linux
- Confluence
- Git
- Airflow
- SQL
- Clickhouse

To contact Roman, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Stanislav Salnikov](https://himalayas.app/@stanislavsalnikov): Senior Data Warehouse Developer, Umbrella IT
- [Катя Шагвалиева](https://himalayas.app/@0003574): Data Analyst, Evercode Lab
- [Григорий Завьялов](https://himalayas.app/@0005407): Data Engineer, Moscow Center for Monitoring and Development of Medical Care
- [Vadim Sharavin](https://himalayas.app/@vadimsharavin): Data Engineer, Alfa Bank
- [Matvey Kazakov](https://himalayas.app/@matveymatmatvey): Data Analyst, Trend LLC
- [Hamza Mahmoud](https://himalayas.app/@hamzamahmoud): Analytics Engineer / BI Developer, GlobalDrive
- [Martin Mirochnik](https://himalayas.app/@martinmirochnik): Senior Data Engineer, Delimobil
- [Эдуард Дунаев](https://himalayas.app/@0007316): Middle Data Analyst, Почтовые технологии
- [Сергей Лазарев](https://himalayas.app/@0007771): Data Engineer, Alfa Bank
- [Andrew Pochestnev](https://himalayas.app/@andrewpochestnev): Middle Data Engineer, Sberbank of Russia
