Data Architect

JOB DESCRIPTION

Key Responsibilities Lead endtoend data architecture and solution design for Snowflakebased data platforms including logicalphysical data models ingestion patterns batch streaming Snowpipe storage layers raw curated consumptionsemantic and consumption patterns for analytics BI and AIML Design and optimize scalable highperformance data warehouses data lakes and lakehouse architectures on Snowflake focusing on performance tuning query optimization cost management workloadwarehouse strategies and autoscaling Architect and implement AIpowered solutions using Snowflake Cortex including Cortex LLM functions Cortex Search for semanticvectorRAG capabilities Cortex Analyst for conversational analytics Document AI and integration with external LLMs eg for finetuning agents and multimodal data processing Define and enforce data governance security and compliance frameworks RBAC rowcolumn 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 realtime capabilities using Streams Tasks and Snowpark PythonScalaJava 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 onprem warehouses other clouds and establish reference architectures patterns and standards Monitor platform health optimize for costperformance and implement disaster recovery replication and highavailability strategies Mentor junior architects and engineers conduct design reviews and promote best practices in data modeling eg Data Vault Kimball or hybrid semantic modeling and AIready 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 ETLELT 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 eg

GDPR SOC2 HIPAA

if applicable Bachelors or Masters 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 Handson 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 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 structuredunstructured data for generative AI Background in Data Vault 20 dimensional modeling or domaindriven design Experience in regulated industries finance healthcare pharma or largescale enterprise environments is a plus