Data Architect

Hi,

Title – Data Architect

Location – NY ( Hybrid 3 days onsite)

12+ Months

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 AI/ML.

• 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 (e.g., 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 (on-prem, cloud, SaaS) and orchestration tools; implement real-time capabilities using Streams, Tasks, and Snowpark (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 (e.g., 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 modeling (e.g., Data Vault, Kimball, or hybrid), semantic modeling, and AI-ready 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, zero-copy cloning, Time Travel, data sharing, Snowpark, Tasks/Streams, and security/governance controls.

• Strong proficiency in SQL, data modeling (conceptual, logical, physical), ETL/ELT patterns, and cloud data platforms (AWS, Azure, or Google Cloud Platform).

• Proven experience designing secure, scalable architectures for analytics, reporting, and machine learning workloads.

• Solid understanding of data governance, quality, lineage, and compliance (e.g., GDPR, SOC2, HIPAA if applicable).

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).

• 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 embeddings, RAG patterns, and building AI agents or applications within Snowflake).

• SnowPro Core, Advanced, or Architect certification(s).

• Experience with modern data stack tools: dbt, Airflow, Kafka, Spark, Five Tran, Matillion, or similar.

• Knowledge of AI/ML workflows, vector databases, semantic search, and integrating structured/unstructured data for generative AI.

• Background in Data Vault 2.0, dimensional modeling, or domain-driven design.

• Experience in regulated industries (finance, healthcare, pharma) or large-scale enterprise environments is a plus.