Job Title: Snowflake Architect
Location: New York City NY (Locals Only Onsite)
Type: Contract
Experience Level: 10 Years
Job Summary:
We are seeking a highly skilled Snowflake Architect based in New York City to lead the design implementation and optimization of our Snowflake data platform. This role requires a deep understanding of data warehousing cloud platforms and Snowflake architecture best practices. The ideal candidate must be local to NYC and available to work onsite (hybrid setup if needed).
Key Responsibilities:
- Lead the architecture design and deployment of scalable and secure Snowflake solutions.
- Collaborate with data engineers analysts and business stakeholders to define technical requirements.
- Develop and optimize data pipelines for ingestion and transformation using Snowflake and related tools.
- Implement performance tuning and workload management strategies in Snowflake.
- Drive data governance security and compliance standards in Snowflake.
- Design data models for analytics reporting and machine learning.
- Integrate Snowflake with various ETL/ELT tools APIs and BI platforms.
- Mentor junior team members and lead data architecture reviews.
Required Skills & Experience:
- 10 years of experience in data engineering cloud data architecture or similar roles.
- 5 years of hands-on experience architecting solutions on Snowflake.
- Strong expertise in SQL performance tuning and cost optimization within Snowflake.
- Experience with ETL/ELT tools like DBT Informatica Talend Apache Airflow etc.
- Knowledge of data modeling (dimensional star/snowflake schema) and metadata management.
- Proficiency in cloud platforms (AWS Azure or GCP) with integration experience.
- Familiarity with Python Scala or Spark for data transformation tasks.
- Solid understanding of CI/CD pipelines version control and DevOps in a data context.
- Strong knowledge of data security RBAC and compliance best practices.
Nice to Have:
- Snowflake certification (SnowPro Core or Advanced Architect).
- Experience integrating Snowflake with Power BI Tableau or Looker.
- Background in financial services or Banking domains is a plus.