Senior Data & AI Solutions Architect
JOB DESCRIPTION | Senior Data & AI Solutions Architect Job Title: Senior Data & AI Solutions Architect Location: Remote (New Haven, CT) Job Type: FT 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, row level 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 Required Skills: · 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 Required: · 12+ years in data architecture, data engineering, or enterprise architecture · 5+ years in financial services (life insurance, annuities, investments preferred)