Data / Analytics Engineer

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)