Data / Analytics Engineer

About the role

A Data / Analytics Engineer role supporting the project of BigQuery Datalake. You will be building a centralized BigQuery database to consolidate operational data from several internal systems, including PLM, Capacity Planning, Shipping, Packing, and Inventory. You will work closely with the AI Scientist who is building the chatbot backend to ensure the schemas, metadata, and tables are structured to support both standard reporting and LLM-based retrieval.

Key responsibilities

• Design and implement relational database schemas (e.g., Star Schema, OBT) that accurately represent operational workflows
• Define clear semantic layers and maintain rich metadata to ensure the data is easily navigable by business analysts and the chatbot
• Write SQL and Python to build and automate reliable ETL/ELT ingestion pipelines from operational APIs and files
• Implement data validation and reconciliation checks to ensure data consistency and accuracy across downstream reports and the chatbot

About you

• Solid experience with Google BigQuery: schema design, partitioning, clustering, cost optimization, and writing clean SQL for analytical transformations
• Experience using Google Cloud Storage (GCS) as a landing zone for raw operational data
• Strong proficiency in SQL and Python for scripting and data manipulation
• Minimum 3-5 years work experience
• Bachelor of Science in Computer Engineering
• Experience with Dataform to manage and develop SQL workflows within BigQuery (nice-to-have)
• Experience with Google Cloud Functions, Cloud Run, or Pub/Sub for API data ingestion (nice-to-have)