Vacancy: Data Engineer/Data Migration and Analytics Specialist (ClickHouse, Trino, S3) Grade: Middle+/Senior Company: JETLY Format: remote Location: Russia Citizenship: RF Salary Range: from 220,000 to 310,000 rubles net per month Employment Conditions, Format: Labor Code/Individual Entrepreneur

📌 About the project The key task of the department is to migrate the data storage and processing architecture from Apache Hive and Greenplum to a modern stack: S3 + Trino + ClickHouse. You will participate in the design, implementation, and optimization of the new corporate data warehouse (EDW), ensuring a seamless transfer of business logic and analytical processes.

🔍 Key tasks Design and implement data migration and ETL/ELT processes to the new stack (S3 → Trino/ClickHouse). Develop, optimize, and refactor complex SQL queries for analytics, reporting, and data marts. Integrate data from SAP systems (HCM, ERP) and other corporate sources. Ensure data quality, consistency, and validation after the transition to the new architecture. Participate in the development and support of the corporate data warehouse (EDW) architecture. ✅ Mandatory requirements Advanced SQL level 🔥 (this is a critical requirement: ability to write complex queries, window functions, execution plan optimization, working with terabytes of data). Solid experience with the Hadoop ecosystem: Hive, Spark. Experience in commercial operation or migration of Greenplum (or other MPP DBMS). Knowledge of modern analytical stacks: ClickHouse, Trino, working with S3 storage. Experience in designing and developing EDW (Corporate Data Warehouse). Understanding of data analysis methodologies, building data marts, and metrics. Knowledge of data architecture and business processes in SAP (HCM, ERP modules).

💡 Will be an advantage Proficiency in Python for automation, writing UDFs, and integration scripts. Experience in orchestrating pipelines in Apache Airflow. Experience with ETL tools (including SAS DI). Knowledge of Apache NiFi for data streaming and routing. Experience using Power Designer for DDL modeling and schema design.

Technology Stack SQL (primary), ClickHouse, Trino, Greenplum, S3, Hadoop/Hive, Spark, Apache Airflow, Python, Apache NiFi, SAS DI, Power Designer, SAP (HCM/ERP), EDW.

Please send your resume and questions to Telegram direct message to Geniya_HR 📲