Senior Data Engineer

The Product Counsel; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Benefits offered by this job

Flexible working hours

Collaborative team culture

Opportunity to work on impactful projects

Job summary

A data-driven consultancy in Greater London is seeking a Senior / Staff Data Engineer to design and implement data platforms for analytics and data-driven products. In this senior role, you'll ensure data quality and collaborate with various stakeholders to create reliable, user-focused solutions. The ideal candidate has strong SQL skills, experience in data governance, and a background in Ad Tech or Mar Tech. This remote role offers flexible hours and a collaborative environment focused on impactful projects.

Qualifications

• Hands-on experience in data engineering, BI, or data platform roles.
• Strong personal ownership of data quality and delivery.
• Comfortable making technical decisions in ambiguous environments.

Responsibilities

• Design and build end-to-end data pipelines.
• Maintain and improve ETL/ELT workflows.
• Establish trusted data assets with clear ownership.

Skills

Advanced SQL skills

Experience in Ad Tech or Mar Tech

Data governance knowledge

Experience with cloud data warehouses

Programming experience in Python

Critical reasoning about data behavior

Tools

BigQuery

Snowflake

Airflow

Looker/LookML

Job description

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.