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)
