Snowflake Data Architect

Sira Consulting, an Inc 5000 company; Dallas (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

Sira Consulting, an Inc 5000 company, seeks a Snowflake Data Architect to lead design, implementation, and optimization of enterprise-scale cloud data platforms built on Snowflake. You will collaborate with business stakeholders, data engineers, and analytics teams to deliver scalable, secure data solutions.

The ideal candidate will have deep expertise in data architecture, cloud-native warehousing, data modeling, governance, and modern data engineering.

Qualifications

• Deep expertise in data architecture and cloud-native data warehousing.
• Experience with governance, security, and modern data engineering practices.
• Ability to collaborate with stakeholders, data engineers, analytics teams and enterprise architects.

Responsibilities

• Lead Data Architecture & Strategy for enterprise platforms.
• Design Snowflake solutions and optimize performance and cost.
• Establish security and governance practices across data assets.
• Drive analytics & AI enablement initiatives.
• Collaborate with business units to align technology with goals.

Skills

Snowflake Architecture

Snowflake Data Cloud

Snowpipe

Streams & Tasks

Time Travel & Cloning

Secure Data Sharing

External Tables

Dynamic Tables

Advanced SQL

Python

DBT

ETL/ELT Frameworks

Data Modeling

AWS

Azure

Job description

1. To design and architect large-scale solutions, ensuring scalability, performance, and security.

2. To train and develop team so as to ensure that there is an adequate supply of trained manpower in the said technology and delivery risks are mitigated.

3. To continuously upskill with cutting-edge tech to deliver high-quality, future-proof solutions meeting client expectations and industry standards.

4. To leverage domain/tech expertise to gather client needs, deliver solutions, and craft a technology strategy aligned with business goals.

Key Responsibilities

• Data Architecture & Strategy
• Snowflake Solution Design
• Security & Governance
• Performance & Cost Optimization
• Analytics & AI Enablement

Section Title: Skill Requirements

Skill Requirements

We are seeking an experienced Snowflake Data Architect to lead the design, implementation, and optimization of enterprise-scale cloud data platforms built on Snowflake. The ideal candidate will possess deep expertise in data architecture, cloud-native data warehousing, data modeling, governance, security, and modern data engineering practices. The architect will work closely with business stakeholders, data engineers, analytics teams, and enterprise architects to deliver scalable and secure data solutions.

Required Skills

Snowflake Expertise :

Snowflake Architecture, Snowflake Data Cloud, Snowpipe, Streams & Tasks, Time Travel & Cloning, Secure Data Sharing, External Tables, Dynamic Tables

AI :

Snowflake Cortex (preferred) and AI Leadership

Data Engineering :

Advanced SQL, Python, DBT, ETL/ELT Frameworks, Data Modeling (Kimball, Data Vault, Dimensional Modeling)

Cloud Platforms :

AWS (S3, Lambda, Glue, Redshift, EventBridge) or Azure (ADF, ADLS, Synapse)