---
title: 'AI Data Architect at Innovative Solutions'
canonical: 'https://feeny.ai/job/ai-data-architect-innovative-solutions-reports-into-rochester-6q1dvafr9zg4'
type: 'job'
last_seen: '2026-09-11'
---

# AI Data Architect at Innovative Solutions

- **Company:** Innovative Solutions
- **Location:** Reports Into Rochester, NY
- **Compensation:** $150k–$200k
- **Employment:** full-time
- **Work type:** remote
- **Posted:** 2025-07-02
- **Last confirmed live:** 2026-09-11
- **Apply:** https://jobs.lever.co/innovativesol-2/562f10e5-3187-4832-ab82-56aa52f284f1

## Job description

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, 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 encryptions

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

## About Innovative Solutions

## Company Overview
- **One-liner**: Innovative Solutions is a data and AI company that helps growing businesses unlock intelligence from their data, automate complex workflows, and scale on AWS.
- **Entity Type**: Private (Venture-backed; $60M total funding as of March 2022)
- **Headquarters**: West Henrietta, New York, United States (with offices in Austin, TX and Boca Raton, FL)
- **Founded**: 1989
- **Founders**: Not publicly available (CEO: Justin Copie)

## Core Business
- **Primary Industry**: Information Technology & Services – specializing in cloud migrations, data engineering, AI/ML, and managed services on AWS.
- **Target Customers**: Small and mid-sized businesses (SMBs) and startups across the U.S. and Canada.
- **Mission**: Transform IT investments from cost centers into competitive advantages – helping organizations redirect technology spend toward systems that acquire and retain customers and drive profitability.

## Products & Services
- **Cloud Migrations**: Full-cycle migration from on-premises or other clouds to AWS, including readiness assessments and minimal-disruption execution.
- **AI & Generative AI Solutions**: Design and deployment of production-ready AI systems – AI agents, conversational assistants, intelligent document processing – using Amazon Bedrock, Anthropic Claude, Amazon Nova, and other foundation models.
- **Data Platforms & Analytics**: Modern data platforms, analytics environments, and ML systems that unify fragmented data into actionable intelligence.
- **Application Modernization**: Adoption of containers, serverless architectures, CI/CD pipelines, and infrastructure as code.
- **Managed Services**: Ongoing operational support to offload infrastructure management from client teams.

## Market Standing
- **Valuation/Market Cap**: Not disclosed.
- **Key Metric**: Annual Revenue ~$13.4M (latest estimate); Total Funding $60M (Venture Round, March 2022).
- **Notable Investors/Partners**: AWS Premier Tier Services Partner with Generative AI Competency and Migration Competency. No named investors publicly listed.
- **Growth Signals**: 
  - 1,900% year-over-year growth in GenAI projects (announced Dec 2024).
  - Customer base expanded by >85% in 2024, adding over 350 companies.
  - 99.7% client retention rate.
  - GenAI projects now account for nearly one-third of company revenue.
  - First AWS partner to offer Amazon Nova through its Tailwinds platform.
  - Employee count: 229 (+7.9% YoY), distributed across 16 countries.

## Competitive Advantages
- **Deep AWS Partnership**: Premier Tier partner with multiple competencies (GenAI, Migration) – a status held by a select few.
- **Proven Track Record**: 99.7% client retention and hundreds of successful migrations demonstrate consistent delivery.
- **Broad Technical Expertise**: Team of over 120 AWS certifications across data engineering, AI/ML, cloud architecture, DevOps, and security.
- **Cutting-Edge Focus**: Early adoption of new AWS AI services (e.g., Amazon Nova) keeps them ahead of the curve.

## Strategic Focus
- Continue scaling Generative AI offerings and expanding the Tailwinds platform.
- Grow client base in SMB and mid-market segments across North America.
- Deepen expertise in emerging AWS services and AI capabilities.
- Maintain high client retention through managed services and partnership approach.

## Why Work Here
- **Culture**: People-first, collaborative environment that values intention, ownership, and doing things the right way. Described as a team of engineers, architects, and problem-solvers who care deeply about technology and its impact.
- **Flexibility**: Flexible work arrangements built on trust and accountability; generous paid time off and paid holidays; culture respects focus time and life outside work.
- **Benefits**: Comprehensive medical, dental, and vision coverage; employer-supported health benefits for you and your family; programs designed for long-term wellbeing.
- **Growth & Learning**: Ongoing professional development, support for certifications and continued education, clear career growth opportunities as the company expands.
- **Remote/Hybrid**: Not explicitly stated as fully remote, but offices in NY, TX, FL and distributed workforce across 16 countries suggest flexible/remote options are available.
- **Engineering Culture**: All technical team members are AWS-certified; strong emphasis on continuous learning and staying current with cloud and AI advancements.

## Sources
1. [innovativesol.com](https://innovativesol.com/)
2. [innovativesol.com/about-us](https://innovativesol.com/about-us/)
3. [innovativesol.com/careers](https://innovativesol.com/careers/)
4. [jobs.lever.co/innovativesol-2](https://jobs.lever.co/innovativesol-2)
5. [linkedin.com/company/innovative-solutions](https://www.linkedin.com/company/innovative-solutions)

## Other roles at Innovative Solutions

- [Accounts Receivables Specialist](https://feeny.ai/job/accounts-receivables-specialist-innovative-solutions-rochester-7g9fws3ehs3d) — Rochester, NY
- [AWS Technical Account Manager](https://feeny.ai/job/aws-technical-account-manager-innovative-solutions-remote-h02xpzn3z6gp)
- [Business Development Specialist (must reside in Boca Raton, Florida)](https://feeny.ai/job/business-development-specialist-must-reside-in-boca-raton-florida-innovative-y4zhfdz0tbeb) — Boca Raton, FL
- [Business Development Specialist (must reside in Boca Raton, Florida)](https://feeny.ai/job/business-development-specialist-must-reside-in-boca-raton-florida-innovative-wq8y9gv8jrn1) — Boca Raton, FL
- [Cloud Engineer- Data/AI Focused](https://feeny.ai/job/cloud-engineer-data-ai-focused-innovative-solutions-reports-into-rochester-js5sppy8vpdb) — Reports Into Rochester, NY
- [Cloud Architect - Software Development](https://feeny.ai/job/cloud-architect-software-development-innovative-solutions-reports-into-rochester-0dsh4j1xbxq8) — Reports Into Rochester, NY
- [Cloud Engineer - Full Stack Developer](https://feeny.ai/job/cloud-engineer-full-stack-developer-innovative-solutions-reports-into-rochester-bpm1fsedt8qk) — Reports Into Rochester, NY
- [AI Data Architect](https://feeny.ai/job/ai-data-architect-3pillar-united-states-z678xxz6g5dd) — United States