Data Architect - Snowflake/PostgreSQL

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. 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.