Default_best_data_analytics_tools_promo_image_with_saturated_0 (1)

Locations

  • Bulgaria
  • Georgia
  • Lithuania
  • Mexico
  • Moldova
  • Poland
  • Romania
  • Ukraine

Company Background

The customer is a well-established global leader in the food manufacturing industry, committed to delivering innovative data solutions to enhance operational insights across a diverse customer base. With a growing SaaS ecosystem, they are now investing in embedded analytics to support real-time, usage-based reporting directly within their core application.

Project Description

The project is focused on implementing native analytical dashboards within a cloud-based SaaS platform. This includes building scalable and cost-efficient data pipelines, transforming raw transactional data into formats optimized for analytics, and leveraging cutting-edge AWS technologies such as Athena, Glue, and S3 tables. 

Technologies

  • Athena
  • Glue
  • S3 tables
  • AWS

What You'll Do

  • Design and implement in-app analytics and KPI dashboards within a cloud-native SaaS architecture
  • Build and optimize data pipelines to curate data from Oracle/PostgreSQL sources into S3 using AWS DMS and Glue
  • Develop Parquet/Iceberg-based analytical datasets for querying via Athena
  • Optimize queries, catalog structure, and data partitions for performance and cost-effectiveness
  • Build secure, intermediate data layers to support external reporting and customer-facing dashboards
  • Support frontend engineers by integrating data via AppSync and asynchronous query models
  • Conduct architectural reviews and improve the performance of existing analytical queries
  • Document data flows, catalog schema, and operational procedures to support the transition during architect leave
  • Mentor and support upskilling of internal team members working on the analytics stack

Job Requirements

  • 5+ years of experience in data engineering or data analytics
  • Strong hands-on experience with AWS Athena, Glue, and S3 in production environments
  • Proven knowledge of data lake architectures and AWS DMS
  • Experience working with Parquet and/or Apache Iceberg file formats
  • Proficiency in designing and maintaining efficient catalog structures for analytics
  • Strong SQL skills, especially in PostgreSQL; familiarity with Oracle-to-Postgres migration
  • Solid understanding of ETL/ELT workflows, data transformation, and performance optimization
  • Experience working with frontend teams and exposing data to reporting interfaces
  • English level: B1+ (spoken and written)

Nice To Have

  • Experience integrating data with React / AppSync dashboards
  • Familiarity with Apache Iceberg and best practices for large datasets
  • Background working with ERP systems or financial data pipelines
  • Understanding of usage-based cloud cost optimization strategies

What Do We Offer

The global benefits package includes:

  • Technical and non-technical training for professional and personal growth;
  • Internal conferences and meetups to learn from industry experts;
  • Support and mentorship from an experienced employee to help you professional grow and development;
  • Internal startup incubator;
  • Health insurance;
  • English courses;
  • Sports activities to promote a healthy lifestyle;
  • Flexible work options, including remote and hybrid opportunities;
  • Referral program for bringing in new talent;
  • Work anniversary program and additional vacation days.

Didn't find anything suitable?

We're always starting new projects and we'd love to work with you. Please send your CV and we'll get in touch.

We will be glad to see you!

First Name is required. Maximum 50 characters.
Last Name is required. Maximum 50 characters.
Email is required. Please enter a valid email address (e.g. recipient@domaine.org).
Maximum 100 characters. Add the name of our employee (e.g. John Smith)
Maximum 2000 characters.
Please attach file in the allowed format .pdf, .doc(x), .txt, .rtf Please attach file less than 3 Mb
Formats (3 MB): doc, docx, pdf, txt, rtf
Please Add Comment or Attach File.

An error occurred sending your message.
Try again or contact us via webinforequest@coherentsolutions.com.

Thanks for your application!
We will reply soon.

Share vacancy