What are the responsibilities and job description for the Data Architect With Snowflake Cortex & AI Exp in VA,GA,NY (Onsite/Hybrid) position at Caliber Smart?
Role: Data Architect With Snowflake Cortex & AI Exp in VA,GA,NY
Location: Arlington, VA / Alpharetta, GA / New York, NY (Onsite/Hybrid)
Employment Type: Full-Time
About The Role
Client is seeking a highly experienced Snowflake Data Architect with expertise in Snowflake Cortex, AI-powered analytics, and modern cloud data platforms. This role will be responsible for designing and leading enterprise-scale data architectures that support advanced analytics, AI/ML initiatives, and data-driven business transformation.
The ideal candidate will bring a combination of data architecture leadership, Snowflake platform expertise, cloud data engineering knowledge, and AI integration experience, enabling organizations to build secure, scalable, and intelligent data ecosystems.
Key Responsibilities
Data Architecture & Platform Design
Snowflake & AI
Experience With
Location: Arlington, VA / Alpharetta, GA / New York, NY (Onsite/Hybrid)
Employment Type: Full-Time
About The Role
Client is seeking a highly experienced Snowflake Data Architect with expertise in Snowflake Cortex, AI-powered analytics, and modern cloud data platforms. This role will be responsible for designing and leading enterprise-scale data architectures that support advanced analytics, AI/ML initiatives, and data-driven business transformation.
The ideal candidate will bring a combination of data architecture leadership, Snowflake platform expertise, cloud data engineering knowledge, and AI integration experience, enabling organizations to build secure, scalable, and intelligent data ecosystems.
Key Responsibilities
Data Architecture & Platform Design
- Lead end-to-end architecture and solution design for Snowflake-based data platforms.
- Design logical, physical, and semantic data models supporting analytics, reporting, and AI/ML workloads.
- Architect data ingestion frameworks utilizing batch, streaming, Snowpipe, and ELT/ETL methodologies.
- Design and implement scalable data warehouses, data lakes, and lakehouse architectures.
- Optimize platform performance through warehouse strategy, query tuning, workload management, autoscaling, and cost optimization.
- Establish enterprise-grade governance frameworks covering:
- RBAC (Role-Based Access Control)
- Dynamic Data Masking
- Row & Column-Level Security
- Encryption & Secure Data Sharing
- Data Lineage and Compliance Controls
- Implement disaster recovery, replication, and high-availability solutions.
- Architect and implement AI-powered solutions using:
- Snowflake Cortex LLM Functions
- Cortex Search
- Cortex Analyst
- Document AI
- Vector Embeddings & Semantic Search
- Retrieval-Augmented Generation (RAG) Architectures
- Integrate Snowflake with external LLMs and AI platforms to support:
- Conversational Analytics
- AI Agents
- Fine-Tuning Workflows
- Multimodal Data Processing
- Design scalable pipelines integrating cloud, on-premises, and SaaS data sources.
- Implement real-time and event-driven architectures using:
- Snowpark
- Streams & Tasks
- Kafka
- Spark
- Airflow
- Enable governed, reusable data products for analytics and AI consumption.
- Lead migrations from legacy data warehouses and cloud platforms to Snowflake.
- Define architecture standards, best practices, and reference frameworks.
- Mentor architects and engineers on data modeling methodologies including:
- Data Vault 2.0
- Kimball Dimensional Modeling
- Hybrid Semantic Modeling
- Conduct architecture reviews and guide enterprise data strategy initiatives.
- 8 years of experience in Data Architecture, Data Engineering, or Enterprise Data Platforms.
- 4 years of hands-on experience designing and optimizing Snowflake solutions.
- Deep expertise with Snowflake capabilities including:
- Virtual Warehouses
- Resource Monitors
- Time Travel
- Zero-Copy Cloning
- Data Sharing
- Snowpark
- Streams & Tasks
- Security & Governance Controls
- Strong proficiency in:
- SQL
- Data Modeling (Conceptual, Logical, Physical)
- ETL/ELT Architecture
- Cloud Platforms (AWS, Azure, or GCP)
- Experience designing secure and scalable architectures for:
- Analytics
- Reporting
- Data Science
- Machine Learning
- Strong understanding of:
- Data Governance
- Data Quality
- Metadata Management
- Compliance Frameworks (GDPR, SOC2, HIPAA)
- Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).
- Excellent communication, stakeholder management, and leadership skills.
Snowflake & AI
- Hands-on experience with:
- Snowflake Cortex Search
- Cortex Analyst
- Cortex LLM Functions
- Vector Databases & Embeddings
- RAG Implementations
- AI Agent Development
- SnowPro Certifications:
- SnowPro Core
- SnowPro Advanced
- SnowPro Architect
Experience With
- dbt
- Apache Airflow
- Kafka
- Apache Spark
- Fivetran
- Matillion
- Similar modern data engineering tools
- AI/ML Operations and Generative AI Workflows
- Semantic Search and Knowledge Retrieval Architectures
- Domain-Driven Design
- Data Vault 2.0
- Enterprise Data Governance Programs
- Experience within Financial Services, Healthcare, Pharmaceutical, or other regulated industries