Snowflake Data Architect – Python

Smart IT Frame LLC; Connecticut; On-site; USD 140,000 - 210,000; Full time

Job summary

Smart IT Frame LLC in Hartford, CT seeks a Snowflake Data Architect with strong Python development experience to design and optimize scalable Snowflake data platforms. You will provide technical leadership, define architecture standards, and collaborate with business and technical teams to deliver enterprise data solutions.

Responsibilities include data ingestion, modeling, performance tuning, and implementing governance, security, and access controls while evaluating new Snowflake features for

Qualifications

• Experience with Snowflake data architecture and modeling.
• Strong Python development and automation experience.
• Experience with ETL/ELT and cloud data platforms.

Responsibilities

• Design and develop scalable Snowflake data warehouse solutions.
• Define and enforce Snowflake architecture standards and patterns.
• Provide hands-on Snowflake architecture, data modeling, and query optimization.
• Develop Python-based data processing and Snowflake integration.
• Lead data ingestion, transformation, storage, and integration initiatives.
• Optimize Snowflake warehouses, queries, workloads, and resource usage.
• Ensure data governance, security, compliance, and access controls.
• Evaluate and adopt new Snowflake features for enterprise solutions.
• Lead complex Snowflake projects from architecture to delivery.

Skills

Snowflake Data Architecture

Python programming

ETL/ELT

SQL performance tuning

Data modeling

Data governance/security

Job description

Job Title: Snowflake Data Architect - Python

Location: Hartford, CT (Onsite)

Job Summary

We are seeking an experienced Snowflake Data Architect with strong hands‑on Pythondevelopment experience to design, develop, and optimize scalable, secure, and high-performing Snowflake data platforms. The ideal candidate will provide technical leadership, define architecture standards, and work closely with business and technical teams to deliver enterprise data solutions.

Key Responsibilities

• Design and develop scalable Snowflake data warehouse and data platform solutions.
• Define and enforce Snowflake architecture standards, best practices, and design patterns.
• Provide hands‑on expertise in Snowflake architecture, data modeling, performance tuning, and query optimization.
• Develop Python-based solutions for data processing, automation, and Snowflake integration.
• Lead data ingestion, transformation, storage, and integration initiatives.
• Optimize Snowflake warehouses, queries, workloads, and resource utilization.
• Ensure data governance, security, compliance, and access‑control standards are maintained.
• Evaluate and implement new Snowflake features and capabilities.
• Lead complex Snowflake projects from architecture through implementation and delivery.

Required Skills

• Strong hands‑on experience with Snowflake Data Architecture.
• Excellent knowledge of Snowflake architecture, data modeling, and optimization.
• Strong Python programming and automation experience.
• Experience with ETL/ELT, data ingestion, and cloud data platforms.
• Expertise in SQL, query performance tuning, and warehouse/resource management.