Data Architect (Snowflake)
AND Digital3 days ago
Bristol, 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 covering ingestion, transformation, modelling, performance optimization, workload management, data sharing, and integration.
- Architect operational and analytical data flows across APIs, streaming, CDC, batch, and ETL/ELT while embedding data quality, lineage, metadata, security, testing, and observability.
- Design event-streaming platforms and patterns, including partitioning, ordering, schema evolution, idempotency, replay, delivery guarantees, fault tolerance, security, and operations.
- Select and design appropriate relational, NoSQL, graph, time-series, distributed SQL, and lakehouse data stores.
- Create semantic data models using tools such as dbt and establish consistent business definitions and reusable data structures.
- Work with engineering and product teams to make architectural trade-offs, establish guardrails and automation, and maintain architecture decision records.
- Design secure, governed, resilient cloud data architectures that support sensitive data handling and regulatory obligations.
- Experiment with AI-assisted architecture and engineering tools across research, modelling, coding, testing, and documentation.
Requirements
- Deep expertise in Snowflake and enterprise data architecture.
- 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 across relational, NoSQL, graph, time-series, distributed SQL, and lakehouse technologies.
- Experience designing end-to-end data pipelines and architectures across APIs, streaming, CDC, batch, and ETL/ELT.
- Experience with data quality, lineage, metadata, security, testing, observability, resilience, and governance.
- Experience working closely with engineering and product teams in fast-paced agile environments.
- Practical experience with AI-assisted architecture and engineering tools and an understanding of their benefits and limitations.
- Experience in UK wealth management, financial services, fintech, or another complex regulated industry is desirable.
- Experience with dbt and Dagster is desirable.
- Legacy modernization experience involving Oracle, Sybase, ISAM storage, and SFTP/file-based integration is desirable.
Benefits
- 25 days of bookable holiday plus flexible Bank Holidays.
- AND Digital contributes 6% of salary to the pension, with a further 2% contributed by the employee and the option to increase contributions.
- 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.
- Inclusive culture with regional Clubs of no more than 80 people and access to Practice Areas for 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.