Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

AI Data Architect

$150k - $190k

Innovative Solutions Inc

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. 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, and inference Lead data discovery sessions with client stakeholders and present architecture recommendations to technical and business audiences Mentor delivery team members on data architecture patterns and AWS data services Contribute to R&D projects evaluating emerging AWS data and AI capabilities Required Skills 5+ years professional IT experience, 2+ years professional AWS experience At least one AWS Professional-level certification (Solutions Architect Professional or Data Engineer Specialty preferred) Python for data pipelines (Glue jobs, Lambda, SageMaker scripts) and PySpark for Glue Spark jobs SQL and NoSQL on AWS — Aurora PostgreSQL, RDS PostgreSQL, DocumentDB, DynamoDB — including schema design and query optimization Data modeling — conceptual, logical, and physical models for AWS data platforms; normalized silver-layer schemas, denormalized star/snowflake gold-layer schemas, data dictionaries Dimensional modeling and medallion architecture (bronze/silver/gold) on Redshift, Snowflake, or Databricks, including materialized views and incremental refresh patterns AWS Glue ETL (Python Shell and Spark), Glue Data Catalog, and crawlers S3 data lake architecture with partitioning, lifecycle policies, and encryption Preferred RAG systems with Bedrock Knowledge Base and OpenSearch Serverless vector search Amazon SageMaker for ML training, Model Registry, and inference AWS HealthLake, FHIR R4 transformation, and HIPAA‑compliant data pipelines Document AI with Amazon Textract and Comprehend Amazon Athena, QuickSight, or PowerBI integration Terraform or CloudFormation for data infrastructure as code Step Functions, EventBridge, and Lambda for event‑driven pipeline orchestration $150,000 - $190,000 a year #J-18808-Ljbffr

Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the AI Data Architect in Rochester, NY vacancy
  •  ...experimentation, to final implementation. About the Team: The Logistics AI group is responsible for the intelligence and execution behind...  ...problems executing on a high throughput system with dynamic data. About the Job: Design, develop, and deploy machine... 
    Suggested
    Permanent employment
    Full time
    Work at office
    Remote work
    Work from home
    Flexible hours

    Instacart

    Rochester, NY
    3 days ago
  • $107.66k - $161.7k

     ...with one place to chat, explore and build with a wide variety of AI language models (bots), including o3, o4-mini, Claude 3.7 Sonnet,...  ...to-end ownership of Machine Learning systems -- from prototyping, data pipelines and training, to realtime LLM application at scale... 
    Suggested
    Remote job
    Full time
    Work experience placement
    Internship

    Quora

    Rochester, NY
    3 days ago
  •  ...Title: Data Architect with Pharma (Life Science) Industry Location: New York or New Jersey - Remote - ONLY LOCAL's Duration: 5 months+ Summary: We are seeking an experienced Contractor to provide subject matter expertise .Key Responsibilitie s:Bachelor’s or master’s degree... 
    Suggested
    For contractors
    Local area
    Remote work

    Charter Global

    Rochester, NY
    2 days ago
  •  ..., and fulfillment. We use machine learning and Internet-scale data to elevate customer experience, improve efficiency, and reduce cost...  ...experience. (Recent publications 1, 2, 3, 4, 5). Content AI Team : The Content AI team at Instacart works alongside world-class... 
    Suggested
    Remote job
    Permanent employment
    Work experience placement
    Internship
    Work at office
    Work from home
    Flexible hours

    Instacart

    Rochester, NY
    1 day ago
  • $125.5k - $230.2k

     ...working world. The opportunity Our Artificial Intelligence and Data team helps apply cutting-edge technology and techniques to bring...  ...operations. Your key responsibilities As a Manager in AI Native Engineering, you will play a pivotal role in delivering... 
    Suggested
    Full time
    Work experience placement
    Summer holiday
    Flexible hours

    EY

    Rochester, NY
    5 days ago
  • Senior SQL Developer Rochester, NY Long Term Strong MS SQL coding experience ( SQL Server 2008 or higher ) Writing complex stored procedures and building data transformations. ETL experience (preferable SAP Business Objects Data Services)

    3B Staffing LLC

    Rochester, NY
    9 hours ago
  • Job Title: SQL Developer Duration: Long Term Location: Rochester, NY Job Description: 1. Type of Service: Database System Consulting 2. Description of Work/Deliverables: The Database Systems Consultant will deliver the following: ...

    3B Staffing LLC

    Rochester, NY
    9 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to AI Data Architect. Be the first to apply!