Senior Snowflake Architect: Data Warehouse Leader

Artifintech; Santa Clara (CA); On-site; USD 150,000 - 230,000; Full time

Job summary

Artifintech in Santa Clara, CA seeks a senior Data Engineer to design and implement enterprise Snowflake data warehouses and related architectures. You will drive data modeling, SQL optimization, and scalable ETL/ELT pipelines across cloud environments.

You will lead technical discussions, mentor teams, and collaborate with stakeholders to ensure data security, governance, and cost management in Snowflake deployments. Compliance and performance are essential.

Qualifications

• 8–12+ years in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years with Snowflake architecture and implementation.
• Strong SQL programming and performance tuning.
• Experience with Python and Snowflake scripting.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of data governance, metadata, and data lineage (desirable).

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 discussions, reviews, and PoC initiatives.
• Mentor development teams on Snowflake best practices.
• Collaborate with data engineers, analysts, and application teams.
• Ensure data security, RBAC, masking policies, and cost management.

Skills

Snowflake architecture

Advanced SQL

ETL/ELT development

Data modeling

Python

Cloud platforms (AWS/Azure/GCP)

Data security concepts

Tools

Informatica

Matillion

Fivetran

dbt

Talend

Job description

Artifintech in Santa Clara, CA seeks a senior Data Engineer to design and implement enterprise Snowflake data warehouses and related architectures. You will drive data modeling, SQL optimization, and scalable ETL/ELT pipelines across cloud environments.

You will lead technical discussions, mentor teams, and collaborate with stakeholders to ensure data security, governance, and cost management in Snowflake deployments. Compliance and performance are essential.