Looking for a job

John Lee

@johnlee8

I design scalable customer data architectures and Adobe Experience Platform solutions.

At Amazon Web Services, I lead enterprise data architecture engagements that modernize data platforms and digital marketing capabilities.

I turn business processes and customer requirements into Adobe Experience Platform and Real-Time CDP blueprints for unified profiles, identity resolution, segmentation, journey orchestration, and campaign activation.

I've designed conceptual through physical data models across OLTP, OLAP, warehouse, lake, relational, columnar, document, and semantic-layer architectures. I also guide batch and streaming ingestion, ETL and ELT, migration planning, validation, and governance controls.

My earlier work at Amazon, the University of Illinois, and ZS Associates built my foundation in SQL, Python, Bash, research data systems, technical communication, and database-backed software solutions.

Experience

Work history, roles, and key accomplishments

Current

Data Architect

Current

Amazon Web Services

Mar 2018 - Present (8 years 7 months)

Lead enterprise data architecture consulting engagements for customers modernizing data platforms and digital marketing capabilities. Designed data models, architected Adobe Experience Platform solutions, and established data governance standards.

Data Engineering Intern

Amazon

Jun 2017 - Aug 2017 (2 months)

Supported data-oriented product and design initiatives within a large-scale technology environment. Developed SQL queries and data transformations, prototyped data workflows, and created technical documentation.

SQL data transformation Data Analysis Technical Documentation Prototyping

Research Data Architect

University of Illinois

Aug 2014 - Jun 2017 (2 years 10 months)

Conducted doctoral research involving data-intensive software systems, analytical modeling, and technical communication. Designed research data models and built Python-based research tooling.

Data Modeling SQL Python Statistical Analysis Data Lineage Technical Communication

Graduate Research Assistant

University of Illinois

Sep 2012 - Jun 2017 (4 years 9 months)

Supported research and instructional activities in computer science and data-intensive systems. Implemented software components and data-processing scripts using Python, SQL, and Bash.

Python SQL BASH Database Schemas data transformation Validation Collaboration

Software Developer

ZS Associates

May 2010 - May 2012 (2 years)

Developed software and data solutions for consulting and business-analysis engagements. Built database-backed applications and SQL queries supporting business analysis and reporting.

SQL Database Development data transformation Validation Integration Requirements Gathering