Senior Snowflake Architect: Enterprise Data Warehouse Lead

Valiant Technologies LLC; Santa Clara (CA); On-site; USD 180,000 - 260,000; Full time

Job summary

Valiant Technologies LLC in Santa Clara, CA is seeking a senior Data Engineer to architect and implement enterprise data warehouse solutions on Snowflake. You will design data architectures, optimize queries, and build scalable ETL/ELT pipelines using Informatica, Matillion, Fivetran, dbt or Talend.

Collaborate with stakeholders and mentor teams, lead architecture reviews, and ensure data governance, security, and cost optimization across AWS/Azure/GCP.

Qualifications

• 8–12+ years in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years with Snowflake architecture and implementation.
• Strong expertise in Snowflake cloud data warehouse architecture.
• Advanced SQL programming and performance tuning.
• Experience with ETL/ELT development and data integration.
• Data modeling with dimensional modeling and database design.
• Hands-on Python and Snowflake scripting.
• Experience with AWS, Azure, or GCP.

Responsibilities

• Design and implement enterprise-level data warehouse architectures using Snowflake.
• Define data architecture standards and best practices for cloud platforms.
• Develop and optimize complex SQL queries, stored procedures, views, and Snowflake objects.
• Design scalable ETL/ELT pipelines for data ingestion and transformation.
• Lead architecture reviews and proof-of-concept initiatives.
• Collaborate with stakeholders and cross-functional teams; mentor development teams.

Skills

Snowflake architecture

Advanced SQL

Python

Cloud platforms (AWS/Azure/GCP)

Data modeling (Dimensional)

RBAC and data security

Tools

Informatica

Matillion

Fivetran

dbt

Talend

Job description

Valiant Technologies LLC in Santa Clara, CA is seeking a senior Data Engineer to architect and implement enterprise data warehouse solutions on Snowflake. You will design data architectures, optimize queries, and build scalable ETL/ELT pipelines using Informatica, Matillion, Fivetran, dbt or Talend.

Collaborate with stakeholders and mentor teams, lead architecture reviews, and ensure data governance, security, and cost optimization across AWS/Azure/GCP.