Snowflake Data Architect – Python

Smart IT Frame LLC; Hartford (CT); On-site; USD 140,000 - 190,000; Full time

Job summary

Smart IT Frame LLC is seeking an experienced Snowflake Data Architect with strong Python development skills to design, develop, 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 leading Snowflake data warehouse projects, performance tuning, data ingestion, security, and governance.

Qualifications

• Strong hands-on Snowflake data architecture
• Excellent data modeling and optimization knowledge
• 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

Responsibilities

• Design and implement scalable Snowflake data warehouses and platforms.
• Define and enforce Snowflake architecture standards and design patterns.
• Lead hands-on Snowflake architecture, data modeling, performance tuning, and query optimization.
• Develop Python-based solutions for data processing 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.
• Evaluate and implement new Snowflake features and capabilities.
• Lead complex Snowflake projects from design through delivery.

Skills

Snowflake Architecture

Data Modeling

Performance Tuning

Python Programming

ETL/ELT

SQL Proficiency

Data Ingestion

Cloud Data Platforms

Automation

Data Governance

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.