BigQuery Data & Analytics Engineer - Data Lake & AI-Ready

Levin Human Resources Development Limited; Hong Kong; On-site; HKD 480,000 - 720,000; Full time

Job summary

Levin Human Resources Development Limited is seeking a Data/Analytics Engineer to build a centralized BigQuery Datalake and consolidate operational data from PLM, Capacity Planning, Shipping, Packing and Inventory. You will design relational schemas, define semantic layers, and maintain metadata to support standard reporting and LLM-based retrieval.

Working with the AI Scientist, you will implement ETL/ELT pipelines using SQL and Python, validate data, and optimize costs.

Qualifications

• 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)

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

Skills

BigQuery

Schema design

Partitioning

Clustering

Cost optimization

SQL

Python

Education

Bachelor of Science in Computer Engineering

Tools

Dataform

Google Cloud Functions

Cloud Run

Pub/Sub

Google Cloud Storage

Job description

Levin Human Resources Development Limited is seeking a Data/Analytics Engineer to build a centralized BigQuery Datalake and consolidate operational data from PLM, Capacity Planning, Shipping, Packing and Inventory. You will design relational schemas, define semantic layers, and maintain metadata to support standard reporting and LLM-based retrieval.

Working with the AI Scientist, you will implement ETL/ELT pipelines using SQL and Python, validate data, and optimize costs.