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-native, 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-native 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 disability or 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 adjustments@robertwalters.com to discuss further.