Lead Snowflake Engineer / Architect

Snowflake Administration, Architecting, snowflake pipelines, Data warehouse, ETL, BI, Complex sql queries, SnowSQL, data integration, data transformation, data movement, api, snaplogic, AWS or Azure paas technologies, Agile development methodologies
Contract W2, Contract Corp-To-Corp, 6 Months
Depends on Experience

Job Description

InfoTech Spectrum delivers comprehensive fully integrated creative IT solutions ranging from IT consulting services to advanced technology deployment and product development.

Role: Lead Snowflake Engineer / Architect

Location: 100% Remote

Job Description:

We are looking to hire a very strong Snowflake Lead Engineer/Architect to work on a long term contract. The client is replacing a legacy data warehouse with a data warehouse built using Snowflake. The team will consist of onshore and offshore resources. The client is based in the bay area but this will be 100% Remote contract.


  • Total 10+ years in IT (DW/ETL/BI projects preferred) with heavy emphasis on design, development, tuning of complex SQL queries.
  • Worked as a Snowflake lead/architect in the last 2-3 assignments or 3-4 years.
  • Experience with Snowflake Administration, architecting various scaling and clustering methods are required
  • Experience in designing and developing Snowflake pipelines to consume heavy files and performance optimization.
  • Provide technical guidance on the Snowflake architecture, policy, best practices and pipeline / integration flows.
  • Expertise with SnowSQL, advanced concepts (query performance tuning, time travel, deep understanding of Snowflake system tables such as metadata and history tables etc.) and features/tools (data sharing, events, SnowPipe etc.)
  • Hands-on Experience in data integration, data transformation, and data movement that are based upon CDC, ETL, API and other integration mechanisms such as Snaplogic
  • Understanding of performance tuning and troubleshooting aspects
  • Experience in Agile development methodologies
  • Previous experience with public cloud like AWS and/or Azure PaaS technologies
Dice Id : 10120349
Position Id : SF_Arch2021
Originally Posted : 6 months ago
Have a Job? Post it