GCP Big Query Architect

Spencer Rose Ltd; Hounslow; On-site; GBP 92,000 - 111,000; Full time

Job summary

Spencer Rose is urgently seeking an experienced GCP BigQuery Architect to work for our Banking client on a 6-month contract, with extensions likely. Start ASAP; vetting/onboarding up to 2 weeks. Hybrid: 2 days a week in South West office.

You will design, architect and deliver enterprise-scale data platforms on GCP, with BigQuery at the core, migrating legacy warehouses and building analytics solutions while collaborating with stakeholders and engineering teams.

Qualifications

• Experience designing enterprise-scale data platforms on Google Cloud Platform (GCP).
• Strong BigQuery design, architecture, and delivery capabilities.
• Experience migrating legacy data warehouses to GCP.
• Ability to work with client stakeholders to define architecture.
• Experience with IAM, encryption, and security best practices.
• Willingness to lead, mentor teams and conduct architecture reviews.

Responsibilities

• Design and implement scalable, secure GCP data architectures with BigQuery at core.
• Define end-to-end data architecture including ingestion, storage, governance.
• Lead migration of legacy data warehouses to GCP/BigQuery.
• Develop data pipelines using Dataflow, Dataproc, Cloud Composer, Pub/Sub.
• Provide technical leadership and perform architecture/code reviews.
• Collaborate with DevOps on CI/CD and IaC (Terraform).
• Participate in estimation, proposals, and client workshops.
• Drive performance, cost optimization, and operational excellence across GCP services.

Skills

GCP BigQuery

Data Architecture

Cloud Data Migration

Data Warehousing

Analytics Solutions

Technical Leadership

ETL/ELT

CI/CD

Tools

Terraform

Cloud Dataflow

Dataproc

Cloud Composer

Cloud Functions

Pub/Sub

Cloud Storage

Job description

Spencer Rose are urgently seeking an experienced GCP Big Query Architect to work for our Banking client for a minimum 6 month contract (extensions highly likely), to start ASAP. Hybrid, 2 days a week in South West office.

Start: ASAP (allowing up to 2 weeks for vetting and onboarding)

Day Rate: £500pd Inside IR35

Hybrid: 2 days a week in the office

Duration: 6 months initially

You must have strong expertise in designing, architecting, and delivering enterprise-scale data platforms on Google Cloud Platform (GCP). The ideal candidate will have extensive experience with BigQuery, cloud data migration, data warehousing, and analytics solutions while working closely with client stakeholders to define architecture and drive successful delivery.

Key Responsibilities

• Design and implement scalable, secure, and high-performance data architectures on GCP, with BigQuery as the core data warehouse.
• Define end-to-end data architecture, including ingestion, transformation, storage, governance, and reporting.
• Lead migration of Legacy data warehouses and ETL workloads to GCP and BigQuery.
• Design optimized BigQuery schemas, partitioning, clustering, and performance tuning strategies.
• Develop data pipelines using Cloud Dataflow, Dataproc, Cloud Composer, Cloud Functions, Pub/Sub, and Cloud Storage.
• Work with client business and technical teams to understand requirements and translate them into scalable cloud solutions.
• Establish best practices for data governance, security, metadata management, and data quality.
• Ensure compliance with enterprise security standards using IAM, encryption, audit logging, and networking best practices.
• Provide technical leadership, mentor development teams, and perform architecture and code reviews.
• Collaborate with DevOps teams to implement CI/CD pipelines and Infrastructure as Code (Terraform preferred).
• Support solution estimation, proposal preparation, technical presentations, and client workshops.
• Drive performance optimization, cost optimization, and operational excellence across GCP services.

Ideally, you will hold the relevant GCP certifications.