Loc : Noida (Hybrid)

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, Agile 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 engineers, analysts, QA specialists, and DevOps teams.
- Support project planning, estimation, scope defi

📌 Snowflake Data Architect (Noida)
🏢 Birch Tree Consulting
📍 Noida