Job Description Role Details Job Title: Data Architect Location: Heathrow (2 to 3days) Duration of the Assignment: 6 Months Job Purpose and Primary Objectives Design and evolve data architecture aligned with business, analytical, and engineering needs. Lead end to end architecture for cloud native data solutions on AWS. Define standards, patterns, and best practices for data modelling, data flows, and platform usage. Develop scalable Snowflake based data architectures including warehouses, databases, schemas, roles, and secure data sharing. Key Responsibilities (Please specify if the position is an individual one or part of a team) Architect and optimize ETL/ELT pipelines using services such as: DBT, AWS Glue, Lambda, Kinesis, S3, EMR Design high performance Snowflake data models (3NF, dimensional, Data Vault, etc.) Optimize query performance, clustering, micro-partitioning, and resource consumption Work closely with Data Engineers, Analysts, Product Managers, and Business Stakeholders Provide architectural guidance and mentorship across data and engineering teams Translate business needs into scalable data solutions Key Skills / Knowledge Strong grasp of data modelling, data warehousing concepts and performance optimization techniques Hands on expertise with Snowflake (architecture, performance tuning, security, Snowpipe, streams/tasks) Strong experience with AWS cloud data ecosystem, ideally including: S3, Glue, Lambda, Redshift, EMR, Kinesis, IAM, CloudWatch Strong SQL skills and proficiency in Python, DBT Understanding of data governance frameworks (e.g., Collibra, Alation is a plus) Hands-on exposure to cloud platforms, especially AWS Experience working in agile teams Experience Required 6 years in Data Architecture, Data Engineering, and related fields with a similar remit to the descriptions here 2 years' experience working as an independent contractor