Snowflake Data Architect

Avalon Software Services LLC; Santa Clara (CA); On-site; USD 130,000 - 160,000; Full time

Job summary

A leading software services company is seeking a Snowflake Data Architect to work onsite in Santa Clara, CA. Candidates must have strong experience in data engineering using Snowflake, with deep knowledge of data architecture principles and ETL/ELT processes. The role requires excellent communication skills and the ability to drive technical initiatives independently. If you have a passion for designing scalable, reliable data solutions, this could be the perfect opportunity.

Qualifications

• Strong hands-on experience in data engineering using Snowflake.
• Deep understanding of data architecture principles.
• Solid experience in system design and solution architecture.

Responsibilities

• Build and optimize large-scale data pipelines.
• Implement data lineage, quality, and monitoring frameworks.
• Drive technical initiatives in a collaborative environment.

Skills

Data engineering using Snowflake

Data architecture principles

System design and solution architecture

ETL/ELT pipeline design

Data modeling techniques

Optimizing compute and storage costs

Database administration

Data lineage and quality frameworks

SQL proficiency

Reporting and visualization tools

Job description

Snowflake Data Architect - Onsite all 5 days

Location: Santa Clara, CA

Note: The candidate is required to attend the final interview in person at Santa Clara, CA

Key Requirements

• Strong hands-on experience in data engineering using Snowflake with proven ability to build and optimize large-scale data pipelines.
• Deep understanding of data architecture principles, including ingestion, transformation, storage, and access control.
• Solid experience in system design and solution architecture, focusing on scalability, reliability, and maintainability.
• Expertise in ETL/ELT pipeline design, including data extraction, transformation, validation, and load processes.
• In-depth knowledge of data modeling techniques (dimensional modeling, star, and snowflake schemas).
• Skilled in optimizing compute and storage costs across Snowflake environments.
• Strong proficiency in administration, including database design, schema management, user roles, permissions, and access control policies.
• Hands-on experience implementing data lineage, quality, and monitoring frameworks.
• Advanced proficiency in SQL for data processing, transformation, and automation.
• Experience with reporting and visualization tools such as Power BI and Sigma Computing.

Excellent communication and collaboration skills, with the ability to work independently and drive technical initiatives.