Haystack
← Back to Jobs
Technology

Snowflake Data Architect

Hierarch Soft Technologies, Inc.New York, NY🇺🇸United StatesPosted 11 Aug 2026

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

 
Hi,

We have an exciting opportunity with our client for the below role. If you are interested, please share your updated resume at .

Position: Data/Snowflake Architect

Location: NYC, NY (3 days onsite is must)

Duration: 12 Months

We are seeking an experienced Data Architect to join our Assurance & Legal Technology department overseeing Snowflake/Postgres distributed database platform deployments. This role involves comprehensive data analysis, data schematic design, performance tuning, and leveraging modern technologies to source, sanitize, and curate data into a gold data source for advanced analytics and reporting. You will play a key role in driving modernization, automation, and performance optimization across our Cloud/On-Prem data-platform ecosystem.

 
The client is looking for a senior Data Architect / Data Platform Architect who can combine Snowflake + PostgreSQL architecture/administration + cloud + data engineering + governance + AI/GenAI architecture.

Qualifications

• Minimum 10 years of recent experience in data architecture, data engineering, or a similar field.

• Hands-on expertise with PostgreSQL and Snowflake administration and performance tuning. 

• Strong scripting and automation skills (Python, Ansible, etc.). 

• Familiar with Cloud Based Architectures /Data-Warehousing Platforms, prior experience / knowledge in Snowflake Design Patterns and migration workflow would be a plus.

• Prior exposure building ML and generative AI solutions using Snowflake Cortex Analyst, Search, AI SQL, Snowflake ML, and Snowpark Container Services.

• Proven record of architecting and delivering large-scale data warehouse modeling and reporting solutions for enterprise systems.

• A bachelor’s degree from an accredited college or university is required. A master''s degree in computer science, engineering, or a related technical discipline is preferred.

• Expertise in architecting cloud-native data ecosystems using platforms such as Snowflake, Databricks, Talend, SPARK, Power BI, and Microsoft Fabric.

• Deep knowledge of designing solutions that incorporate Retrieval-Augmented Generation (RAG) and vector search (e.g., Azure AI Search).

• In-depth understanding of architectural patterns for processing and modeling both structured transactional data and unstructured information.

• Experience with transactional processing and AI/ML applications.

• Demonstrated experience defining architectural principles, data governance policies, and technology standards within a large-scale, regulated, and Agile Software Development Life Cycle (SDLC) environment.

• Exceptional problem-solving, communication, collaboration and leadership skills.

• Ability to articulate strategic technical vision, influence executive-level stakeholders, and guide solutions for complex business problems.

Skills

SQL
Snowflake
Agile
Ansible
Azure
Databricks
Generative AI
PostgreSQL
Power BI
Python

Similar jobs