Data Solution Architect With AWSLocation: Santa Clara, CA (on-site)Contract & FTE BothNote: Need candidate who can do hands on.Role Summary: Responsible for leading the discovery, architecture, and data modelling efforts for a scalable, cloud-native data platform. Oversees end-to-end architecture, CDC design, and ensures alignment with enterprise data strategies.• Strong experience with cloud-native data architecture (preferably AWS)• Conceptual, Logical, and Physical Data Modelling• Data Lakehouse architecture and design• Hands-on with ER modelling, normalization, dimensional modelling• Experience with large-scale structured & semi-structured datasets (e.g., JSON)• CDC (Change Data Capture) and Data Lineage frameworks• Data governance and metadata management• AWS (S3, Glue, Redshift, IAM, KMS)• Lucidchart, dbt, ER/Studio, SQL Developer• Git, GitLab and other Dev/DataOps workflows• Architecture diagramming tools (Lucidchart, Draw.