Innovativesol 2
AI Data Architect
Reports into Rochester, NY
hirly Pro
Get in front of the people hiring at Innovativesol 2
- Reach the hiring manager at Innovativesol 2 on LinkedIn, from your own account
- hirly applies to this job for you, with unlimited applications
- A resume and cover letter written for this job, unlimited
- The hiring manager and recruiter at Innovativesol 2, with contact details
$49 a month · ₹1,999 for 30 days in India · cancel any time
Get past the screening software and onto a recruiter's desk
hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.
- Keywords matched to this posting
- Fit score before you apply
- Cover letter included
Matched against 2.2M live jobs from 220,000+ employers in 200+ countries.
Tailor my resume for this job →Apply from your AI assistant
Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.
Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.
hirly's read of this role
- Seniority
- Mid level
- Stated salary
- $150,000 – $200,000 per year
- Country
- US
- Work mode
- Remote-friendly
- First seen by hirly
- 21 Sept 2026
Derived automatically from the posting. Upload your resume above to see how the role scores against it.
the posting
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
Listed on hirly, a job board. hirly is not the employer: Innovativesol 2 is hiring for this role.
Similar jobs
- Managing Data ArchitectCapgemini · Mclean, USFirst seen today
- Data Architect IIGM Financial United States · Arlington, TX, United StatesFirst seen yesterday
- Data ArchitectEXL · Pittsburgh, Pennsylvania, United StatesFirst seen yesterday
- Power BI Data Architect (Active Secret or Interim Clearance required)CompQsoft Inc. - ACTIVE · Herndon, VAFirst seen yesterday
- Data ArchitectNc · Wake County, NCFirst seen yesterday
Want this one?
Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.
Tailor my resume for this job