Lead Enterprise Data Architect

Ciliconchip · India

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, Dynamic 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" spanning both build and run responsibility.
• Deep h ands-on experience designing medallion/Lakehouse architectures on Snowflake at enterprise scale.
• Experience integrating SAP-sourced data into a modern cloud data platform.
• Familiarity with AI/agent data-consumption patterns and what "AI-ready" data requires operationally.

Qualifications & Certifications (preferred)

• SnowPro Advanced Architect (or equivalent Snowflake certification).
• Azure or relevant cloud architecture certification (e.g. Azure Solutions Architect Expert).
• TOGAF or equivalent enterprise architecture certification is a plus.