
איליה דוידוביץ
Data Engineer and BI Developer
גייסו אדם זה
שלחו הצעת עבודה ישירות למועמד זה
אודות
Data Engineer and BI Developer with 11+ years of experience designing, developing, and optimizing enterprise data warehouses, ETL/ELT pipelines, and BI solutions across banking, insurance, and healthcare. Strong expertise in SQL, PL/SQL, data modeling, and performance optimization, with proven results in accelerating data processing, automating workflows, and delivering reliable data solutions that support business decision-making
ניסיון
Data Engineer at G-STAT (consulting) - client: Menora Mivtachim (2023 – 2025)
- Designed data models and developed automated processes on SAS for actuarial business users
- Re-engineered complex SAS queries, reducing data processing time by approximately 30%
- Developed 2 ETL processes from scratch and supported 4 additional processes, handling tens of millions of records
- Optimized a long-running data process, reducing execution time from one week to 30 minutes
- Integrated Snowflake as a data source for SAS-based ETL, using SQL queries for data extraction
- Validated 20 key metrics across approximately 30 checks following client-requested algorithm updates
Data Engineer, Risk Department at Renaissance Credit - top-50 Russian bank (2020 – 2023)
- Designed data models and database structures for data processing pipelines using Oracle and SAS
- Developed SQL queries, stored procedures and risk data marts using Oracle PL/SQL, SQL Server and SAS, handling hundreds of millions of records
- Migrated data processes from SAS to Oracle, doubling performance (2x) and improving data availability
- Maintained production ETL pipelines using Informatica PowerCenter and optimized SQL using indexing and execution plans
- Translated business requirements into technical designs and improved production deployment scripts
Data Warehouse Developer at Renaissance Insurance - leading Russian insurance company (2018 – 2020)
- Designed data models and database structures across Oracle and SQL Server environment
- Developed and maintained enterprise DWH processes using Oracle PL/SQL and SQL Server
- Built and maintained 4 ETL processes using Oracle Data Integrator (ODI), reducing manual processing time from 2 hours to 30 minutes (75%)
- Enhanced 2 OLAP cubes and BI reports using SSAS and Oracle BI, supporting 40 users
- Developed SQL reports, designed ER diagrams, and translated business requirements into data solutions
Oracle PL/SQL Developer at Medintegrator - Russian medical software company (2016 – 2018)
- Designed Oracle databases and developed structures using PL/SQL for healthcare systems used across 15 hospitals
- Translated business requirements into scalable database models in collaboration with business analysts
- Implemented Oracle Message Queue for real-time patient monitoring data processing
- Used Git for version control and automated deployment
- Enhanced SQL deployment scripts for testing and promoting database changes to production
Hyperion Consultant at IBS - leading Russian system integrator (2014 – 2016)
- Delivered an enterprise budgeting and forecasting solution built on Oracle Hyperion Planning
- Implemented Hyperion Planning forms and rules for budgeting and forecasting
- Maintained OLAP databases and EPMA dimensions; migrated metadata through Shared Services
- Developed Oracle BI Publisher dashboards using MDX and SQL
השכלה
Specialist Degree (5 years) in Automated Systems of Information Processing and Management – Moscow State University of Railway Transport (MIIT), Russia (2008 – 2013)

