DWH Programmer at SM Lab

SM Lab is looking for a DWH programmer to develop a Data Integration Hub platform. Remote, flexible hours, benefits.

The team develops a Data Integration Hub platform that collects data from production systems, stores historical data, transforms it, and delivers it to consumers. It helps isolate production systems from massive asynchronous queries and organize incremental data uploads. Responsibilities: - Develop and enhance data loading mechanisms from sources (CDC, S3, REST, Oracle) - Design and maintain staging-layer storage structures in Oracle (partitioning, compression, indexes) - Implement logic for extraction of increments and formation of init/delta uploads for consumers - Maintain data transfer contracts: manage source schema changes through platform transformations - Configure Kafka Connect connectors - Optimize performance: heavy queries, PL/SQL, parallelism, working with large volumes - Participate in architecture design: new sources, new consumers, scaling, standardization

Required: - Knowledge of SQL/PL/SQL, preferably experience with Oracle SQL 19c/12c - Experience with Python - Experience with relational databases, preferably Oracle 19c/12c - Ability to read ER diagrams Nice to have: - Knowledge of Business Intelligence technologies - Commercial experience in web application development (JavaScript, HTML5) - Experience with Kafka message brokers - Experience with Apache Airflow - Experience developing with AI agents - Database design skills, including data warehouses

Work format to choose: office/hybrid/remote - Flexible schedule (8-17, 9-18, or 10-19) - Participation in benefits cafeteria project (medical insurance, sports, mobile communication, training) - Semi-annual bonuses - Corporate discounts up to 30% on Sportmaster, Ostin, Funday, Demix products - Internal and external training, conferences - BestBenefits – personalized discounts and privileges service - Equipment provided