At a Glance
- Tasks: Shape and deliver a modern enterprise data platform using Snowflake.
- Company: Join a forward-thinking company transforming its data landscape.
- Benefits: Competitive salary, benefits, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and best practices.
- Why this job: Make a real impact in data transformation and AI initiatives.
- Qualifications: 10+ years in Data Engineering with 4+ years in Snowflake.
The predicted salary is between 95000 - 95000 £ per year.
We are seeking an experienced Snowflake Data Architect to play a pivotal role in shaping and delivering a modern enterprise data platform. This is an opportunity to join a business undergoing significant data transformation, moving from legacy systems and manual processes to a scalable, automated, cloud-first architecture. You will be responsible for defining architectural standards, driving best practices, and enabling engineering teams to deliver high‑quality, trusted data products that support analytics, reporting, and emerging AI initiatives.
Key Responsibilities
- Define and own enterprise‑wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks.
- Design scalable integration architectures for legacy platforms, including AS400, iSeries, and SQL‑based systems, ensuring robust reconciliation, auditability, and incremental data loading capabilities.
- Architect modern data pipelines leveraging Snowflake and orchestration technologies, ensuring reliability, scalability, idempotency, and effective error handling.
- Establish and govern security models across the data platform, including role‑based access control (RBAC), dynamic masking, row‑level security, and environment segregation.
- Drive platform performance optimisation and cost management within Snowflake, identifying inefficiencies and implementing scalable warehouse, clustering, and workload management strategies.
- Design data architectures that support AI and GenAI use cases, including vector search capabilities, embedding pipelines, and semantic data structures.
- Collaborate with Business Analysts, Data Engineers, and stakeholders to define data contracts and implement automated data quality frameworks.
- Champion Data‑as‑Code principles, helping establish CI/CD best practices and engineering standards across the organisation.
- Provide architectural leadership, mentoring engineering teams and translating complex technical concepts into practical guidance.
Required Experience
- 10+ years’ experience in Data Engineering, Data Architecture, or a related field.
- Minimum 4 years’ hands‑on experience designing and implementing solutions within Snowflake.
- Demonstrated success delivering enterprise‑scale data transformation programmes and modernising legacy data environments.
- Deep expertise in Data Vault 2.0, Kimball dimensional modelling, and Inmon methodologies, with the ability to select the right approach for varying business requirements.
- Advanced knowledge of dbt and Git‑based development practices.
- Strong experience designing cloud‑based data solutions, including integrations across AWS and Azure environments.
- Proven track record implementing CI/CD pipelines and promoting software engineering best practices within data teams.
- Experience defining data governance, security frameworks, and quality standards across enterprise platforms.
Desirable Skills
- Experience with Kestra or similar modern orchestration platforms.
- Knowledge of Snowflake Native Apps, Snowpark, and emerging AI/ML capabilities within modern data platforms.
- Exposure to vector databases, embeddings, retrieval‑augmented generation (RAG), and AI‑ready data architectures.
- Retail, wholesale, supply chain, or large‑scale transactional data experience.
Snowflake Data Architect employer: Broughton Group
Join a forward-thinking company in Wembley, London, where as a Snowflake Data Architect, you will be at the forefront of a transformative data journey. We pride ourselves on fostering a collaborative work culture that values innovation and continuous learning, offering competitive salaries and comprehensive benefits. With ample opportunities for professional growth and a commitment to embracing cutting-edge technologies, this is an ideal environment for those looking to make a significant impact in the data landscape.
StudySmarter Expert Advice🤫
We think this is how you could land Snowflake Data Architect
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even local events. The more people you know, the better your chances of landing that Snowflake Data Architect role.
✨Show Off Your Skills
Create a portfolio showcasing your past projects and achievements. Whether it's data models you've designed or pipelines you've built, having tangible examples can really set you apart from the competition.
✨Ace the Interview
Prepare for those tricky interview questions by practising your responses. Focus on your experience with Snowflake and how you've tackled challenges in data architecture. Confidence is key!
✨Apply Through Our Website
Don't forget to apply directly through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Snowflake Data Architect
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Snowflake Data Architect role. Highlight your experience with data modelling standards, cloud-based solutions, and any relevant projects that showcase your skills in Snowflake and data transformation.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background aligns with our needs. Mention specific experiences that demonstrate your expertise in data architecture and collaboration with engineering teams.
Showcase Your Technical Skills:Don’t forget to highlight your technical skills! Make sure to mention your hands-on experience with Snowflake, dbt, and CI/CD practices. We want to see how you can contribute to our data platform and drive best practices.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Broughton Group
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake knowledge before the interview. Be ready to discuss your hands-on experience with Snowflake, including any specific projects you've worked on. Highlight your understanding of Data Vault, Kimball, and Inmon methodologies, as these are crucial for the role.
✨Showcase Your Architectural Skills
Prepare to talk about your experience in designing scalable data architectures. Think of examples where you've successfully integrated legacy systems or optimised performance within Snowflake. Use specific metrics or outcomes to demonstrate your impact.
✨Emphasise Collaboration and Leadership
This role requires working closely with various teams, so be ready to share examples of how you've collaborated with Business Analysts and Data Engineers. Discuss how you've mentored others and translated complex concepts into actionable insights, showcasing your leadership skills.
✨Be Ready for Technical Questions
Expect technical questions that test your knowledge of data governance, security frameworks, and CI/CD best practices. Brush up on your understanding of role-based access control and dynamic masking, and be prepared to explain how you've implemented these in past projects.
