Data Architect

As a Data/AI Architect, you'll design and build data-driven cloud architectures on AWS — from S3 data lakes and Glue ETL pipelines to data warehouses and RAG-powered AI systems. You'll own the full data stack across a variety of industries and projects: one engagement you're designing a Redshift data warehouse with medallion architecture processing 31M transactions/month, the next you're building a Bedrock Knowledge Base with OpenSearch vector search. Real ownership, real variety. Location: This can be a remote opportunity, with 2 weeks of travel into Rochester, NY per quarter What You'll Do: Design and build S3 data lakes with multi-zone organization, partitioning strategies, lifecycle policies, and encryption Implement medallion architecture (bronze/silver/gold) for data warehouses on Redshift, Snowflake, or Databricks Build AWS Glue ETL pipelines (Python Shell and Spark) with incremental extraction, Data Catalog management, and optimized Parquet output Design star/snowflake schemas, materialized views, and gold-layer models optimized for BI consumption (QuickSight, PowerBI) Configure data warehouse platforms — Redshift with Zero-ETL from Aurora, Snowflake with Snowpipe, Databricks with Delta Lake and Auto Loader Design RAG systems using Bedrock Knowledge Base with OpenSearch Serverless vector search and Titan Embeddings Architect document AI pipelines using Textract, Comprehend, and Bedrock for entity extraction Design SageMaker ML pipelines for training, Model Registry, a