Data Engineer
BBBH35284_1780502088
Posted: 03/06/2026
- £350 - £400 per day
- City of London, London
- Contract
Agency Location: Holborn, London
Engagement: Initial 3-month contract (with potential ongoing retainer)
Business Overview
A London-based marketing agency specialising in luxury and premium brands across European markets. They deliver full-service marketing across:
? Paid Search
? Paid Social
? CTV / Programmatic
? Out-of-Home (OOH)
? Organic / LLM Optimisation
? Strategy & Data Consultancy
? In-housing support
They operate at the intersection of brand, performance, and data, and are now investing heavily in building a best-in-class data and AI capability to underpin both client delivery and internal operations.
Current Marketing Setup
The agency is in the early stages of using Google Cloud Platform (GCP) / Big Query as the central data platform and the source of truth to enable to capabilities as described above. The agency benefits from full access to GCP services and has access to Gemini premium across the Google stack and products.
In addition to the above; the agency uses Data Studio for the creation of client dashboards. Of which we have almost completed the first version of the dashboard we then hope to use across all clients (with some element of customisation).
Challenge
We have been working with a 3rd party to setup our GCP which the business is the owner of. Progress has been very slow in developing client dashboards and fully integrating the capabilities of GCP within the team.
Challenges include:
? Slow progress on dashboard deployment and pipeline stability
? Lack of clear data architecture and documentation
? Limited automation and operational efficiency
? Underutilisation of GCP and AI capabilities
? Fragmented approach to data ingestion and modelling
The Individual
We are looking for a hands-on Data Engineer to help us transition from an early-stage data setup into a scalable, production-ready data platform. The individual is required to have:
? Strong experience with GCP (BigQuery, Cloud Functions, etc.)
? Proven track record building marketing data pipelines
? Experience with Looker Studio / BI tools
? Familiarity with Airbyte or similar ETL tools
? Experience integrating or working alongside LLMs / AI workflows
? Comfortable operating in a fast-paced, ambiguous environment
? Able to own problems end-to-end, not just execute tasks
The goal is to establish:
? A robust, well-architected GCP data platform
? Automated, reliable data pipelines across all marketing channels
? Client-ready reporting infrastructure that scales
? Foundations for AI-driven insights, automation, and productisation
We are looking for someone who can build and shape the architecture around our business.
Scope of Work:
Data platform
? Further development of the data platform (GCP) to maximise the capabilities of the solution
? Technical design (architecture) and development of the platform, building on the current marketing setup to incorporate additional capabilities
? Ongoing maintenance and optimisation of data pipelines across platforms/data sources > GCP > outputs
? Integration of Claude Code with GCP to enable agentic operations and support the development of new tools and solutions
? Training and enablement of the team on using Gemini and GCP to enhance day-to-day insight generation and reporting
GCP enablement to improve BAU processes, including:
? Table/data automation and augmentation into reports via Google Sheets and Google Slides
? Performance health checks and alerting (e.g. changes in performance triggering automated signals to pause or adjust optimisation)
? Taxonomy and tracking validation (health checks and approval workflows)
? Basic QA processes (e.g. spelling and copy review)
Data Studio Reporting / Client Dashboards
? Completion of the template client dashboard (currently ~99% complete)
? Build of ~8 client-ready performance dashboards based on the core template
? Connection of dashboards to marketing data sources via Airbyte / BigQuery
? Setup of GCP-based agents to automate insight generation, improving operational efficiency and speed
Productisation
Brand Tracking Tool
? Leverage data from a combination of established sources (survey-based/social listening/LLM visibility tools) - via API or Airbyte - to develop a bespoke, dynamic brand tracking solution for clients which will monitor:
? Client visibility + brand health metrics in real time, with clear correlation to media campaign impact and commercial outcomes
? Trending conversations across social, AI and search
? Emerging opportunities, identification of the "white space" for clients to belong to
? Competitor benchmarking and analysis
End goal is to produce a proprietary sector specific tool which provides a unique point of difference vs existing in-market brand tracking solutions
Auditing solution(s)
? Develop agents/tools to audit paid media accounts and identify areas for improvement, with outputs surfaced for internal review before client use
? Develop agents/tools to audit client websites from an organic search / LLM perspective, identifying areas for improvement
MMM integration (as discussed in separate scope)
? Support integration of proprietary MMM model into the GCP environment
? Refine dashboard output to incorporate and clearly present insights from the model
Sphere Digital Recruitment is acting as an Employment Business in relation to this vacancy.