Data Architect

Data Architect:
Pleasanton, CA
6 months

Key Responsibilities:
Design and implement scalable data warehouse solutions using Snowflake.
Develop and optimize complex SQL queries, stored procedures, and Snowflake asks.
Build and maintain ELT/ETL pipelines using tools such as Informatica, Talend, Matillion, or similar.
Integrate Snowflake with cloud platforms (AWS/Azure/GCP) and third-party systems.
Implement data modelling techniques (Star/Snowflake schema, Data Vault, etc.).
Perform performance tuning and query optimization.
Manage Snowflake security (roles, grants, RBAC, masking policies).
Monitor data loads, troubleshoot issues, and ensure data quality.
Collaborate with data engineers, BI developers, and business stakeholders.
Support production deployments and provide post-implementation support.
Required Skills:
Strong hands-on experience with Snowflake architecture and features.
Advanced SQL expertise.
Experience with cloud platforms (AWS, Azure, or GCP).
Knowledge of ETL/ELT tools and data integration techniques.
Understanding of data warehousing concepts and dimensional modelling.
Experience with semi-structured data (JSON, Parquet, Avro).
Familiarity with CI/CD pipelines and version control (Git).
Good understanding of data governance and security best practices