About the role
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.
Millions of jobs, with real people getting hired every day
Questions, answered
Click "Apply with JobAssist" – we tailor your resume and application to this role and submit it for your approval.
Yes. This role at Photon was screened before publishing – we confirmed the employer before listing it.
The employer didn't disclose a salary range for this listing. JobAssist shows pay whenever it's available.
This position can be done from anywhere, with no in-office requirement.
Yes – every application is tailored from your profile and this job's requirements, and you can review and edit before it's sent.