AI Data Architect

Innovative Solutions, Reports into Rochester, NY

Posted pay

$150K–$200K

a year

Compared with similar jobs

This base pay is above the median for software engineering jobs that are remote in the US with no level in the job title.

Median: $165K a year
Other jobs in the group: 850

We compare the middle of each posted range. This is base pay as posted. The group does not include this job.

Location: Reports into Rochester, NY
Work type: Remote
Level: Not given
Experience: 5+ years
Skills in the job text: Python
AWS
SQL
Terraform
Spark
PostgreSQL
Databricks
DynamoDB
Elasticsearch
Power BI
Redshift
Snowflake
Posted: Jul 2, 2025
Last check: 1 h ago
Job type: Software engineering, Inference & ML systems, ML / AI engineering

Apply on the Innovative Solutions site Sign in to save

The Innovative Solutions site opens in a new tab.

Innovative Solutions

Open tech jobs: 5
With posted pay: 100%
Median posted base: $100K–$160K

About Innovative Solutions: funding, hiring and pay

Innovative Solutions

About Innovative Solutions: funding, hiring and pay

Check my fit

Compare your résumé with this job. See where you match, what is missing and which lines to change.

Sign in to check your fit

The role

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 will 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

What you need

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 encryptions

Nice to have

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

Read the job posting on the Innovative Solutions site

Similar jobs at other companies

Enterprise Data Architect & AI Solutions Leader
AnswerRocketUnited States - Remote
- Remote
- Software engineering
Pay not posted
Posted Jul 6, 2026
CA
Senior AI Data Solutions Engineer
Careers AirmethodsGreenwood Village, CO
- Senior
- Solutions engineering
Pay not posted
Posted 5 days ago
R
AWS Data Engineer
ResilientArgentina +10
- Remote
- Data engineering
Pay not posted
Posted Jul 20, 2026
Senior Data Engineer, Applied AI Solutions
Amazon Development Center U.S., Inc.Seattle, Washington
- Senior
- ML / AI engineering
$155K–$209K / yr
Posted Sep 24, 2026
Senior Solutions Architect
phDataUS - Remote
- Senior
- Remote
- Solutions engineering
- 2 positions
Pay not posted
Posted Sep 17, 2026
Senior Data Engineer, Selling Partner Agentic Interfaces Data Products
ADCI - KarnatakaBengaluru, Karnataka, IND
- Senior
- Data engineering
Pay not posted
Posted Aug 28, 2026

Source: the Innovative Solutions Lever job board. We last checked this job 1 h ago. We first saw it 5 days ago. A job on a job board does not always mean that the team interviews people now. We found this job board in a public list. We did not yet compare it with the careers page of the company.

Innovative Solutions

Open tech jobs: 5
With posted pay: 100%
Median posted base: $100K–$160K

About Innovative Solutions: funding, hiring and pay

Compared with similar jobs

This base pay is above the median for software engineering jobs that are remote in the US with no level in the job title.

Median: $165K a year
Other jobs in the group: 850

We compare the middle of each posted range. This is base pay as posted. The group does not include this job.