Data / Analytics Engineer

Levin Human Resources Development Limited; Hong Kong Island; 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

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)