Senior Snowflake Architect - Data Warehouse & Cloud Strategy

Quantum Technologies. LLC; Santa Clara (CA); On-site; USD 170,000 - 260,000; Full time

Job summary

Quantum Technologies. LLC is seeking an experienced Data Engineer to design and implement enterprise Snowflake-based data warehouse architectures in a cloud environment. You will define standards, optimize complex SQL, and build scalable ETL/ELT pipelines, working with stakeholders and cross-functional teams.

The role requires hands-on Snowflake expertise, Python scripting, and a strong background in data modeling and security, RBAC, and data governance across AWS/Azure/GCP platforms.

Qualifications

• 8–12+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years of hands-on experience with Snowflake architecture and implementation.
• Strong expertise in Snowflake cloud data warehouse architecture.
• Advanced SQL programming and performance tuning.
• Hands-on experience with Python and Snowflake scripting.

Responsibilities

• Design and implement enterprise-level data warehouse architectures using Snowflake.
• Define data architecture strategies, standards, and best practices for cloud-based data platforms.
• Develop and optimize complex SQL queries, stored procedures, views, and Snowflake objects.
• Design and implement scalable ETL/ELT pipelines for data ingestion and transformation.
• Work with Snowflake features such as Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel.
• Lead technical discussions, architecture reviews, and proof-of-concept initiatives.
• Collaborate with business stakeholders, data engineers, data analysts, and application teams.

Skills

Snowflake architecture

SQL

ETL/ELT

Python

Cloud platforms

Data modeling

DWH design

RBAC & security

Mentoring

Data governance

Tools

Informatica

Matillion

Fivetran

dbt

Talend

Job description

Quantum Technologies. LLC is seeking an experienced Data Engineer to design and implement enterprise Snowflake-based data warehouse architectures in a cloud environment. You will define standards, optimize complex SQL, and build scalable ETL/ELT pipelines, working with stakeholders and cross-functional teams.

The role requires hands-on Snowflake expertise, Python scripting, and a strong background in data modeling and security, RBAC, and data governance across AWS/Azure/GCP platforms.