Founding Data Engineer

London – 4 Days in Office

Reporting to: Director, Special Projects

Data at Pubity moves fast. We need an engineer who can own our data function end-to-end, build reliable pipelines, and turn messy inputs into structured, dependable systems the business can trust.

If you enjoy designing scalable architecture, setting standards, and shipping production-grade data systems that power real decisions every day, this role is for you.

About the Role

As Founding Data Engineer, you will take full ownership of Pubity Group’s data function. You will be responsible for the architecture, reliability, and evolution of our data ecosystem across Social, Commercial and Studio, with a growing footprint into our internal software stack.

You will work day to day with Special Projects and key stakeholders across the business, acting as the technical owner of how data is collected, modelled, validated, governed and used. This is a hands-on role with real autonomy: you will set the standards, build the systems, and ensure the business can rely on the outputs.

Key Responsibilities

You will:

●      Own the end-to-end data function: architecture, roadmap, delivery and reliability

●      Design and maintain robust pipelines and data models in GCP (BigQuery, SQL, Python)

●      Develop production-grade Python pipeline code (requests, pandas and clean engineering practices)

●      Build and scale API integrations across Meta, TikTok, YouTube, X/Twitter and others

●      Extend pipelines into internal systems (CRM, project management, meeting trackers, Slack and future tools)

●      Take ownership of data quality: validation rules, automated testing, monitoring and alerting

●      Define metric standards and a single source of truth across platforms (reach, engagement, retention, revenue)

●      Orchestrate workflows using GCP tooling (e.g. Cloud Composer) and ensure resilient scheduling

●      Own access control and governance in Google Cloud: IAM structure, permissions, auditability and admin hygiene

●      Partner with Social, Editorial, Commercial and Studio to deliver dashboards, reporting layers and decision-ready outputs

●      Own documentation, data definitions, and handover standards so the function scales cleanly

What We’re Looking For

Must Haves:

●      Strong experience owning data pipelines in production environments (GCP preferred)

●      Advanced SQL and strong BigQuery capability (or equivalent with the ability to ramp fast)

●      Strong Python for pipeline development including requests and pandas

●      Experience building and maintaining API based data integrations

●      Experience with dbt or Dataform and modern modelling practices

●      Clear track record of owning reliability: data QA, monitoring, alerting and incident response basics

Important:

●      Orchestration experience (Cloud Composer or equivalent)

●      Experience connecting data models to BI platforms (Power BI or equivalent)

●      Strong stakeholder management: able to prioritise competing asks and set expectations

Nice to Haves:

●      Cost optimisation experience in GCP or large scale query environments

●      Supabase or Postgres experience

●      Node.js scripting for connectors

●      Multi cloud exposure (AWS or Azure)

Platforms and Pipeline Scope

You’ll help build and scale pipelines across:

●      Meta: Facebook and Instagram already integrated

●      Next wave: TikTok, YouTube, X/Twitter, Snap, LinkedIn, Google Ads

●      Internal ecosystem: CRM, project management systems, meeting trackers, Slack and future first-party tools

Everything beyond Meta will be built from scratch, with you owning the approach and standards.

You’ll Thrive Here If…

●      You want full ownership, not narrow tickets

●      You like building systems that other teams depend on daily

●      You can move fast without sacrificing reliability

●      You communicate clearly and drive alignment across teams