Snowflake Data Architect (1122723)

Location: Stamford, CT, USA

Salary: $140,000.00 USD Annually - $150,000.00 USD Annually

Description

• Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, Python, and/or cloud services preferably AWS
• Build and optimize data models (staging, warehouse, Datamarts) using best practices such as micro partitioning, clustering, and performance tuning.
• Develop and manage data ingestion workflows from structured and semi structured sources (JSON, Parquet, XML, APIs, etc.).
• Implementation of business requirements using Snowflake features such as Streams, Tasks, Time Travel, Zero Copy Cloning, and Snowpipe for automated data loads.
• Collaborate with Data architects, analysts, and business stakeholders to translate requirements into scalable technical solutions.
• Monitor and Troubleshoot pipelines for failures and issues ensuring data quality and integrity.
• Document data flows, transformations, and technical processes for maintainability and knowledge sharing
• Excellent analytical skills and strong understanding of SQL/PLSQL
• Job scheduling and orchestration using industry standard tools
  
  

Roles & Responsibilities

• Hands-on experience with Cloud based Database, preferably Snowflake
• Excellent SQL / PL SQL skills
• Basic understanding on AWS
• Experience on orchestration / scheduling tool, preferably Tidal
• Experience on Python is an advantage
• Working experience on Data Warehousing and Modeling
  
  

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact: tmangal@judge.com

This job and many more are available through The Judge Group. Find us on the web at www.judge.com