Data Architect - Snowflake/PostgreSQL

ZipRecruiter; Glasgow; Hybrid; GBP 125,000 - 150,000; Full time

Job summary

A leading recruitment firm is seeking a Distributed Data Architect based in Glasgow. This role entails managing large-scale distributed database systems, particularly Snowflake and PostgreSQL. Ideal candidates will possess extensive experience in cloud environments, scripting, and automation. Join a collaborative team dedicated to professional growth and a balanced work-life culture.

Qualifications

• Deep technical expertise in PostgreSQL and Snowflake administration and optimization.
• Proven experience managing large-scale distributed systems (10K+ clusters).
• Strong proficiency 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 and implement infrastructure-as-code and automation pipelines.
• Mentor junior team members and support cross-training across database technologies.

Skills

PostgreSQL administration

Snowflake optimization

Scripting (Python)

Terraform

Ansible

CI/CD practices

AWS services

Azure architectures

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\'ll 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.