Snowflake Architect

AI overview

Leverage deep expertise in Snowflake architecture to design scalable data solutions while mentoring junior engineers and driving innovation around emerging features.

As a Snowflake Archictect you will be expected to take an architecture lead role on our client’s solution delivery engagements. This will involve ongoing analysis of business requirements throughout the lifetime of the service. Candidates will have a strong understanding of data architecture and analytics design and project delivery life-cycles with an emphasis of working in client facing environments.

You will design and implement scalable, secure, and high-performance data solutions using the Snowflake Data Cloud. This role requires deep technical expertise in Snowflake architecture, data modelling, and integration with cloud platforms (AWS, Azure, GCP). You will collaborate with cross-functional teams to deliver robust data strategies aligned with business objectives.

Key Responsibilities

Architectural Design: Develop end-to-end Snowflake-based data architectures including databases, schemas, virtual warehouses, and storage integrations. Define clustering, partitioning, and performance tuning strategies for optimal cost and speed.

Data Integration & Engineering: Design and implement ELT/ETL workflows using tools like Snowpipe, Streams, Tasks, DBT, Airflow, Kafka, or Informatica. Ensure seamless integration with cloud storage (AWS S3, Azure Blob, GCP GCS).

Performance & Cost Optimisation: Tune queries, warehouses, and caching for high performance. Optimise compute vs. storage usage for cost efficiency.

Security & Governance: Implement RBAC, dynamic data masking, and encryption for compliance (GDPR, HIPAA, SOC2). Define governance standards and auditing processes.

Collaboration & Leadership: Work closely with stakeholders to translate business requirements into technical solutions. Provide technical guidance and mentorship to junior engineers.

Innovation: Evaluate emerging Snowflake features (Iceberg tables, Snowpark, Cortex) and integrate with AI/ML platforms.

Required Skills & Qualifications

Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.

Experience: 15+ years in data engineering/architecture, with at least 4+ years on Snowflake. Proven expertise in SQL, data modelling (3NF, star schema, snowflake schema), and ETL/ELT design.

Technical Skills: Snowflake architecture (warehouses, databases, schemas, stages, streams, tasks). Cloud platforms: AWS, Azure, GCP. Tools: DBT, Airflow, Teradata, Informatica, Fivetran, Talend. BI tools: Tableau, Power BI, Looker.

Certifications: SnowPro Core and SnowPro Advanced Architect (preferred).

Soft Skills: Excellent problem-solving, communication, and stakeholder management skills.

Preferred Qualifications

Experience with data lakehouse architectures (Snowflake + Iceberg/Delta).

Experience and demonstrated competencies in ETL development techniques and ETL tools like Teradata, ADF, Informatica,

Exposure to AI/ML integration with Snowflake.

Why Version 1? 

 At Version 1, we believe in providing our employees with a comprehensive benefits package that prioritises their wellbeing, professional growth, and financial stability. 

  • Share in our success with our Quarterly Performance-Related Profit Share Scheme, where employees collectively benefit from a share of our company's profits. 
  • Strong Career Progression & mentorship coaching through our Strength in Balance & Leadership schemes with a dedicated quarterly Pathways Career Development programme. 
  • Flexible/remote working, Version 1 is tremendously understanding of life events and people’s individual circumstances and offer flexibility to help achieve a healthy work life balance. 
  • Financial Wellbeing initiatives including; Pension, Private Healthcare Cover, Life Assurance, Financial advice and an Employee Discount scheme. 
  • Employee Wellbeing schemes including Gym Discounts, Bike to Work, Fitness classes, Mindfulness Workshops, Employee Assistance Programme and much more. Generous holiday allowance, enhanced maternity/paternity leave, marriage/civil partnership leave and special leave policies. 
  • Educational assistance, incentivised certifications, and accreditations, including AWS, Microsoft, Oracle, and Red Hat. 
  • Reward schemes including Version 1’s Annual Excellence Awards & ‘Call-Out’ platform. 
  • Environment, Social and Community First initiatives allow you to get involved in local fundraising and development opportunities as part of fostering our diversity, inclusion and belonging schemes. 

And many more exciting benefits… drop us a note to find out more. 

  Video link: https://www.youtube.com/watch?v=F_d3ELTH5zo 

Perks & Benefits Extracted with AI

  • Education Stipend: Educational assistance, incentivised certifications, and accreditations, including AWS, Microsoft, Oracle, and Red Hat.
  • Flexible Work Hours: Flexible/remote working, Version 1 is tremendously understanding of life events and people’s individual circumstances and offer flexibility to help achieve a healthy work life balance.
  • Health Insurance: Financial Wellbeing initiatives including; Pension, Private Healthcare Cover, Life Assurance, Financial advice and an Employee Discount scheme.
  • Employee Wellbeing Schemes: Employee Wellbeing schemes including Gym Discounts, Bike to Work, Fitness classes, Mindfulness Workshops, Employee Assistance Programme and much more.

Version 1 has celebrated over 26 years in the IT industry and continues to be trusted by global brands to deliver IT solutions that drive customer success. Version 1 has several strategic technology partners including Microsoft, AWS, Oracle, Red Hat, OutSystems and Snowflake. We’re also an award-winning employer reflecting how employees are at the heart of Version 1. We’ve been awarded: Innovation Partner of the Year Winner 2023 Oracle EMEA Partner Awards, Global Microsoft Modernising Applications Partner of the Year Award 2023, AWS Collaboration Partner of the Year - EMEA 2023 and Best Workplaces for Women by Great Place To Work in UK and Ireland 2023. As a consultancy and service provider, Version 1 is a digital-first environment and we do things differently. We’re focused on our core values; using these we’ve seen significant growth across our practices and our Services Reliabilities Group (SRG) team is preparing for the next phase of expansion. This creates new opportunities for driven and skilled individuals to join one of the fastest-growing consultancies globally.

View all jobs
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Architect Q&A's
Report this job
Apply for this job