Data Architect (Snowflake)
AND Digital3 days ago
London, United KingdomSenior
Responsibilities
- Define and evolve enterprise data strategy, architecture principles, standards, and target-state roadmaps.
- Design and govern scalable, secure, cost-effective Snowflake architectures for analytics and AI use cases.
- Architect end-to-end operational and analytical data flows across APIs, streaming, CDC, batch, and ETL/ELT.
- Design event-streaming platforms and patterns covering partitioning, ordering, schemas, replay, delivery guarantees, resilience, security, and operations.
- Select and design relational, NoSQL, graph, time-series, distributed SQL, and lakehouse storage solutions.
- Develop semantic data models and establish consistent business definitions and reusable data structures.
- Embed data quality, lineage, metadata, security, testing, and observability across data platforms.
- Guide engineering and product teams, establish guardrails and automation, and maintain architecture decision records.
- Design secure, resilient, governed architectures for sensitive data and regulatory requirements.
- Experiment with AI-assisted architecture and engineering tools across research, modelling, coding, testing, and documentation.
Requirements
- Deep expertise designing and governing Snowflake data architectures, including ingestion, transformation, modelling, optimisation, workload management, sharing, and integration.
- Strong experience with cloud-native and distributed systems, including microservices, domain-driven design, bounded contexts, event-driven integration, eventual consistency, and distributed transactions.
- Hands-on experience designing and operating Kafka, Kinesis, or equivalent event-streaming platforms.
- Strong data modelling experience and familiarity with relational, NoSQL, graph, time-series, distributed SQL, and lakehouse technologies.
- Experience designing semantic data models using dbt or comparable tools.
- Experience architecting APIs, streaming, change data capture, batch, and ETL/ELT data pipelines.
- Experience embedding data quality, lineage, metadata, security, testing, and observability into data flows.
- Experience providing technical leadership and making architecture and delivery trade-offs with engineering and product teams.
- Experience designing secure, resilient, governed cloud data architectures for sensitive and regulated data.
- Practical experience with AI-assisted architecture and engineering tools, including awareness of their benefits and limitations.
- Desirable: UK wealth management, financial services, fintech, or another complex regulated industry.
- Desirable: experience with dbt and Dagster.
- Desirable: legacy modernisation involving Oracle, Sybase, ISAM, SFTP/file-based integration, migration, coexistence, reconciliation, CDC, and progressive decoupling.
Benefits
- 25 days of bookable holiday plus flexible Bank Holidays.
- AND Digital contributes 6% of salary to the pension, with a further 2% employee contribution that can be increased by choice.
- Aviva healthcare cover, including pre-existing condition cover.
- £1000 Flexibenefit allowance through the benefits portal, with unused allowance available as cash.
- Life Assurance and Income Protection.
- Eye test and first pair of glasses.
- Enhanced maternity and partner/paternity leave.
- The company is organised into regional Clubs of no more than 80 people and offers practice-area collaboration and professional development.
Tech Stack
Categories
Data Engineering
About AND Digital
AND Digital is a London-headquartered consulting firm that builds and modernises web and mobile products, cloud platforms, and data capabilities for large consumer and enterprise brands. It embeds cross-functional teams with clients to deliver software while upskilling in-house teams through agile coaching and digital learning. Founded in 2014 and privately held, it operates across the UK and Netherlands; clients have included British Airways and Heineken.