Data Architect strong Retail and AWS

Data Architect

Location:

Plano, TX (Hybrid) (once in a 2 week or occasional basis)

Job Description:

Own the data layer of a multi-tenant ecommerce platform running commercially competing retail brands on shared infrastructure. The core challenge is designing data isolation across brands sharing the same platform while meeting PCI-DSS and GDPR compliance requirements for cardholder data and customer PII.

What You'll Do:

• Design and enforce the canonical domain model (Product, Order, Customer, Cart, Inventory, Price, Payment) that all brands conform to
• Design the data pipelines connecting enterprise systems (ERP, OMS, Inventory, CRM, Pricing, payments) to the platform
• Design the data infrastructure to support future AI/ML workloads — tenant-partitioned feature stores, clickstream capture, entity resolution, data lineage, and PII governance
• Lead brand migration. Facilitate workshops with brand teams and upstream system owners to map existing data to the canonical model, identify gaps, and agree the migration path & data migration automation
• Present data architecture decisions as formal ADRs to the Architecture Review Board
• Partner with the Platform Architecture Lead as the data domain expert — drive the data workstream independently

Tech Stack:

AWS, AWS (RDS PostgreSQL, Elasti Cache, S3, Event Bridge, Glue, DMS), Datastax Astra, Neptune, Sage Maker Feature Store, EMR, Snowflake

What You Bring:

• Multi-tenant data isolation at scale
• Event-driven architecture and change data capture pipeline engineering
• Ecommerce domain modeling across order management, inventory, and pricing
• Snowflake or equivalent data warehouse/lakehouse technologies. Schema design, partitioning strategies, and query optimization
• PCI-DSS and GDPR data compliance. Classification, encryption, access controls, and audit trails for cardholder data and customer PII
• Java and Python proficiency
• AI/ML foundational knowledge.