Distributed Data Architect - Snowflake

ZipRecruiter; Glasgow; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

A leading technology firm in Glasgow seeks a skilled Distributed Data Architect to manage large-scale distributed database platforms in Snowflake and PostgreSQL. This hybrid role involves designing complex systems, implementing automation, and collaborating with cross-functional teams. Ideal candidates have expertise in managing extensive database clusters and a strong grasp of cloud services. Join a collaborative environment fostering continuous learning and professional growth.

Benefits

Collaborative work environment

Continuous learning opportunities

Healthy work-life balance

Qualifications

• Deep technical expertise in PostgreSQL and Snowflake.
• Proven experience managing large-scale distributed systems with 10K+ clusters.
• Proficient in scripting and automation tools.

Responsibilities

• Design, deploy, and manage large-scale distributed database systems.
• Architect and maintain database clusters across hybrid cloud platforms.
• Develop infrastructure-as-code and automation pipelines.

Skills

PostgreSQL administration

Snowflake optimization

Scripting (Python)

Automation tools (Terraform, Ansible)

CI/CD practices

AWS services

Azure services

Job description

Overview

Job Title: Distributed Data Architect - Snowflake/PostgreSQL

Location: Glasgow, Hybrid - 3 days a week in the office.

Employment Type: 1-year contract PAYE

About the Role:

We are seeking a highly skilled and motivated Distributed Data Architect to join a leading enterprise data infrastructure team, overseeing deployments of Snowflake, PostgreSQL, and Greenplum platforms. This is a key engineering role responsible for managing and scaling globally distributed database platforms across hybrid environments. You will contribute to modernisation initiatives, automation frameworks, and performance optimisations to support business-critical data infrastructure.

Key Responsibilities

• Design, deploy, and manage large-scale distributed database systems with a focus on Snowflake and PostgreSQL.
• Architect and maintain database clusters across hybrid cloud platforms (AWS, Azure).
• Develop and implement infrastructure-as-code and automation pipelines for provisioning, monitoring, and scaling.
• Collaborate with engineering, application, and platform teams to ensure high availability, performance, and security.
• Lead adoption of best practices in schema design, query optimisation, and data lifecycle management.
• Design and implement backup, disaster recovery, and data compliance strategies.
• Mentor junior team members and support cross-training across database technologies.
• Evaluate and integrate emerging technologies, including cloud-, serverless, and AI/ML capabilities.

Required Skills and Experience

• Deep technical expertise in PostgreSQL and Snowflake administration and optimization.
• Proven experience managing large-scale distributed systems (10K+ clusters).
• Proficient in scripting and automation tools such as Python, Terraform, and Ansible.
• Experience with CI/CD and modern DevOps practices.
• Solid understanding of AWS and Azure services and architectures.
• Excellent communication, collaboration, and problem-solving skills.

Desirable Skills

• Knowledge of Snowflake design patterns, migration workflows, and cost management strategies.
• Experience with geo-redundant database setups using tools like Patroni or GoldenGate.
• Familiarity with data security, governance, and compliance frameworks.
• Prior experience in managing multi-cloud, high-availability environments.
• Awareness of third-party integrations, Snowflake Cortex AI, and evolving trends in cloud data warehousing.

Work Location

This role is based in Glasgow, a major hub for technology, operations, and data services. You'll be joining a collaborative environment that supports continuous learning, professional growth, and a healthy work-life balance.

How to Apply

If you're a data engineer passionate about large-scale systems, automation, and cloud platforms, we'd love to hear from you. Apply now to take the next step in your career.

We are committed to creating an inclusive recruitment experience. If you have a long-term health condition and require adjustments to the recruitment process, our Adjustment Concierge Service is here to support you. Please reach out to us at [e-mail] to discuss further.

This position is being recruited on behalf of our client through our Outsourcing service line. Resource Solutions Limited, trading as Robert Walters, acts as an employment business and agency, partnering with top organizations to help them find the best talent. We welcome applications from all candidates and are committed to providing equal opportunities.