

New York Technology Partners
Data Architec
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Architect on a long-term contract in New York (Hybrid), offering a competitive pay rate. Requires 8+ years in data architecture, strong Snowflake expertise, SQL proficiency, and experience in regulated industries.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
Unknown
-
ποΈ - Date
May 23, 2026
π - Duration
Unknown
-
ποΈ - Location
Hybrid
-
π - Contract
Unknown
-
π - Security
Unknown
-
π - Location detailed
New York, United States
-
π§ - Skills detailed
#dbt (data build tool) #Data Engineering #Snowpark #Data Governance #Data Warehouse #Data Pipeline #SaaS (Software as a Service) #Batch #Disaster Recovery #"ETL (Extract #Transform #Load)" #Airflow #Fivetran #Storage #Data Vault #Physical Data Model #BI (Business Intelligence) #Python #Leadership #Data Modeling #Cloud #Spark (Apache Spark) #Azure #Data Architecture #ML (Machine Learning) #AI (Artificial Intelligence) #GDPR (General Data Protection Regulation) #Computer Science #GCP (Google Cloud Platform) #Dimensional Modelling #SQL (Structured Query Language) #Data Lake #Migration #Snowflake #Matillion #Scala #Databases #Security #Compliance #Replication #AWS (Amazon Web Services) #Vault #Java #Kafka (Apache Kafka) #Data Processing
Role description
π Hiring: Data Architectβ New York / Hybrid
We are looking for an experienced Data Architect to lead the design and implementation of scalable, high-performance Snowflake-based data platforms supporting analytics, BI, and AI/ML initiatives.
πRole: Data Architect
πType: Long Term Contract
πLocation: New York / Hybrid
πInterview: Face To Face
π οΈ Key Responsibilities
β’ Lead end to end data architecture and solution design for Snowflake based data platforms including logical physical data models ingestion patterns batch streaming.
β’ Snow pipe storage layers raw curated consumption semantic and consumption patterns for analytics BI and AIML Design and optimize scalable high performance data warehouses data lakes and lakehouse architectures on Snowflake focusing on performance tuning query optimization cost management.
β’ Workload warehouse strategies and auto scaling Architect and implement AI powered solutions using Snowflake Cortex including Cortex LLM functions Cortex Search for semantic vector.
β’ RAG capabilities Cortex Analyst for conversational analytics Document AI and integration with external LLMs eg for fine-tuning agents and multimodal data processing.
β’ Define and enforce data governance security and compliance frameworks RBAC row column access policies dynamic data masking encryption secure data sharing and private listings.
β’ Design data pipelines integrating with various sources onprem cloud SaaS and orchestration tools implement real time capabilities using Streams Tasks and Snow park Python Scala Java Collaborate with data engineers analysts scientists and business stakeholders to deliver governed reusable data products that accelerate analytics and AI initiatives Provide technical leadership in migrations to Snowflake from legacy systems eg on prem warehouses other clouds and establish reference architectures patterns and standards Monitor platform health optimize for cost performance and implement disaster recovery replication and high availability strategies Mentor junior architects and engineers conduct design reviews and promote best practices in data modelling eg Data Vault Kimball or hybrid semantic modelling and Already data foundations Required.
Qualifications
β’ 8 years of experience in data architecture data engineering or data platform roles with at least 4 years specifically designing and optimizing solutions on Snowflake Deep expertise in Snowflake features warehouses resource monitors zerocopy cloning.
β’ Time Travel data sharing Snowpark TasksStreams and securitygovernance controls Strong proficiency in SQL data modeling conceptual logical physical ETL/ELT patterns and cloud data platforms.
β’ AWS Azure or GCP Proven experience designing secure scalable architectures for analytics reporting and machine learning workloads Solid understanding of data governance quality lineage and compliance eg GDPR SOC2 HIPAA if applicable .
Education
Bachelors or Masters Degree in Computer Science Information Systems Engineering or a related field or equivalent experience
Key Skills
β’ Excellent communication stakeholder management and leadership skills Preferred Skills and Experience.
β’ Hands-on experience with Snowflake Cortex AI capabilities Cortex Search Cortex Analyst LLM functions vector embedding RAG patterns and building AI agents or applications within Snowflake Snow Pro Core Advanced or Architect certifications.
β’ Experience with modern data stack tools dbt Airflow Kafka Spark Fivetran Matillion or similar Knowledge of AIML workflows vector databases semantic search and integrating structured unstructured data for generative AI Background in Data Vault 20 dimensional modelling or domain driven design Experience in regulated industries finance healthcare pharma or largescale enterprise environments is a plus.
π© Interested or open to new opportunities?
Please send your updated resume with contact details to vikas@nytpcorp.com
Thanks and Regards
Vikas Mahindrakar
π Direct: 201-604-3998
New York Technology Partners
120 Wood Avenue S | Suite 504 | Iselin, NJ 08830
π Hiring: Data Architectβ New York / Hybrid
We are looking for an experienced Data Architect to lead the design and implementation of scalable, high-performance Snowflake-based data platforms supporting analytics, BI, and AI/ML initiatives.
πRole: Data Architect
πType: Long Term Contract
πLocation: New York / Hybrid
πInterview: Face To Face
π οΈ Key Responsibilities
β’ Lead end to end data architecture and solution design for Snowflake based data platforms including logical physical data models ingestion patterns batch streaming.
β’ Snow pipe storage layers raw curated consumption semantic and consumption patterns for analytics BI and AIML Design and optimize scalable high performance data warehouses data lakes and lakehouse architectures on Snowflake focusing on performance tuning query optimization cost management.
β’ Workload warehouse strategies and auto scaling Architect and implement AI powered solutions using Snowflake Cortex including Cortex LLM functions Cortex Search for semantic vector.
β’ RAG capabilities Cortex Analyst for conversational analytics Document AI and integration with external LLMs eg for fine-tuning agents and multimodal data processing.
β’ Define and enforce data governance security and compliance frameworks RBAC row column access policies dynamic data masking encryption secure data sharing and private listings.
β’ Design data pipelines integrating with various sources onprem cloud SaaS and orchestration tools implement real time capabilities using Streams Tasks and Snow park Python Scala Java Collaborate with data engineers analysts scientists and business stakeholders to deliver governed reusable data products that accelerate analytics and AI initiatives Provide technical leadership in migrations to Snowflake from legacy systems eg on prem warehouses other clouds and establish reference architectures patterns and standards Monitor platform health optimize for cost performance and implement disaster recovery replication and high availability strategies Mentor junior architects and engineers conduct design reviews and promote best practices in data modelling eg Data Vault Kimball or hybrid semantic modelling and Already data foundations Required.
Qualifications
β’ 8 years of experience in data architecture data engineering or data platform roles with at least 4 years specifically designing and optimizing solutions on Snowflake Deep expertise in Snowflake features warehouses resource monitors zerocopy cloning.
β’ Time Travel data sharing Snowpark TasksStreams and securitygovernance controls Strong proficiency in SQL data modeling conceptual logical physical ETL/ELT patterns and cloud data platforms.
β’ AWS Azure or GCP Proven experience designing secure scalable architectures for analytics reporting and machine learning workloads Solid understanding of data governance quality lineage and compliance eg GDPR SOC2 HIPAA if applicable .
Education
Bachelors or Masters Degree in Computer Science Information Systems Engineering or a related field or equivalent experience
Key Skills
β’ Excellent communication stakeholder management and leadership skills Preferred Skills and Experience.
β’ Hands-on experience with Snowflake Cortex AI capabilities Cortex Search Cortex Analyst LLM functions vector embedding RAG patterns and building AI agents or applications within Snowflake Snow Pro Core Advanced or Architect certifications.
β’ Experience with modern data stack tools dbt Airflow Kafka Spark Fivetran Matillion or similar Knowledge of AIML workflows vector databases semantic search and integrating structured unstructured data for generative AI Background in Data Vault 20 dimensional modelling or domain driven design Experience in regulated industries finance healthcare pharma or largescale enterprise environments is a plus.
π© Interested or open to new opportunities?
Please send your updated resume with contact details to vikas@nytpcorp.com
Thanks and Regards
Vikas Mahindrakar
π Direct: 201-604-3998
New York Technology Partners
120 Wood Avenue S | Suite 504 | Iselin, NJ 08830




