Remote Senior Data & AI Solutions Architect

Who we are StopAHack.com® is a veteran-founded cybersecurity and technology services company and a Great Place To Work® certified employer . We deliver hands-on expertise to client programs and partner-led engagements. The role You will be a W-2 employee of StopAHack assigned to support an enterprise Data & AI modernization program for a financial services client. This is a senior-level, hands-on individual contributor role responsible for designing secure, governed, and scalable data and artificial intelligence solutions across business lines including Life Insurance, Investments, Membership, and Charities . The role partners closely with business leaders, data analysts, data movement engineers, infrastructure teams, peer architects, Information Security, risk, compliance, legal, and vendors to modernize legacy platforms including mainframe and IBM DB2 into a cloud and AI-enabled ecosystem using Snowflake, PostgreSQL, Talend, Microsoft Copilot, Snowflake Cortex, Azure AI Foundry, Azure OpenAI Service , and enterprise large language models. What you will do Define and govern enterprise Data & AI architecture across legacy, cloud, and AI-native platforms. Architect hybrid data integration across mainframe, IBM DB2, Snowflake, PostgreSQL, Talend , and event streaming environments. Design and deliver LLM and GenAI solutions using Snowflake Cortex, Azure AI Foundry, Azure OpenAI Service, Copilot Studio , and orchestration frameworks. Establish RAG, vector database, embedding , and retrieval strategies for enterprise research and analytics. Coordinate modernization of ETL, data movement, and Lakehouse architecture . Enable Snowflake governance , including RBAC, dynamic masking, row-level security, encryption , and secure data sharing. Support architectures aligned with financial services security, privacy, risk, and regulatory expectations. Partner with business, risk, compliance, legal, IT, Information Security, and vendors as the lead technical advisor. Produce clear architecture documentation, solution designs, standards, and implementation guidance. What you bring (must-have) 12+ years of experience in data architecture, data engineering, enterprise architecture, or related technical roles. 5+ years of financial services experience , preferably in life insurance, annuities, investments , or regulated financial environments. 3+ years of hands-on Snowflake experience , including Snowpark, Cortex, data sharing , or governance capabilities. 3+ years delivering production LLM / GenAI solutions , including RAG, agents, embeddings , or AI orchestration. Proven legacy-to-cloud migration experience involving IBM DB2 , mainframe, or equivalent enterprise relational systems. Experience with Talend , modern data integration, ETL modernization, and real-time ingestion patterns. Knowledge of relational, NoSQL, NewSQL, and vector/LLM databases, including PostgreSQL . Strong communication, documentation, stakeholder partnership, and technical leadership skills. Ability to work independently across multiple business, technical, compliance, and vendor stakeholders. Nice to have Experience with Azure AI Foundry, Azure OpenAI Service, Copilot Studio , and Microsoft enterprise AI capabilities. Experience with Snowflake Cortex , Snowpark , and AI/ML workloads within Snowflake. Familiarity with SOX, NAIC, PIPEDA/GDPR, SEC/state insurance regulations , or similar regulated environments. Experience supporting enterprise data programs in insurance, annuities, investments , or member-based organizations. Experience designing Deep Research LLM , enterprise search, knowledge retrieval, or agentic AI platforms. Reporting and supervision Employer of record: StopAHack.com® Corporation . Performance management, PTO approval, and HR support are provided by StopAHack . Project priorities and day-to-day coordination are aligned with the client’s data, AI, and technology leadership teams. Work model and hours Remote within the United States. Preference for candidates located in Connecticut, New York, or New Jersey . Standard hours aligned to the client’s time zone and project needs. Work authorization Applicants must be authorized to work in the United States without current or future sponsorship. Hiring process StopAHack screening and technical interviews. Client or partner alignment interviews, as applicable. Background checks and onboarding aligned to client and contract requirements. Assignment to active client project work. EEO and accessibility StopAHack.com® is an Equal Opportunity Employer. We consider all applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other legally protected status. If you require a reasonable accommodation during the application or interview process, contact info@stopahack.com . Note: References to third-party products including Snowflake, Microsoft, Azure, IBM DB2, PostgreSQL, Talend, Copilot Studio, Azure OpenAI Service , and related technologies indicate the nature of the services delivered; employment remains with StopAHack.com® . Show more Show less