As a Senior / Staff Data Engineer at The Product Counsel, you will design, build, and own robust data platforms that underpin analytics, reporting, and data-driven products for both TPC and our clients.
This is a senior, hands‑on role for engineers who care deeply about data correctness, trust, and long‑term sustainability. You will work across a variety of client environments, technologies, and cloud platforms, taking full ownership of data solutions end to end. You will collaborate closely with a Principal Data Engineer and other senior colleagues to shape standards, mentor others, and deliver high‑quality outcomes in complex, real‑world settings.
What You’ll Do
* Design, build, and maintain end‑to‑end data pipelines, from source systems through to analytics‑ready datasets.
* Own and improve ETL/ELT workflows, understanding how changes propagate across the data lifecycle.
* Design analytics‑ready data models that balance correctness, usability, and maintainability, applying patterns suited to data characteristics and downstream needs.
* Establish trusted data assets with clear ownership, shared definitions, and consistent behaviour across platforms.
* Take personal ownership of data quality, applying validation and reconciliation techniques to ensure outputs are accurate, explainable, and aligned with known business behaviour.
* Develop data solutions with clear lineage and traceability, mindful of downstream impact.
* Work with stakeholders (clients, analysts, product teams, and data scientists) to understand analytical needs and translate them into reliable, user‑focused data and reporting solutions.
* Contribute to and uphold engineering standards, best practices, and documentation.
* Review and evolve existing data platforms to improve performance, scalability, reliability, and maintainability.
* Support and mentor junior and mid‑level engineers at client sites, sharing expertise to elevate engineering quality within the client team.
* Participate in client‑facing discussions and business development activities as required, helping shape solutions and build trust with clients.
What We’re Looking For
Experience & Mindset
* Experience in Ad Tech or Mar Tech, with exposure to high‑volume, data‑intensive environments.
* Substantial hands‑on experience across data engineering, BI, or data platform roles, reflecting sustained exposure to real‑world systems.
* Proven track record of delivering accurate, trustworthy, production‑grade data solutions.
* Strong personal ownership and accountability for data quality.
* Comfortable operating autonomously in ambiguous environments and making sound technical decisions.
Core Data Engineering Skills
* Advanced SQL skills and extensive experience working with relational data at scale.
* Ability to design analytics‑ready data models that support historical accuracy, analytical performance, and evolving business needs.
* Experience designing, maintaining, and evolving end‑to‑end ETL/ELT pipelines, understanding how changes propagate downstream.
* Deep knowledge of data governance, data quality management, lineage, and impact analysis within complex data ecosystems.
* Skilled at reasoning critically about data behaviour over time and the downstream consequences of upstream design decisions.
Modern Data Stack
* Experience with cloud data warehouses (e.g. BigQuery, Snowflake, Redshift, ADW), including performance, cost, and data layout considerations.
* Proficiency with data integration and orchestration tools (e.g. Fivetran, Airflow, managed ELT platforms), and an understanding of how ingestion, transformation, and orchestration fit together.
* Experience building and maintaining an analytics or semantic modelling layer within reporting tools (e.g. Looker/LookML, Tableau, or similar), enabling consistent metrics, intuitive drill paths, and flexible data exploration.
* Clear understanding of how data models, transformations, and reporting layers work together to support reliable, user‑focused analytics.
* Experience working with at least one major cloud platform (AWS, GCP, Azure, or OCI).
* Programming experience in Python (or similar) for data engineering tasks.
Ways of Working
* Effective communicator who can explain complex data concepts clearly to technical and non‑technical audiences.
* Experienced in collaborating directly with stakeholders and clients.
* Comfortable balancing delivery, quality, and long‑term maintainability.
* Willing to contribute to business development activities and support company growth when needed.
Remote role
* With a preference for candidates based in London or Cambridge
* Flexible working hours and a collaborative, supportive team culture
* Opportunity to work on impactful, high‑visibility projects in the advertising technology space
The Product Counsel is designed to revolutionise how businesses operate.
#J-18808-Ljbffr