Senior Snowflake Data Architect

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

Job summary

Robotics Technologies LLC in California is seeking an experienced Data Engineer to design and build enterprise data warehouses on Snowflake, optimize performance, and implement scalable ETL/ELT pipelines.

You will partner with analytics and engineering teams to establish data governance, security, and metadata standards while mentoring junior engineers and driving architecture reviews.

This role requires hands-on cloud experience and a proactive, collaborative approach.

Qualifications

• 8–12+ years of data engineering, warehousing, or architecture.
• 5+ years Snowflake architecture hands-on experience.
• Advanced SQL programming and performance tuning.
• ETL/ELT development and data integration experience.
• Data modeling, dimensional modeling, and database design.
• Python and Snowflake scripting.
• Experience with AWS/Azure/GCP.
• Snowflake security, governance, and access management.
• Mentor and lead development teams.

Responsibilities

• Design and implement enterprise data warehouse architectures on Snowflake.
• Define data architecture standards for cloud platforms.
• Develop and optimize SQL, stored procedures, and Snowflake objects.
• Build scalable ETL/ELT pipelines for ingestion and transformation.
• Leverage Snowflake features: Virtual Warehouses, Snowpipe, Time Travel, Zero-Copy Cloning.
• Implement data integration with Informatica, Matillion, Fivetran, dbt, or Talend.
• Model data using Star and Snowflake schemas.
• Optimize query performance and Snowflake cost management.
• Apply data security, RBAC, masking, and row-level security.
• Establish governance, data quality, metadata, and lineage standards.
• Integrate Snowflake with AWS/Azure/GCP.
• Lead architecture reviews and PoC initiatives.
• Collaborate with stakeholders, data engineers, analysts, and apps teams.
• Mentor development teams on Snowflake best practices.

Skills

Snowflake architecture

SQL performance tuning

ETL/ELT development

Python

Cloud platforms (AWS/Azure/GCP)

Data modeling

Data governance & security

Leadership & mentoring

Tools

Informatica

Matillion

Fivetran

dbt

Talend

Job description

Robotics Technologies LLC in California is seeking an experienced Data Engineer to design and build enterprise data warehouses on Snowflake, optimize performance, and implement scalable ETL/ELT pipelines.

You will partner with analytics and engineering teams to establish data governance, security, and metadata standards while mentoring junior engineers and driving architecture reviews.

This role requires hands-on cloud experience and a proactive, collaborative approach.