Adecco
Snowflake Data Architect - London, Wembley
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Snowflake Data Architect - London, Wembley
Snowflake Data Architect
Salary: Paying up to £90,000 per annum Location: Wembley, London – 5 days on-site
Our client, a well-established and diversified multinational organisation, is seeking a Snowflake Data Architect to join their team.
Skills
- Solid experience in Data Engineering or Data Architecture, with a minimum of 4 years specialising in Snowflake platform design and governance.
- Data Architecture:
- Mastery of Data Warehouse design methodologies—Kimball, Inmon, and Data Vault 2.0.
- Ability to apply the right pattern for the right use case.
- Technical Skills:
- Expert-level SQL and Python.
- Hands-on experience with dbt (data build tool) or equivalent transformation frameworks.
- AWS Integration:
- Solid understanding of AWS IAM, S3 data lake patterns, and PrivateLink for cross-cloud data connectivity.
- AI Readiness:
- Practical experience architecting data infrastructure for AI/ML consumption, including vector databases, embedding stores, and RAG pipeline integration.
- Soft Skills:
- Strong interpersonal skills.
- Ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Duties
Get help with your application
Your very own career expert that helps elevate your application to the next level.
- Data Modelling Standard:
- Define Star Schema patterns, Snowflake object hierarchies, and modelling conventions to serve as a Group-wide standard for all data products.
- Cross-Cloud Orchestration:
- Design and implement secure, high-throughput data pipelines connecting AWS S3 and Azure APIs via Snowflake, ensuring:
- Data integrity
- Lineage tracking
- End-to-end auditability
- Design and implement secure, high-throughput data pipelines connecting AWS S3 and Azure APIs via Snowflake, ensuring:
- Snowflake Governance:
- Own the full security model for Snowflake, including:
- RBAC policy design
- Dynamic data masking
- Row-level security
- Comprehensive audit logging across all environments
- Own the full security model for Snowflake, including:
- FinOps for Data:
- Monitor Snowflake credit consumption patterns, identify and remediate high-cost query anti-patterns, and implement:
- Warehouse scheduling strategies
- Cost-reduction best practices
- Monitor Snowflake credit consumption patterns, identify and remediate high-cost query anti-patterns, and implement:
- AI Readiness:
- Architect data stores tailored for LLM consumption, including:
- Vector databases
- Embedding pipelines
- RAG-compatible data structures
- Serve as the foundation for the organisation’s AI product layer.
- Architect data stores tailored for LLM consumption, including:
- Data Contracts:
- Partner with Business Analysts to formally define and document ‘Data Contracts’ between systems, ensuring clear, agreed interfaces between producers and consumers across the data platform.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location