Lead Data Architect – Snowflake Specialist

About the role

We are looking for a Lead Data Architect with deep Snowflake expertise to design, build, and optimise enterprise‑grade data platforms. The role will drive end‑to‑end data solutions, mentor engineering teams, and ensure data security and governance across multiple business units.

Key responsibilities

• Design and implement scalable, secure, cost‑effective Snowflake architectures, including data models, warehouses and lakehouse integrations.
• Develop and optimise complex SQL queries, ETL/ELT pipelines, and near‑real‑time data flows using tools such as dbt, Airflow or Matillion.
• Lead technical design reviews, troubleshoot performance issues, and mentor data engineers on best practices, CI/CD and automation.
• Collaborate with stakeholders to translate business requirements into robust technical solutions and maintain architecture documentation.

Required profile

• 9+ years of experience in data warehousing, cloud data platforms and enterprise data solutions.
• Strong hands‑on experience with Snowflake architecture, administration and SnowPro (or equivalent) certification.
• Proven track record delivering large‑scale Snowflake migration projects and working in Agile environments.

Required skills

• Snowflake, SnowPro Advanced certification, Snowpark, SQL, Python.
• Cloud platforms: AWS, Azure, GCP.
• Data orchestration tools: dbt, Airflow, Matillion, Informatica.
• Version control and CI/CD: Git, automated deployments.
• Data governance, security, role‑based access, data masking, data quality frameworks.