Job ID: JOB_ID_7184
Job Overview:
We are seeking an experienced Snowflake Architect to design, build, and maintain enterprise Snowflake data warehouse solutions. This role involves leading migrations from legacy platforms to Snowflake on Azure/AWS, integrating Snowflake with cloud services, and developing scalable data transformation models. The ideal candidate will have advanced Snowflake expertise, strong cloud integration skills, and experience with CI/CD and DevOps practices.
Key Responsibilities:
- Design, build, and maintain enterprise Snowflake data warehouse solutions for analytics and data science.
- Implement Snowflake features including Snowpipe, Streams, Tasks, Virtual Warehouses, Data Sharing, Cloning, Secure Views, and Time Travel.
- Develop real-time and batch ingestion pipelines using Snowpipe, COPY, and cloud storage stages.
- Manage Snowflake databases, schemas, tables, and consumption layers following best practices.
- Lead migrations from legacy platforms (Teradata, Oracle, SAP, RDBMS) to Snowflake on Azure/AWS.
- Integrate Snowflake with Azure (Blob, Containers, Cosmos DB, Events, DevOps) and AWS (S3, IAM, EC2, RDS, SQS, SNS, Lambda).
- Configure secure cloud stages, RBAC/IAM, and automated ingestion workflows.
- Build scalable DBT models, macros, and tests across staging, ODS, and data marts.
- Implement incremental models focusing on performance and cost optimization.
- Enable data science/AI use cases including Snowflake Cortex and Feature Store.
- Design and manage RBAC, functional/custom roles, and least privilege security models.
- Implement Security Integrations, Network Policies, SSO (Azure AD), and governance controls.
- Manage inbound/outbound data sharing, marketplace datasets, and audit documentation.
- Implement Snowflake database/account replication and Failover Groups.
- Lead DR setup, regional migrations, and greenfield platform cutovers.
- Monitor performance, long-running queries, and credit usage through resource monitors.
- Perform query tuning and recommend optimal warehouse sizing and workload distribution.
- Enhance CI/CD pipelines using Azure DevOps/Git for Snowflake and DBT deployments.
- Support production operations, incident/problem/change management, and release cycles.
- Work with scheduling tools like Control M, Airflow, and TWS.
- Serve as Tech Lead, mentor engineers, and enforce development standards.
- Collaborate with analysts, data scientists, and platform teams.
- Participate in agile ceremonies, sprint planning, and status reporting.
Required Skills & Qualifications:
- Snowflake: Advanced in architecture, Snowpipe, Sharing, Streams/Tasks, Cloning, Time Travel, Cortex.
- Cloud: Azure & AWS (S3, IAM, EC2, RDS, SQS, SNS, Lambda, Blob, Cosmos DB).
- Transformation: DBT, Matillion.
- Databases: Teradata, Oracle.
- Languages: SQL (expert), SnowSQL, PL/SQL, Python (basic-intermediate), Shell scripting.
- CI/CD & Version Control: Git, Azure DevOps, TFS, ClearCase, SVN, CVS.
- Tools & Platforms: Scheduling (Control M, Airflow, TWS), Agile/ITSM (Jira, ServiceNow), OS (Linux, Windows).
- Certifications: SnowPro Certified – Snowflake.
Employment Type:
C2C
Location:
Rockefeller Centre, NY (Onsite)
Special Requirements
Onsite role. Requires SnowPro Certified – Snowflake. Experience with Azure DevOps/Git for CI/CD.
Compensation & Location
Salary: $100,000 – $150,000 per year (Estimated)
Location: New York, NY
Recruiter / Company – Contact Information
Recruiter / Employer: Tanisha Systems, Inc
Email: dosh@tanishasystems.com
Recruiter Notice:
To remove this job posting, please send an email from
dosh@tanishasystems.com with the subject:
DELETE_JOB_ID_7184