Back to jobs
New

BI Developer (Food and Beverage Manufacturing)

Moldova

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.

Create a Job Alert

Interested in building your career at Coherent Solutions? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...

Choose the country from the list: Belarus, Ukraine, Bulgaria, Georgia, Lithuania, Romania, Poland, Moldova, Portugal, USA, Mexico, Costa Rica. If there is not in the list - write it.

Select...
Select...

I give my consent to Coherent Solutions to process my submitted personal data pursuant to the Privacy Policy for Job Applicants for the purposes of personnel selection for open positions and understand that due to the international presence of Coherent Solutions my personal data may be transferred to third countries.

Select...

I understand and agree that Coherent Solutions will process my personal data for 3 (three) years for the purpose to notify me about future job openings. I am informed that I can withdraw my consent anytime by submitting a relevant request to privacy@coherentsolutions.com. In such case, Coherent Solutions will stop processing my personal data and will delete me from the candidate’s database.