snowflake Archtect

Futran Solutions; Webster (PA); On-site; USD 120,000 - 160,000; Full time

Job summary

Futran Solutions in West Chester, PA, seeks a Data solution Snowflake & AI Architect to lead high‑impact data initiatives. You will architect scalable data platforms, integrate Snowflake ecosystem components, and collaborate with analytics and AI teams to deliver secure, reliable data products.

Responsibilities include designing ELT/ETL pipelines with SQL, Python, and dbt; establishing governance and data models; and guiding modernization efforts from legacy platforms to cloud-native, AI-ready

Qualifications

• Experience architecting scalable, secure data architectures.
• Proficiency in Snowflake & cloud data platforms.
• Strong governance and security practices for AI workloads.

Responsibilities

• Architect and deliver Snowflake-based data solutions.
• Design ELT/ETL frameworks using SQL, Python, and dbt.
• Develop AI solutions with LLMs, Agentic AI, and RAG.
• Lead data modernization from legacy systems to cloud-native platforms.

Skills

Architectural leadership

Generative AI

AI governance

Data modernization

Tools

Snowflake

Snowpark

dbt

SQL

Python

Cortex AI

RAG

Job description

we have full time position for Data solution Snowflake& AI Architect at West Chester, Pennsylvania

Role : Data solution Snowflake& AI Architect

Location : West Chester, Pennsylvania

Job Type : FT

Job Description -

Key Responsibilities

• Architect and deliver high-performing, secure, and scalable data solutions utilizing the comprehensive Snowflake ecosystem, including Snowpark, Cortex AI, Dynamic Tables, Streams, Tasks, and Native Apps.

Enterprise Architecture & Snowflake Leadership

• Design and implement robust ELT/ETL frameworks leveraging SQL, Python, and dbt, while optimizing workloads for performance, cost-efficiency, and governance.
• Establish data models and reference architectures that seamlessly support analytical, operational, and AI-driven business objectives.

Generative AI & Advanced Analytics

• Design enterprise-grade AI solutions incorporating Large Language Models (LLMs), Agentic AI, RAG (Retrieval-Augmented Generation) frameworks, and vector/semantic search.
• Establish comprehensive AI governance protocols, including prompt engineering strategies, model evaluation criteria, hallucination mitigation, and security guardrails.
• Evaluate and integrate emerging AI technologies and vector databases to ensure architectures remain scalable and aligned with strategic business use cases.

Data Modernization & Digital Transformation

• Lead complex migration initiatives to transition organizations from legacy data platforms (e.g., Teradata, Netezza, Oracle Exadata) to cloud-native, AI-ready ecosystems.