JOB DESCRIPTION | Senior Data & AI Solutions Architect
Job Overview
- Title: Senior Data & AI Solutions Architect
- Location: New Haven, CT
- Work Mode: Hybrid-C2H
- Experience Required: 12+ Years
- Domain Preference: Financial Services / Enterprise Data Platforms
- Key Skills: Snowflake, GenAI, RAG, DB2 Migration, Azure AI
Core Responsibilities
· Define and govern enterprise Data & AI architecture across legacy, cloud, and AInative platforms
· Architect hybrid data integration across mainframe, DB2, Snowflake, Postgres, Talend, and event streaming
· Design and deliver LLM and agentic AI solutions using Snowflake Cortex,Azure AI Foundry, Azure OpenAI Service, Copilot Studio, and orchestration frameworks
· Establish RAG, vector database, and embedding strategies for enterprise research and analytics
· Coordinate the continual modernization of ETL and Lakehouse architecture
· Enable Snowflake governance: RBAC, dynamic masking, rowlevel security, encryption
· Ensure compliance with OSFI, SOX, NAIC, PIPEDA/GDPR, SEC/state insurance regulations
· Partner with business, risk, compliance, legal, IT, Information Security and vendors as the lead technical advisor
Skills Required:
· 3+ years hands on Snowflake experience (Snowpark, Cortex, data sharing)
· 3+ years delivering production LLM / GenAI solutions (RAG, agents, finetuning)
· Proven legacy to cloud migration experience involving IBM DB2 or equivalent
· Experience with Talend, modern data integration, and real time ingestion
· Knowledge of relational (e.g., PostgreSQL), NoSQL, NewSQL, and vector/LLM databases
· Demonstrated experience with legacy-to-cloud data migration involving IBM DB2 or equivalent mainframe/relational systems
· Proven delivery of agentic AI systems or multi-model orchestration pipelines in enterprise environments
Education:
· 12+ years in data architecture, data engineering, or enterprise architecture
· 5+ years in financial services (life insurance, annuities, investments preferred)
Never miss an opportunity! Create an alert based on the job you applied for.