Data Analyst, Operations

Brainlabs; Greater London; On-site; GBP 45,000 - 65,000; Full time

Job summary

Brainlabs is seeking a Data Analyst to own data flow between operational systems, the data warehouse, and business tools. You will ensure data is well structured, reliably synced, and available in BigQuery and Notion for day-to-day workflows.

You will build integrations, manage HubSpot as system of record, and collaborate with Finance and Ops to translate technical decisions into actionable insights. The role is office-centric with occasional commutes to the London area and involves working with

Qualifications

• Experience building data integrations across operating systems and data warehouses.
• Ability to translate technical decisions for non-technical stakeholders.
• Strong governance, data quality, and deduplication practices.
• Proficient in Python and SQL for automation and data movement.

Responsibilities

• Build and maintain integrations moving data into the data warehouse.
• Synchronize data back into operational systems to enable workflows.
• Debug data discrepancies and automate data quality checks.
• Own HubSpot data as system of record and govern data quality.
• Collaborate with Finance, Ops and Client Leadership to translate needs.

Skills

Data modeling

Data integration

Python

SQL

ETL/ELT

APIs

BigQuery

GCP tools

GitHub Actions

HubSpot data

Tools

BigQuery

Snowflake

HubSpot

Notion

GitHub

APIs

Job description

Brainlabs is the independent, founder-led agency building the future of media. We have over 1000 Brainlabbers based across the global, all united through the 12 principles laid out in our Culture Code. We're full-service, with people and AI agents working side by side, all aligned to one thing: maximizing our clients' revenue through a genuinely scientific approach to media. If you want to help play your part in achieving this for the world's biggest brands in an environment that will support and challenge you in equal measure, this is where you do it.

What's the role

We're looking for a Data Analyst to own the flow of data between our operational systems, our data warehouse and the rest of the business. Systems like Hubspot and our People Planner, hold the client, revenue and pipeline data that Finance, Ops and Client Leadership rely on. This role keeps that data well structured, reliably synced and trustworthy as it moves into BigQuery and back out into the tools people use every day. A key part of the job is getting the right, live data presented cleanly in Notion, so client teams can actually use it to inform their day to day workflows.

What you do

• Build and maintain integrations that move operating system data into the data warehouse.
• Push data warehouse data back into operating systems to create complete workflows and data lifecycles
• Debug data discrepancies across source systems and downstream tools, identifying the causes and automating solutions to prevent issues moving forward.
• Own HubSpot (or a comparable CRM) as a system of record: properties, associations, lifecycle stages etc. and the automation that keeps them consistent, including data quality, deduplication and governance at scale.
• Work closely with finance, operations, and other business support teams, translating technical decisions into terms non-technical stakeholders can act on.

Who you are

• Deep experience managing data structure (objects, properties, associations, lifecycle stages, automation), not just using it as an end user, with strong data quality and governance practices (deduplication, enrichment, validation, access controls, auditability).
• Able to turn a non-technical brief into a full plan and build it, and explain technical solutions to non-technical stakeholders without jargon.
• Comfortable in fast-moving rollouts, balancing speed with long-term architecture as requirements evolve.
• Experience building sync logic (canonical IDs, upserts, change detection, idempotent reruns) and ETL/ELT pipelines that survive repeated runs without duplicating or corrupting data.
• Experience integrating data into BigQuery, Snowflake or similar warehouses via API-based integrations, including reverse ETL back into business systems.
• Strong Python (or similar) and SQL for automation, data movement, transformation and validation across warehouse tables and views.
• Confident with REST APIs (auth, pagination, rate limits, retries, error handling) and GCP tooling (Cloud Run, Cloud Scheduler, Secret Manager, BigQuery, GitHub Actions) for building and orchestrating automated jobs.
• Able to debug data discrepancies across source systems and downstream tools, with good version control hygiene (GitHub or similar).

How you succeed

• Data moves between systems reliably and accurately at scale
• Systems stay clean at scale, with properties and associations that hold up as volume grows.
• Data discrepancies get caught and fixed at the source
• Finance, operations and other business teams trust the numbers
• New integrations and automations are shipped with documentation and clear guidance
• You balance shipping quickly against building for the long term, and can explain that trade-off to a non-technical stakeholder in plain terms.

What happens next?

We know searching for a job is tough and that you want to find the best career and employer for you. We also want to ensure that this position is the best fit for both you and us. Therefore, you will participate in a comprehensive interview process that includes skills interviews with our team. The goal of this process is to allow you to get to know us as we learn more about you.

A note on our offices:

We pride ourselves in being a company with an office-centric culture and, for the majority of roles we expect people to be in commuting distance of the office and come in for around 3 days per week.

Brainlabs actively seeks and encourages applications from candidates with diverse backgrounds and identities. We are proud to be an equal opportunity workplace: we are committed to equal opportunity for all applicants and employees regardless of age, disability, sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion, or belief, and marriage and civil partnerships. If you have a disability or special need that requires accommodation during the application process, please let us know!