Snowflake LeadArchitect with Cortex AI NYC, NY (Onsite) Contract
Share
Job Location:
New York City, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Role: Snowflake Lead/Architect with Cortex AI
Location: New York City NY - Onsite
Long Term Contract
- Need someone with prior experience of migration from any legacy system into Snowflake.
- Python SQL ML experience required
- Snowflake Cortex AI is MUST-TO-HAVE
A Snowflake Lead/Architect is a senior data professional who designs and oversees the implementation of enterprise-grade data platforms using the Snowflake Data Cloud. This role combines technical leadership with deep hands-on expertise to build scalable secure and high-performance data solutions that support analytics data science and business intelligence initiatives.
Role and responsibilities
- Architect and design solutions: Lead the design and implementation of end-to-end data warehousing and analytics solutions on the Snowflake platform. This includes defining architectural standards data models and ETL/ELT pipeline designs.
- Technical leadership: Act as a subject matter expert and provide technical guidance to data engineering teams. Drive best practices for code reviews testing documentation and overall quality assurance.
- Data pipeline development: Oversee the development and optimization of robust data pipelines using Snowflake Snowpipe Snowpark and tools like DBT Python and Airflow.
- Performance optimization: Monitor and tune Snowflake performance to ensure scalability reliability and cost-effectiveness. This involves managing virtual warehouses storage layers and optimizing queries.
- Data governance and security: Define and enforce standards for data governance security and compliance within Snowflake. Implement features like object tagging data masking row-level security and data clean rooms.
- Stakeholder collaboration: Work closely with business stakeholders data analysts and other technical teams to translate business requirements into technical solutions.
- Innovation and evangelism: Stay current with Snowflake features and industry trends. Advocate for and guide the adoption of new capabilities potentially acting as a technical evangelist for the platform.
- Migration strategy: For migrations the architect designs and leads the strategy to move data from legacy platforms to Snowflake.
Essential skills and qualifications
- Experience:
- Significant experience (typically 8 10 years) in data warehousing data engineering and solution architecture with a minimum of 3 5 years focused specifically on Snowflake.
- Experience in a technical leadership or mentoring role.
- Technical expertise:
- Deep knowledge of Snowflakes architecture including virtual warehouses data storage and security features.
- Proficiency in Snowflake SQL scripting and stored procedures.
- Extensive experience with ETL/ELT processes and tools like DBT Airflow and Python.
- Familiarity with major cloud platforms (AWS Azure GCP) and how Snowflake integrates with their services.
- Strong understanding of data modeling techniques (e.g. star schema data vault).
- Soft skills:
- Excellent communication and presentation skills to effectively interact with both technical and non-technical audiences.
- Strong analytical and problem-solving abilities.
- Demonstrated ability to lead projects and collaborate with cross-functional teams.
- Education and certifications:
- A bachelors degree in Computer Science Information Technology or a related field is typically required.
- Relevant Snowflake certifications such as the SnowPro Advanced: Architect Certification are often preferred.
Key Skills
- Experience Working With Students
- Google Docs
- Organizational skills
- Classroom Experience
- Data Collection
- Materials Handling
- Workers' Compensation Law
- OSHA
- Special Operations
- Team Management
- Experience with Children
- Supervising Experience
