Data Engineer (Food and Beverage Manufacturing)
Locations
- Bulgaria
- Georgia
- Lithuania
- Mexico
- Moldova
- Poland
- 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
GlueS3 tablesAWSWhat You\'ll Do
Design and implement in-app analytics and KPI dashboards within a cloud-native SaaS architectureBuild and optimize data pipelines to curate data from Oracle / PostgreSQL sources into S3 using AWS DMS and GlueDevelop Parquet / Iceberg-based analytical datasets for querying via AthenaOptimize queries, catalog structure, and data partitions for performance and cost-effectivenessBuild secure, intermediate data layers to support external reporting and customer-facing dashboardsSupport frontend engineers by integrating data via AppSync and asynchronous query modelsConduct architectural reviews and improve the performance of existing analytical queriesDocument data flows, catalog schema, and operational procedures to support the transition during architect leaveMentor and support upskilling of internal team members working on the analytics stackJob Requirements
5+ years of experience in data engineering or data analyticsStrong hands-on experience with AWS Athena, Glue, and S3 in production environmentsProven knowledge of data lake architectures and AWS DMSExperience working with Parquet and / or Apache Iceberg file formatsProficiency in designing and maintaining efficient catalog structures for analyticsStrong SQL skills, especially in PostgreSQL; familiarity with Oracle-to-Postgres migrationSolid understanding of ETL / ELT workflows, data transformation, and performance optimizationExperience working with frontend teams and exposing data to reporting interfacesEnglish level : B1+ (spoken and written)Nice To Have
Experience integrating data with React / AppSync dashboardsFamiliarity with Apache Iceberg and best practices for large datasetsBackground working with ERP systems or financial data pipelinesUnderstanding of usage-based cloud cost optimization strategiesWhat 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;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.Share vacancy
We will be glad to see you!
First Name
Last Name
Email
Referral Add the name of our employee (e.g. John Smith)
Comments
Attach file
Attach file Formats (3 MB) : doc, docx, pdf, txt, rtf
I have acknowledged and agree that Coherent Solutions will process my submitted personal data pursuant toPrivacy Policy for Job Applicants and understand that due to international presence of Coherent Solutions my personal data may be transferred to third countries. I also give consent to Coherent Solutions to 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 request toprivacy@coherentsolutions.com. In such case my personal data will be deleted from a candidates database.
J-18808-Ljbffr