SnowPro Advanced: Architect or SnowPro Core certification is mandatory

Loc : Noida (Hybrid) / Remote
Notice : 30 days or less

Key Responsibilities
- Lead the architecture, assessment, and modernization of enterprise Snowflake data platforms.
- Define current-state and target-state architectures across data ingestion, transformation, storage, orchestration, governance, security, and consumption.
- Lead inventories and assessments of Python-, SQL-, and stored-procedure-based pipelines, classifying workloads by business criticality, frequency, volume, runtime, reliability, and cost.
- Analyze Snowflake usage telemetry to establish cost and performance baselines across pipelines, warehouses, and workloads.
- Identify architectural and engineering anti-patterns, including procedural row-by-row processing, unnecessary full refreshes, missing incremental patterns, redundant transformations, warehouse mis-sizing, and insufficient workload isolation.
- Recommend modernization strategies using set-based processing, incremental data patterns, Energetic Tables, Streams and Tasks, Snowpark,



dbt, and appropriate orchestration technologies.
- Design scalable data models, governed data domains, semantic layers, and context models that support analytics and AI use cases.
- Architect Snowflake Cortex solutions using capabilities such as Cortex Analyst, Cortex Search, and Cortex LLM functions.
- Establish architectural standards for security, access control, data governance, lineage, observability, performance, resilience, and business continuity.
- Design data lakehouse and real-time data-processing architectures across AWS, Azure, or GCP.
- Evaluate and recommend appropriate use of Snowflake Iceberg Tables and other open data architecture patterns.
- Build prioritized optimization backlogs and sequenced delivery roadmaps based on business impact, technical risk, cost, performance, and implementation effort.
- Provide technical leadership across multiple concurrent projects and guide

📌 Data Architect (Uttar Pradesh)
🏢 Birchtree Consulting
📍 Uttar Pradesh