Data Architect

StackStudio Digital Ltd.
Uxbridge, United Kingdom
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Uxbridge, United Kingdom

Tech stack

Query Performance
Third Normal Form
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Cloud Database
Databases
Data Architecture
Information Engineering
Data Governance
ETL
Data Security
Data Systems
Data Vault Modeling
Data Warehousing
Database Queries
Identity and Access Management
Python
Performance Tuning
Data Streaming
Snowflake
Electronic Medical Records
Collibra
Amazon Web Services (AWS)
Functional Programming
Cloudwatch
Data Pipelines

Job description

  • 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., (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

Requirements

  • 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

Apply for this position