AWS Lakehouse Migration Lead | Data Architect

Photon; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Photon is seeking a Data Lead / Associate Data Architect to lead a large-scale AWS data lake and lakehouse migration. The role requires hands-on data architecture, SQL data modelling, migration strategy and modern lakehouse technologies.

You will define source-to-target mappings, design Raw/Silver/Gold layers, implement Iceberg-based lakehouse structures, and oversee dbt transformations. You will collaborate with data engineers and stakeholders to ensure data quality and scalable pipelines.

Qualifications

• Experience in data lake / lakehouse migrations and large-volume data environments.
• Familiar with metadata-driven migration and automated onboarding is a plus.
• Strong SQL, data modelling, transformation, reconciliation and data quality understanding.
• Ability to design and implement Raw, Silver and Gold data layers.

Responsibilities

• Lead migration of 2,000+ source tables into an AWS data lake/lakehouse architecture.
• Define and validate source-to-target mappings, data models and migration strategy.
• Design and implement Raw, Silver, and Gold data layers.
• Define dimensional models and SCD Type 2 implementations using SQL.
• Design and implement Iceberg-based lakehouse structures and data pipelines.
• Work with dbt for SQL-based transformations, modelling, testing, and documentation.
• Build/oversee AWS-based data pipelines and integration with Trino for processing and querying.
• Ensure data quality, reconciliation, lineage, performance, and scalability across pipelines.
• Provide technical leadership to data engineers and collaborate with stakeholders.
• Review architecture and alignment with enterprise data standards.

Skills

Data Lake / Lakehouse

dbt

Apache Iceberg

Trino

Large-scale migration

Source-to-target mapping

Tools

dbt

Trino

Apache Iceberg

Job description

Photon is seeking a Data Lead / Associate Data Architect to lead a large-scale AWS data lake and lakehouse migration. The role requires hands-on data architecture, SQL data modelling, migration strategy and modern lakehouse technologies.

You will define source-to-target mappings, design Raw/Silver/Gold layers, implement Iceberg-based lakehouse structures, and oversee dbt transformations. You will collaborate with data engineers and stakeholders to ensure data quality and scalable pipelines.