Job Description
Role Summary
nThe 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.
nKey Responsibilities
n
n
Lead the current-state architecture review of Snowflake SAP integration and the bronze/raw ingestion layer.n
Design the target-state medallion architecture including silver conformance standards and gold data-product patterns.n
Streams & Tasks, Agile Tables (for automating silver-layer refresh without hand-rolled orchestration)n
Snowpark (Python/Java/Scala) for transformation logic embedded in-platformn
Snowflake Cortex (LLM functions, Cortex Search/vector embeddings)- the architect needs to know how gold products get consumed by RAG pipelines or agentsn
Time Travel, zero-copy cloning, secure data sharing used in the reference-pattern build and in designing non-disruptive silver/gold rolloutn




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 landscapen
dbt (or Coalesce/Matillion) for silver/gold transformation pipelinesn
Azure Data Factory or Airflow for cross-system orchestrationn
Facilitate architecture and whiteboarding workshops with Clients data architecture and platform stakeholders.n
Own the technical narrative of the white paper and roadmap ensuring consistency across all workstreams' inputs.n
Direct-line collaborate with the Cloud & Platform Architect and Governance/MDM Consultant to keep platform-capability recommendations coherent.n
Guide the reference-pattern build for the 1–2 priority domains from an architecture st and point.n

nRequired Experience & Skills
n
n
12+ years in data architecture including a

📌 Lead Enterprise Data Architect Tamil Nadu
🏢 Ciliconchip
📍 Tamil Nadu