Data - Snowflake Architect

Smart IT Frame LLC; Pennsylvania; On-site; USD 180,000 - 240,000; Full time

Job summary

Smart IT Frame LLC is seeking a highly experienced Lead Solutions Architect to design and deliver enterprise-scale data and AI platforms. You will bridge complex business requirements with Snowflake-based solutions and drive data modernization initiatives.

This role requires guiding both technical engineering teams and C-suite executives, shaping governance, security, and scalable architectures while leveraging Generative AI capabilities.

Qualifications

• Experience designing and delivering enterprise-scale data and AI platforms.

Responsibilities

• Architect and deliver high-performing, secure, and scalable data solutions using the Snowflake ecosystem.
• Design and implement robust ELT/ETL frameworks leveraging SQL, Python, and dbt.
• Establish data models and reference architectures to support analytical, operational, and AI-driven objectives.

Skills

Snowflake

Generative AI

ETL/ELT design

Python

dbt

Architectural leadership

Tools

Snowpark

Cortex AI

Dynamic Tables

Streams

Tasks

Job description

We are seeking a highly experienced and strategic Lead Solutions Architect to design and deliver enterprise-scale data and Artificial Intelligence platforms.

In this role, you will serve as the technical bridge between complex business requirements and advanced technological solutions, specializing in the Snowflake ecosystem, Generative AI, and enterprise data modernization.

This position requires a practitioner who combines deep architectural expertise with the ability to provide strategic advisory services to both technical engineering teams and C-suite executives.

Key Responsibilities

Enterprise Architecture & Snowflake Leadership

• 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.
• 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.