Senior Data Architect

Data Lead / Associate Data Architect – AWS Data Lake & Lakehouse Migration

Role Overview

We are looking for a

Data Lead / Associate Data Architect

to lead a large-scale

data lake and lakehouse migration

on AWS. The role requires strong hands-on expertise in data architecture, SQL data modeling, migration strategy, and modern lakehouse technologies.

Key Responsibilities

Lead the migration of

2,000+ source tables

into an AWS-based data lake/lakehouse architecture.

Define and validate

source-to-target mappings

, data models, transformation rules, and migration strategy.

Design and implement

Raw, Silver, and Gold data layers

.

Define dimensional models and

SCD Type 2

implementation using SQL.

Design and implement

Iceberg-based lakehouse

structures and data pipelines.

Work with

dbt

for SQL-based transformation, modeling, testing, and documentation.

Build/oversee AWS-based data pipelines and integration with

Trino

for data processing and querying.

Ensure data quality, reconciliation, lineage, performance, and scalability across migration and transformation pipelines.

Provide technical leadership to data engineers and work closely with business/domain stakeholders.

Review architecture and implementation decisions and ensure alignment with enterprise data standards.

Required Skills

Strong experience in

Data Lake / Data Lakehouse architecture

and large-volume data environments.

Hands-on

AWS data architecture

experience.

Strong SQL expertise, including

dimensional modeling and SCD Type 2

.

Practical experience with

dbt

.

Strong understanding of

Apache Iceberg

and lakehouse architecture.

Experience with

Trino

or similar distributed SQL query engines.

Experience in

large-scale data migration

, preferably involving thousands of tables.

Strong understanding of

source-to-target mapping, data modeling, transformation, reconciliation, and data quality

.

Ability to work with

SQL-based transformations rather than Spark-centric development

.

Role Profile

This is primarily a

Data Lead / Associate Data Architect

position. The ideal candidate should be capable of making architecture and design decisions, driving migration workstreams, reviewing technical implementations, and providing technical direction—not merely performing data analysis or individual development tasks.

Preferred Experience

Experience leading enterprise-scale data modernization or migration programs.

Experience designing

Raw → Silver → Gold

lakehouse architectures.

Experience with metadata-driven migration and automated table onboarding.

Experience working with multiple data domains and complex source-to-target mappings.