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)
#J-18808-Ljbffr
or continue with email
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)
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more
More from Levin Human Resources Development Limited