What are the responsibilities and job description for the Snowflake Data Architect (1122723) position at The Judge Group?
Location: Stamford, CT, USA
Salary: $140,000.00 USD Annually - $150,000.00 USD Annually
Description
Contact: tmangal@judge.com
This job and many more are available through The Judge Group. Find us on the web at www.judge.com
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
- 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
Contact: tmangal@judge.com
This job and many more are available through The Judge Group. Find us on the web at www.judge.com
Salary : $140,000 - $150,000