Role Summary
The technical anchor of the engagement. Owns the end-to-end target-state architecture the medallion designs the silver/gold layer strategy and the narrative that ties platform capability decisions together into a single coherent roadmap and white paper.

Key Responsibilities
Lead the current-state architecture review of Snowflake SAP integration and the bronze/raw ingestion layer.
Design the target-state medallion architecture including silver conformance standards and gold data-product patterns.
Streams & Tasks, Energetic Tables (for automating silver-layer refresh without hand-rolled orchestration)
Snowpark (Python/Java/Scala) for transformation logic embedded in-platform
Snowflake Cortex (LLM functions, Cortex Search/vector embeddings)- the architect needs to know how gold products get consumed by RAG pipelines or agents
Time Travel, zero-copy cloning, secure data sharing used in the reference-pattern build and in designing non-disruptive silver/gold rollout
Should be capable enough to evaluate the pattern (SAP CDC approaches:



SLT (SAP Landscape Transformation), SAP Datasphere/BW connectors, ODP-based extraction, or third-party CDC tools (Qlik Replicate, HVR/Fivetran)) that fits customers actual SAP landscape
dbt (or Coalesce/Matillion) for silver/gold transformation pipelines
Azure Data Factory or Airflow for cross-system orchestration
Facilitate architecture and whiteboarding workshops with Clients data architecture and platform stakeholders.
Own the technical narrative of the white paper and roadmap ensuring consistency across all workstreams' inputs.
Direct-line collaborate with the Cloud & Platform Architect and Governance/MDM Consultant to keep platform-capability recommendations coherent.
Guide the reference-pattern build for the 1–2 priority domains from an architecture st and point.

Required Experience & Skills
12+ years in data architecture including at least one full lifecycle as "head of data platform/data lake"

📌 Lead Enterprise Data Architect Chennai (India)
🏢 Ciliconchip
📍 India