Job Description

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.