data analyst in advertising

Brainlabs is an independent, founder-led media agency that combines people and AI agents to maximize client revenue through a scientific approach to media. It operates globally with more than 1000 employees and serves the world's biggest brands.

• 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, identify their causes, and automate solutions to prevent recurring issues;
• Own HubSpot or a comparable CRM as a system of record, including properties, associations, lifecycle stages, automation, data quality, deduplication, and governance at scale;
• Work closely with finance, operations, and other business support teams, translating technical decisions into actionable terms for non-technical stakeholders;
• Ensure data moves between systems reliably and accurately at scale;
• Keep systems clean at scale as volume grows;
• Catch and fix data discrepancies at the source;
• Deliver trusted numbers for finance, operations, and other business teams;
• Ship new integrations and automations with documentation and clear guidance;
• Balance rapid delivery with long-term architecture and explain trade-offs to non-technical stakeholders in plain terms.

• Deep experience managing data structures such as objects, properties, associations, lifecycle stages, and automation;
• Strong data quality and governance practices, including deduplication, enrichment, validation, access controls, and auditability;
• Ability to turn a non-technical brief into a complete plan and build it;
• Ability to explain technical solutions to non-technical stakeholders without jargon;
• Experience working in fast-moving rollouts while balancing speed with long-term architecture;
• Experience building sync logic using canonical IDs, upserts, change detection, and idempotent reruns;
• Experience building ETL/ELT pipelines that avoid duplicating or corrupting data across repeated runs;
• Experience integrating data into BigQuery, Snowflake, or similar warehouses through API-based integrations, including reverse ETL into business systems;
• Strong Python or similar programming language and SQL skills for automation, data movement, transformation, and validation;
• Confidence with REST APIs, including authentication, pagination, rate limits, retries, and error handling;
• Experience with GCP tooling such as Cloud Run, Cloud Scheduler, Secret Manager, BigQuery, and GitHub Actions;
• Ability to debug data discrepancies across source systems and downstream tools;
• Good version control hygiene with GitHub or similar.

• Office-centric culture with around 3 days per week in the office expected for the majority of roles;
• Equal opportunity workplace with support for accommodation during the application process.