Job Description
Job Title: Snowflake Data Architect - 5 DAYS A WEEK ON-SITE
/n
Day Rate: £600-£700 per day
/n
Location: Wembley London - 5 days on-site
/n
Our client, a well-established and diversified multinational organisation, is seeking a Snowflake / Data Architect to join their team.
/n
Skills
/n
/n
- Solid experience in Data Engineering or Data Architecture, with solid experience in specialising in Snowflake platform design and governance.
/n
- Data Architecture: Mastery of Data Warehouse design methodologies - Inmon, Kimball, and Data Vault 2.0 - with the judgement to apply the right pattern for the right use case.
/n
- Technical Skills: Expert SQL and Python; hands-on experience with dbt (data build tool) or equivalent transformation frameworks.
/n
- AWS Integration: Solid understanding of AWS IAM, S3 data lake patterns, and PrivateLink for cross-cloud data connectivity.
/n
- AI Readiness: Practical experience architecting data infrastructure for AI/ML consumption - vector databases, embedding stores, and RAG pipeline integration.
/n
- Soft Skills: Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders.
/n
/n
Duties
/n
/n
- Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products.
/n
- Cross-Cloud Orchestration: Design and implement secure, high-throughput data pipelines connecting AWS S3 and Azure APIs through Snowflake - ensuring data integrity, lineage tracking, and end-to-end auditability.
/n
- Snowflake Governance: Own the full security model for the Snowflake platform - RBAC policy design, dynamic data masking, row-level security, and comprehensive audit logging across all environments.
/n
- FinOps for Data: Monitor Snowflake credit consumption patterns, identify and remediate high-cost query anti-patterns, and implement warehouse scheduling strategies to reduce operational data spend.
/n
- AI Readiness: Architect data stores purpose-built for LLM consumption - including vector databases, embedding pipelines, and RAG-compatible data structures that will serve as the foundation for the clients AI product layer.
/n
- Data Contracts: Partner with Business Analysts to formally define and document 'Data Contracts' between systems - creating clear, agreed interfaces between producers and consumers across the data platform.
/n
Snowflake Data Architect - Wembley (5 days a week on-site) in London employer: Adecco
Join a dynamic and innovative team at our Hull-based manufacturing and engineering company, where your contributions as a Design Engineer will be valued and impactful. We offer a collaborative work culture that fosters creativity and professional growth, alongside competitive benefits and opportunities for skill development in a niche industry. Experience the satisfaction of seeing your designs come to life while working in a supportive environment that prioritises employee well-being and career advancement.
