Senior Data & AI Solutions Architect

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)