Senior Snowflake Architect — Cloud Data Warehouse Leader

MACHINE LEARNING TECHNOLOGIES LLC; Santa Clara (CA); On-site; USD 98,000 - 113,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in Santa Clara, CA is seeking a seasoned Snowflake Architect to design and implement enterprise data warehouse architectures. You will lead data architecture strategies, optimize SQL and Snowflake objects, and craft scalable ETL/ELT pipelines across cloud platforms.

This role requires deep Snowflake expertise, strong SQL and data modeling skills, and experience with data integration tools.

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.
• Strong experience with ETL/ELT development and data integration.
• Expertise in data modeling, dimensional modeling, and database design.
• Hands-on experience with Python and Snowflake scripting.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of Snowflake security, governance, and access management.
• Experience designing large-scale data pipelines and enterprise data solutions.

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, Zero-Copy Cloning, and Dynamic Tables.
• Develop data integration solutions using tools such as Informatica, Matillion, Fivetran, dbt, or Talend.
• Implement data modeling techniques, including Star Schema, Snowflake Schema, and dimensional modeling.
• Optimize query performance, warehouse utilization, and overall Snowflake cost management.
• Implement data security, role-based access control (RBAC), masking policies, and row-level security.
• Establish data governance, data quality, metadata management, and data lineage standards.
• Integrate Snowflake with cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Lead technical discussions, architecture reviews, and proof-of-concept initiatives.
• Collaborate with business stakeholders, data engineers, data analysts, and application teams.
• Mentor development teams and provide technical guidance on Snowflake best practices.

Skills

Data engineering experience

Data warehousing

Data architecture

SQL expert

Python

Tools

Snowflake

Informatica

Matillion

Fivetran

dbt

Talend

Job description

MACHINE LEARNING TECHNOLOGIES LLC in Santa Clara, CA is seeking a seasoned Snowflake Architect to design and implement enterprise data warehouse architectures. You will lead data architecture strategies, optimize SQL and Snowflake objects, and craft scalable ETL/ELT pipelines across cloud platforms.

This role requires deep Snowflake expertise, strong SQL and data modeling skills, and experience with data integration tools.