Haystack
← Back to Jobs
Technology
AT

Senior Data Architect Snowflake & PostgreSQL | Contract | New York, NY Hybrid

Anagha Techno SoftNew York, NY🇺🇸United StatesPosted 11 Sept 2026

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
New York, NY, United States
Posted
21 hours ago
AWSMachine LearningSnowflakeAnsibleApacheApache SparkAzureDatabricksGenerative AIPostgreSQLPower BIPythonTerraform

Job Description

Senior Data Architect Snowflake & PostgreSQL | Contract | New York, NY Hybrid
Senior Data Architect Snowflake & PostgreSQL
Location: New York, NY Hybrid (3 days Onsite) - Local Or near by candidates preferred
Duration: 12 Months
Job Type: Contract
Job Summary
We are seeking an experienced Senior Data Architect with strong expertise in Snowflake, PostgreSQL, cloud data platforms, data architecture, and performance optimization.
The ideal candidate will have a strong background in designing and deploying enterprise-scale data platforms across cloud and on-premises environments. This role will focus on data architecture, schema and data modeling, database performance, automation, data governance, and enabling advanced analytics and AI/ML capabilities.
Key Responsibilities
  • Design and architect large-scale data platforms using Snowflake and PostgreSQL.
  • Lead database and data-platform architecture across hybrid and cloud environments.
  • Develop scalable solutions for data ingestion, processing, transformation, and curation.
  • Design enterprise data models, schemas, and architecture patterns for structured and unstructured data.
  • Drive database and query performance optimization.
  • Develop automation frameworks for provisioning, monitoring, scaling, and operational management.
  • Collaborate with data engineering, application, platform, security, and analytics teams.
  • Establish best practices for data governance, quality, security, compliance, and lifecycle management.
  • Design high-availability, backup, disaster recovery, and multi-region strategies.
  • Support modernization initiatives involving cloud-native data platforms and serverless technologies.
  • Architect solutions supporting business intelligence, analytics, machine learning, and generative AI use cases.
  • Design and support RAG, vector search, and AI-enabled data solutions.
  • Evaluate emerging data technologies, platforms, knowledge graphs, and data-fabric capabilities.
  • Provide technical leadership and mentor engineering teams.
  • Communicate architectural decisions and technical strategy to senior stakeholders.
Required Qualifications
  • 10+ years of experience in data architecture, data engineering, database architecture, or a related field.
  • Strong hands-on expertise with Snowflake and PostgreSQL.
  • Experience with database administration, architecture, performance tuning, and query optimization.
  • Strong understanding of enterprise data warehouse architecture and data modeling.
  • Experience with AWS and/or Azure cloud environments.
  • Strong scripting and automation skills using Python, Ansible, Terraform, or similar technologies.
  • Experience designing scalable and highly available data platforms.
  • Strong understanding of data governance, data quality, security, and compliance.
  • Experience working with structured and unstructured data.
  • Experience integrating data platforms with analytics, BI, and AI/ML solutions.
  • Strong communication, problem-solving, collaboration, and leadership skills.
  • Bachelor's degree in Computer Science, Engineering, Information Technology, or a related discipline.
Preferred Qualifications
  • Experience with Snowflake Cortex, Cortex Analyst, Cortex Search, Snowpark, Snowflake ML, or Snowpark Container Services.
  • Experience with RAG, vector databases/vector search, Azure AI Search, or generative AI.
  • Experience with Databricks, Apache Spark, Talend, Power BI, or Microsoft Fabric.
  • Experience with knowledge graphs and modern data-fabric architectures.
  • Experience with transactional data and AI/ML workloads.
  • Experience in large-scale, regulated enterprise environments.
  • Experience leading cloud modernization and data-platform transformation initiatives.
Required Skills
Snowflake | PostgreSQL | Data Architecture | Data Modeling | AWS/Azure | Data Warehouse | Performance Tuning | Python | Automation | Data Governance | Databricks | Spark | RAG | Vector Search | AI/ML

Similar jobs

Browse related jobs

Apply now