Founding Data Engineer

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.

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.

You will:

• Own the end-to-end data function: architecture, roadmap, delivery and reliability
• Design and maintain robust pipelines and data models in GCP (Big Query, SQL, Python)
• Develop production‑grade Python pipeline code (requests, pandas and clean engineering practices)
• Build and scale API integrations across Meta, Tik Tok, You Tube, 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

• Strong experience owning data pipelines in production environments (GCP preferred)
• Advanced SQL and strong Big Query 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

• 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

• 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)

You’ll help build and scale pipelines across:

• Meta:
  Facebook and Instagram already integrated
• Next wave:
  Tik Tok, You Tube, X/Twitter, Snap, Linked In, 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 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