AI Data Architect
Innovative Solutions, Reports into Rochester, NY
About the job
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)
