דלג לתוכן הראשי
איליה דוידוביץ

איליה דוידוביץ

Data Engineer and BI Developer

כישרון
Ramat Ganחבר מאז 15 בנובמבר 2026
SQLPL/SQLMDXEnterprise DWHETL/ELTdata martsOracleSASSnowflakeInformatica PowerCenterOracle Data Integrator (ODI)Oracle Message QueuePower BIOracle BI Publisherdata qualityGit/GitHub
·

גייסו אדם זה

שלחו הצעת עבודה ישירות למועמד זה

SQLPL/SQLMDXEnterprise DWHETL/ELT

אודות

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)

כישורים

Data Engineer and BI Developer

ביקורות

קשור