Ciklum is looking for a Expert Data Engineer (BigQuery) to join our team full-time in Ukraine.
We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.
About the role:
As a Expert Data Engineer (BigQuery), become a part of a cross-functional development team engineering experiences of tomorrow.
With almost 100 million active users across 25 countries, they’re a global food tech company. As a recently formed team, they have many opportunities and ideas for sharing value back to the customers within their continuously expanding platform. They're looking for talented and trusted engineers to help them impress their customers. As a Data Engineer you will participate in optimization of production DAGs to reduce GCP BigQuery costs.
Responsibilities: * Design, write, and optimize complex SQL queries in the BigQuery dialect, ensuring performance efficiency and scalability across large datasets * Identify and remediate SQL anti-patterns, including but not limited to inefficient partitioning, suboptimal joins, and excessive resource consumption * Develop and maintain scalable data models aligned with business needs, ensuring efficient data storage and query performance * Monitor and optimize BigQuery performance, leveraging best practices such as clustering, partitioning, materialized views, and query caching * Build and orchestrate large-scale data pipelines using Apache Airflow, ensuring reliability, maintainability, and transparency in data workflows * Collaborate with cross-functional teams to identify opportunities for performance improvement, proactively suggesting query and architecture optimizations * Continuously evaluate and enhance GCP-based data solutions, applying a strong understanding of cloud-native tools and services * Contribute to data quality and integrity, establishing validations, monitoring, and alerting systems where appropriate * Document technical solutions and best practices, enabling knowledge sharing and operational continuity across teams
Requirements: We know that sometimes, you can’t tick every box. We would still love to hear from you if you think you’re a good fit! * Advanced proficiency in SQL, particularly BigQuery dialect, with the ability to identify and resolve anti-patterns (e.g., partitioning issues, inefficient queries) * Strong understanding of data modeling, BigQuery performance optimization techniques, and familiarity with large-scale data pipelines * Experience with Apache Airflow and GCP environments is preferred. Ability to suggest optimization strategies and spot incidental improvements beyond anti-patterns * Experience coding in, Java, Python, Scala, with solid CS fundamentals including data structure and algorithm design * Experience in cloud data platforms ( GCP) * Knowledge of professional software engineering best practices for the full software * Knowledge of Data Warehousing, design, implementation and optimization * Knowledge of Data Quality testing, automation and results visualization * Knowledge of BI reports and dashboards design and implementation (PowerBI, Tableau) * Knowledge of development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations * Experience participating in an Agile software development team, e.g. SCRUM * Experience designing, documenting, and defending designs for key components in large distributed computing systems * A consistent track record of delivering exceptionally high-quality software on large, complex, cross-functional projects * Demonstrated ability to learn new technologies quickly and independently * Ability to handle multiple competing priorities in a fast-paced environment * Undergraduate degree in Computer Science or Engineering from a top CS program required. Masters preferred * Experience with supporting data scientists and complex statistical use cases
What’s in it for you? * Strong community: Work alongside top professionals in a friendly, open-door environment * Growth focus: Take on large-scale projects with a global impact and expand your expertise * Tailored learning: Boost your skills with internal events (meetups, conferences, workshops), Udemy access, language courses, and company-paid certifications * Endless opportunities: Explore diverse domains through internal mobility, finding the best fit to gain hands-on experience with cutting-edge technologies * Flexibility: Enjoy radical flexibility — work remotely or from an office, your choic * Care: We’ve got you covered with company-paid medical insurance, mental health support, and financial & legal consultations
About us:
At Ciklum, we are always exploring innovations, empowering each other to achieve more, and engineering solutions that matter. With us, you’ll work with cutting-edge technologies, contribute to impactful projects, and be part of a One Team culture that values collaboration and progress.
As one of Ukraine’s largest IT companies and a top employer recognized by Forbes, we’ve spent over 20 years delivering meaningful tech solutions. We proudly support diverse talent and military veterans, recognizing their unique skills and perspectives they bring to shaping the future.
Want to learn more about us? Follow us on Instagram, Facebook, LinkedIn.
