Ciklum is looking for a Senior Data Analyst 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 Senior Data Analyst become a part of a cross-functional development team working to cut company’s costs on Big Data processing
Responsibilities: * Optimize BigQuery performance, identify and resolve inefficient queries, and implement best practices for data processing at scale * Analyze SQL code for antipatterns and perform refactoring to improve query execution, cost efficiency, and maintainability * Develop and implement strategies for BigQuery storage optimization, including data partitioning, clustering, and archiving * Collaborate extensively with various data teams to understand their pipelines, identify optimization opportunities, and provide guidance on efficient BigQuery usage * Provide mentorship and support to data engineers, fostering a culture of continuous improvement in data pipeline efficiency and quality * Develop and maintain documentation for BigQuery optimization techniques, best practices, and standard operating procedures * Participate in code reviews, ensuring adherence to BigQuery optimization principles and high-quality SQL code standards * Design, build, and maintain optimisation-related BI dashboards
Requirements: * 5+ years in data analysis or BI—ideally within network security, cloud operations, or a SOC environment * Strong proficiency with SQL (BigQuery dialect), including complex joins, window functions, CTEs, and performance tuning * Comfortable building and maintaining ETL pipelines (Airflow, Bash, Python) * Hands-on with data visualization tools (Tableau, Power BI, Looker, Grafana) * Good understanding of data lake and lakehouse concepts, partitioning and clustering * Familiarity with data catalog/governance platforms (Apache Atlas, DataHub) and Git for schema/version control * Skilled in data profiling, cleansing, and enrichment techniques to ensure high-quality inputs * Strong problem-solving mindset, attention to detail * Good communication skills—able to translate complex data into actionable business insights in English
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 choice * 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.
Explore, empower, engineer with Ciklum!
Interested already? We would love to get to know you! Submit your application. Can’t wait to see you at Ciklum.
