Remote Data Engineer

Description:

• Join a web communication platform that connects users globally, established in 2020.
• The platform offers 24/7 communication and content sharing without ads, focusing on user experience and monetization.
• Contribute to the development of a new Data Lakehouse platform using the latest technologies in the GCP ecosystem.
• Take ownership of migrating data from ClickHouse to BigQuery, ensuring data integrity, accuracy, and performance.
• Design a scalable BigQuery architecture for analytical and operational workloads.
• Develop and maintain automated ETL/ELT pipelines using tools like Cloud Composer and DataForm.
• Build aggregated datasets and data marts for analytics, reporting, and dashboards.
• Implement automated data quality checks and monitoring to ensure reliability.
• Monitor and optimize production data infrastructure for performance and cost management.

Requirements:

• A minimum of 5 years of experience as a Data Engineer in a large-scale data environment.
• Strong skills in data modeling and data warehouse methodologies.
• Experience in designing and developing ETL workflows; familiarity with DBT is a plus.
• Proficient in writing complex, optimized SQL queries.
• Confident in using Python, particularly with Spark.
• Experience in distributed computing environments.
• Deep knowledge of BigQuery, including its partitioning, clustering, and cost optimization features.
• Familiarity with ClickHouse architecture, SQL dialect, and migration processes.
• Hands-on experience with GCP services such as Cloud Storage, Pub/Sub, Cloud Run, Cloud Composer, Cloud Functions, and Compute Engine.
• Strong skills in dimensional modeling and data mart design.
• Familiarity with Git and CI/CD practices for data workflows.
• Experience in monitoring, alerting, and validating production data pipelines.
• Ability to manage GCP costs effectively.
• Proven track record in large-scale system migrations.
• An ownership mindset with a proactive and results-oriented approach.
• Experience integrating with BI tools like Tableau or Looker is a plus.

Benefits:

• Enjoy 20 paid vacation days, 15 sick days, and 6 additional days off for family events.
• Receive up to 10 additional days off for public holidays.
• Benefit from 100% medical insurance coverage.
• Get reimbursement for sports and equipment expenses.
• Participate in team-building events, receive corporate gifts, and stylish merchandise.
• Access financial and legal support.
• Retain your position and receive support if you join the Armed Forces of Ukraine.
• Engage in social initiatives that support Ukraine.
• Work from the Kyiv hub or remotely with a flexible schedule.
• Receive workspace rental reimbursement in other cities and abroad.
• Use modern equipment or receive depreciation for your own tools.
• Collaborate with a highly-skilled team of Middle & Senior professionals in the social networking niche.
• Benefit from performance-oriented reviews and Individual Development Plans (IDPs).
• Get reimbursement for professional courses and English classes.
• Access a corporate library, participate in a book club, and attend knowledge-sharing events.