Lead Snowflake & AI Data 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

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.