# Ilya D

Ilya D is a remote worker on Himalayas, Data Analyst at G-Stat, based in Russian Federation.

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

```text
Senior Data Engineer building enterprise data warehouses, ETL pipelines, and analytical data marts for banking, insurance, and healthcare.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Russian Federation |
| Authorized to work in | Russian Federation |
| Job categories | Senior Data Engineering, Data Analyst, Data Engineer, Data Warehouse Developer, Business Intelligence Developer, Senior Data Engineer Jobs, Senior Data Engineer Positions, Senior Data Engineering Manager |
| Skills | SQL, Pl SQL, Base SAS, SAS MACRO, Python, DBT, MongoDB, Data Modeling, Data Warehouse, Data Marts, ETL, Data Integration, Snowflake, Oracle Data Integrator, Informatica, Oracle Analytic Publisher, SSAS, SQL Optimization, Oracle Hyperion, VBA, Excel, Message Queues, Git, Jira, Confluence, DBA, SAS |

## What I'm looking for

```text
I’m looking for a role where I can design and optimize enterprise data warehouses and ETL/data integration, improve SQL/PL-SQL performance, and build reliable analytical marts and BI reporting end-to-end.
```

## About

```text
I build and optimize enterprise data warehouses, ETL pipelines, and analytical solutions across banking, insurance, and healthcare, including data marts processing hundreds of millions of records.

At G-STAT, I led SAS-based processes for 8 insurance data marts, collaborated with actuaries to translate requirements into analytical models, and cut processing time by 30% for marts with 100M+ rows. I also maintained Excel/VBA QA dashboards and streamlined data integration between Snowflake and SAS.

Before that, at Renaissance Credit I migrated 10 credit risk data marts from SAS to Oracle (PL/SQL), developed 80+ Oracle PL/SQL procedures and SAS programs, and reduced processing time by 50% for daily refreshes. I also worked on Oracle DWH with PL/SQL and SQL Server, improving database maintainability, performance, and reporting through ODI, SSAS, and Oracle BI.
```

## Experience

### Data Analyst

G-Stat. Aug 2023 - Oct 2025

```text
Built and optimized SAS-based processes for 8 insurance data marts supporting life, pension, and health insurance products. Collaborated with actuarial department to translate business requirements into analytical data models.
```

Skills: SAS, SAS-MACRO, SQL, Excel, VBA, Snowflake, Data-Integration

### Data Engineer

Renaissance Credit. Jan 2020 - Aug 2023

```text
Migrated ETL processes for 10 credit risk data marts from SAS to Oracle PL/SQL. Designed and optimized 80+ Oracle PL/SQL procedures and SAS programs supporting daily and monthly data mart refreshes.
```

Skills: Oracle, Pl-SQL, SAS, ETL, Data-Migration, SQL

### Data Warehouse Developer

Renaissance Insurance. May 2018 - Jan 2020

```text
Maintained enterprise DWH processes on Oracle and SQL Server. Developed 30+ Oracle PL/SQL procedures and 10+ SQL Server stored procedures, improving database maintainability and performance.
```

Skills: Oracle, Pl-SQL, SQL-Server, ODI, SSAS, ETL

### Oracle PL/SQL Developer

Medintegrator. Apr 2016 - Apr 2018

```text
Developed Oracle database solutions supporting healthcare information systems for hospitals. Designed database structures and implemented Oracle Message Queue for real-time patient monitoring data processing.
```

Skills: Oracle, Pl-SQL, SQL, Git, Database-Design, Message-Queues

### Hyperion Consultant

IBS. May 2014 - Apr 2016

```text
Participated in implementation of enterprise budgeting and forecasting solution based on Oracle Hyperion Planning. Implemented 20+ Oracle Planning forms and 50+ business rules supporting enterprise budgeting and forecasting.
```

Skills: Oracle-Hyperion, SQL, OLAP

## Education

### Moscow State University of Railway Transport (MIIT)

Specialist, Automated Systems of Information Processing and Management. 2008 - 2013

```text
Specialist degree in Automated Systems of Information Processing and Management.
```

## Tech stack

- SAS
- dbt
- MongoDB
- Jira
- Oracle PL/SQL
- SQL
- X++

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

## People also viewed

- [Nataliia Chernukhina](https://himalayas.app/@nataliiachernukhina): Python Software Engineer, Lloyds
- [Egor Gerts](https://himalayas.app/@egorgerts): Senior Data Engineer, EPAM Systems
- [Stanislav Salnikov](https://himalayas.app/@stanislavsalnikov): Senior Data Warehouse Developer, Umbrella IT
- [Frank Carrasco Paulino](https://himalayas.app/@frankcarrascopaulino): Senior Data Engineer, Tranzact
- [Валерия Артеева](https://himalayas.app/@0004717): Business Analyst / DWH & ETL Analyst, Prommix LLC
- [Vadim Sharavin](https://himalayas.app/@vadimsharavin): Data Engineer, Alfa Bank
- [Roman Leonovich](https://himalayas.app/@romich): Analytics Engineer / Data Engineer, Evercode Lab
- [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
