Data Architect – Snowflake

About the role

We are looking for a hands‑on Data Engineering Lead to own the design, development and optimisation of enterprise‑scale Snowflake data platforms. You will act as the primary Snowflake technical authority, guiding project teams and establishing best‑in‑class engineering practices.

Key responsibilities

• Lead the end‑to‑end delivery of scalable Snowflake solutions for enterprise clients.
• Define account strategy, database/schema hierarchy, virtual‑warehouse sizing and multi‑cluster configurations.
• Implement medallion (Bronze‑Silver‑Gold) architecture aligned with business data domains.
• Design batch, real‑time and CDC ingestion pipelines from sources such as SAP, Salesforce, MuleSoft, Boomi, REST APIs, event streams and flat files.
• Configure Snowflake stages using Azure Data Lake Storage, AWS S3 or Google Cloud Storage.
• Establish security and governance (RBAC, row/column policies, secure data sharing).
• Manage environments with Time Travel and Zero‑Copy Cloning for dev, test and sandbox.
• Develop transformation frameworks with Snowflake SQL, Snowpark (Python) and modern ELT patterns.
• Leverage Snowflake Cortex AI for ML use cases and expose curated datasets for Power BI, Tableau and Sigma.
• Monitor performance, optimise workloads and control costs across Snowflake environments.

Required profile

• 8+ years of hands‑on experience in data engineering, warehousing or platform engineering.
• Minimum 3 years administering Snowflake in production.
• Proven delivery of at least two full‑cycle Snowflake implementations.
• Strong background in data modelling, ELT/ETL design and cloud‑native architecture.
• Experience with CDC, event‑driven pipelines and integration of ERP (preferably SAP) and iPaaS solutions.
• Solid understanding of Snowflake security, governance and cost‑management features.

Required skills

• Snowflake
• SQL
• Python (including Snowpark)
• Azure Data Lake Storage, AWS S3, Google Cloud Storage
• SAP (ODP, CDS Views, connectors)
• Salesforce, MuleSoft, Boomi
• REST APIs, event streams, CDC
• Power BI, Tableau, Sigma