Senior AI Data Architect

Smith Arnold Partners; Connecticut; Remote; USD 150,000 - 165,000; Full time

Benefits offered by this job

Medical

Dental

401k

PTO

Remote work

Job summary

Smith Arnold Partners invites an experienced Senior Data & AI Solutions Architect to design enterprise data and AI platforms using Snowflake, Cortex, and cloud technologies. This remote, hands-on role focuses on practical delivery of Gen AI workloads and modern data integration, with emphasis on secure governance and collaboration with senior leaders.

The ideal candidate brings 12+ years in data/enterprise architecture, deep Snowflake expertise, and a passion for building scalable AI-enabled

Qualifications

• Lead design and architecture of enterprise data and AI solutions.
• Deliver Generative AI applications, including LLMs, RAG, AI agents.
• Work with Snowflake Cortex, Azure OpenAI, Azure AI Foundry, and Copilot Studio.
• Modernize legacy data environments; integrate DB2, PostgreSQL, and cloud platforms.
• Design scalable data pipelines, ETL/ELT, and data integration architectures.
• Establish secure, governed data architectures for advanced analytics.

Responsibilities

• Lead the design and architecture of enterprise data and AI solutions using Snowflake and cloud platforms.
• Architect and deliver Generative AI applications, including LLMs, RAG, and AI agents.
• Collaborate with teams to modernize legacy data environments and integrate multiple data stores.
• Design scalable data pipelines and secure data architectures for analytics and AI.
• Partner with leadership to translate business requirements into practical tech solutions.

Skills

Snowflake

Generative AI

Data Architecture

ETL/ELT

Cloud platforms

Security governance

Tools

Snowflake Cortex

Azure OpenAI

Copilot Studio

Job description

We have an outstanding opportunity for an experienced Senior Data & AI Solutions Architect to join a highly successful, financially strong organization that is making a major investment in modernizing its enterprise data platforms and expanding its use of Generative AI.

If you're an experienced Data & AI Architect with strong Snowflake expertise who enjoys building modern enterprise solutions and wants to be at the forefront of Generative AI adoption, this is an opportunity worth exploring.

What Employees Saying:

• "Leadership empowers employees to take ownership, innovate, and make a real impact on the business."
• "The culture is collaborative and supportive. You're surrounded by talented professionals who genuinely want to help each other succeed."
• "The combination of stability, strong benefits, and meaningful work makes this one of the best organizations I've worked for."

Why work here:

• A Purpose-Driven Mission: Join an organization where success is measured not only by business outcomes but also by the positive impact made in communities around the world.
• Enterprise-Scale Technology Environment: Work with cutting-edge networking, cloud, cybersecurity, and infrastructure technologies while leading critical transformation initiatives.
• Stability, Growth & Exceptional Benefits: Enjoy the advantages of a financially strong organization that invests in its people through competitive compensation, strong benefits, career development, and long-term opportunities.
• 100% Remote: Enjoy the flexibility of working remotely in a full-time, permanent position.
• Exciting Technology: Work with Snowflake, Cortex, Azure AI, LLMs, RAG, and agentic AI on meaningful enterprise initiatives.
• High-Impact Role: Help shape the organization's long-term data and AI architecture and technology direction.
• Hands-On Technical Leadership: Remain close to the technology while having significant influence over major architecture decisions.
• Stability & Long-Term Growth: Join a well-established, financially strong organization with a long history of success and a commitment to investing in technology

Title: Senior Data & AI Solutions Architect

Location: Remote (East Coast)

Salary: $150,000 to $165,000 +Bonus

Benefits: Medical / Dental / 401k / PTO and more

You’ll play a key role in designing the next generation of enterprise data and AI solutions, combining Snowflake, cloud technologies, large language models (LLMs), and agentic AI to build scalable, secure, production-ready systems.

This is not a management or purely strategic architecture position. We’re looking for someone who is technically strong, enjoys being hands-on, and wants to take ownership of complex architecture initiatives while working closely with senior technology and business leaders.

What You’ll Be Doing

• Lead the design and architecture of enterprise data and AI solutions using Snowflake, cloud platforms, and modern AI technologies.
• Architect and deliver Generative AI applications, including LLMs, RAG, AI agents, and agentic AI workflows.
• Work with Snowflake Cortex, Azure OpenAI, Azure AI Foundry, and Microsoft Copilot Studio to develop enterprise AI capabilities.
• Modernize legacy data environments, integrating mainframe/DB2 systems with Snowflake, PostgreSQL, and cloud-based platforms.
• Design scalable data pipelines, ETL/ELT processes, and modern data integration architectures.
• Establish secure, well-governed data architectures that support advanced analytics and AI applications.
• Partner with engineering teams, business leaders, and other architects to turn complex business requirements into practical technology solutions.

What We’re Looking For

• 12+ years of experience in Data Architecture, Data Engineering, or Enterprise Architecture.
• Strong hands-on experience with Snowflake, including Snowpark, Cortex, data integration, and data architecture.
• Proven experience designing and delivering Generative AI/LLM solutions in production, particularly RAG, AI agents, and agentic AI.
• Strong background in enterprise data architecture, data modeling, ETL/ELT, and cloud data platforms.
• Experience modernizing legacy data environments and integrating platforms such as IBM DB2, PostgreSQL, and Snowflake.
• Experience with Azure AI services, LLM orchestration frameworks, vector databases, and embeddings.
• Strong understanding of data security, governance, and enterprise architecture best practices.
• Experience in financial services, insurance, investments, or another highly regulated industry.
• Ability to work independently, make key technical decisions, and communicate effectively with both technical teams and business leadership.
• Experience with Talend, real-time data ingestion, multi-model AI orchestration, and enterprise-scale AI implementations would be particularly valuable.