Senior Data Engineer

<div class="content-intro"><p><strong>WPP is the trusted growth partner for the world’s leading brands.&nbsp;</strong></p> <p><strong>We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth.&nbsp;</strong><br><strong>&nbsp;</strong><br><strong>We work with the world's most valuable brands and have global reach across 100+ markets, with deep local expertise.</strong><br><strong>&nbsp;</strong><br><strong>Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow.&nbsp;</strong><br><strong>&nbsp;</strong><br><strong>For more information, visit <a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwpp.com%2F&amp;data=05%7C02%7CErica.Durr%40wpp.com%7C9bf4566a65bc46a48ac008de749116ea%7C150b5e663d884dee83f6ed149b727a00%7C0%7C0%7C639076363668176216%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=Q9juosud56XGLThSFZ1NpPZd6FXpJPxV74OeRZWoh%2B4%3D&amp;reserved=0" target="_blank">WPP.com.</a></strong><br><strong>&nbsp;</strong></p></div><p><span style="text-decoration: underline;"><strong>Why we're hiring:</strong></span></p> <p>We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team. In this critical role, you will be instrumental in designing, building, and optimizing our scalable data lakehouse platform using Google BigQuery or Databricks. You will be a key player in developing robust data pipelines that ingest data from various sources, including Google Analytics 4 (GA4), and transform it into reliable, analysis-ready datasets within the lakehouse environment. This role requires deep expertise in modern lakehouse platforms – Google BigQuery and/or Databricks – together with strong skills in SQL, Python, and Apache Spark (PySpark), along with strong hands-on experience across Azure, AWS, and GCP cloud environments, as our data ecosystem spans multiple cloud platforms. You will be responsible for the entire data lifecycle within the lakehouse, from ingestion and transformation to governance and optimization, ensuring data quality and performance. You should be adept at analyzing performance bottlenecks in Spark jobs and BigQuery workloads, providing enhancement recommendations, and collaborating effectively with both technical and non-technical stakeholders.</p> <p><span style="text-decoration: underline;"><strong>What you'll be doing:</strong></span></p> <ul> <li>Design, build, and deploy robust ETL/ELT pipelines within the lakehouse platform (Google BigQuery or Databricks) using SQL, Python, PySpark, and Spark SQL.</li> <li>Implement and manage the Medallion Architecture (Bronze, Silver, Gold layers) using Delta Lake or BigQuery datasets to ensure data quality and progressive data refinement.</li> <li>Leverage native ingestion tooling – such as BigQuery Data Transfer Service, Pub/Sub streaming, or Databricks Auto Loader – for efficient, scalable, and incremental ingestion of data from sources like GA4 into the Bronze layer.</li> <li>Develop, schedule, and monitor complex, multi-task data workflows using Cloud Composer (Airflow), BigQuery scheduled queries, or Databricks Workflows.</li> <li>Optimize BigQuery tables (partitioning, clustering, materialised views) and Spark jobs / Delta Lake tables (using techniques like OPTIMIZE, Z-ORDER, and partitioning) for high performance and cost efficiency.</li> <li>Implement data governance, security, and discovery using Dataplex / BigQuery policy tags or Unity Catalog, including managing access controls and data lineage.</li> <li>Write complex, customized SQL queries to manipulate data and support ad-hoc analytical requests from business teams.</li> <li>Develop strategies for data ingestion from multiple sources, using various techniques including streaming, API consumption, and replication.</li> <li>Document data engineering processes, data models, and technical specifications for the lakehouse platform.</li> <li>Conform to agile development practices, including version control (Git), continuous integration/delivery (CI/CD), and test-driven development.</li> <li>Provide production support for data pipelines, actively monitoring and resolving issues to ensure the continuous flow of critical data.</li> <li>Collaborate with analytics and business teams to understand data requirements and deliver well-modelled, performant datasets in the gold layer</li> </ul> <p><span style="text-decoration: underline;"><strong>What you'll need:</strong></span></p> <ul> <li>Education: Minimum of a bachelor’s degree in computer science, Engineering, Mathematics, or a related technical field preferred.</li> <li>Experience: 8+ years of relevant experience in data engineering, with a significant focus on building data pipelines on distributed systems.</li> </ul> <p><strong>Engineer's Core Skills:</strong></p> <ul> <li>Lakehouse Platform Expertise (Google BigQuery and/or Databricks)</li> <li>BigQuery: Deep, hands-on experience with BigQuery architecture, including partitioning, clustering, materialised views, slot/cost optimisation, and diagnosing query performance using query plans and INFORMATION_SCHEMA.</li> <li>Apache Spark / Delta Lake: Strong experience with Spark architecture, writing and optimising PySpark and Spark SQL jobs, and building reliable pipelines on Delta Lake. Proficient with ACID transactions, time travel, schema evolution, and DML operations (MERGE, UPDATE, DELETE).</li> <li>Data Ingestion: Experience with modern ingestion tools, such as BigQuery Data Transfer Service, Pub/Sub / Dataflow streaming, Databricks Auto Loader, and COPY INTO for scalable file processing.</li> <li>Data Governance: Strong understanding of data governance concepts and practical experience implementing security, lineage, and discovery using Dataplex, BigQuery IAM and policy tags, or Unity Catalog.</li> </ul> <p><br><strong>Core Engineering &amp; Cloud Skills:</strong></p> <ul> <li>Programming: 5+ years of strong, hands-on experience in Python, with an emphasis on PySpark for large-scale data transformation.</li> <li>SQL: 6+ years of advanced SQL experience, including complex joins, window functions, and CTEs.</li> <li>Cloud Platforms: 8+ years of strong, hands-on experience working across all three major cloud platforms – Azure, AWS, and GCP – including expertise in cloud storage (ADLS Gen2, S3, Google Cloud Storage), security and identity management (Azure AD/Entra ID, AWS IAM, GCP IAM), and cloud networking. Proven ability to design, deploy, and support data solutions in multi-cloud environments.</li> <li>Data Modeling: Experience designing star schemas and applying data warehouse methodologies to build analytical models (Gold layer).</li> <li>CI/CD &amp; DevOps: Hands-on experience with version control (Git) and CI/CD pipelines (e.g., GitHub Actions, Azure DevOps) for automating the deployment of BigQuery and Databricks assets.</li> </ul> <p><strong>Tools &amp; Technologies:</strong></p> <ul> <li>Primary Data Platform: Google BigQuery or Databricks</li> <li>Cloud Platforms: Azure, AWS, and GCP (strong hands-on experience across all three required)</li> <li>Data Warehouses (Integration): Snowflake</li> <li>Orchestration/Transformation: Cloud Composer (Airflow), Databricks Workflows, dbt (data build tool)</li> <li>Version Control: Git/GitHub or similar repositories</li> <li>Infrastructure as Code (Bonus): Terraform</li> <li>BI Tools (Bonus): Looker or Power BI</li> </ul> <p></p> <p><span style="text-decoration: underline;"><strong>Who you are:</strong></span></p> <p><strong>You're open<em>:</em> </strong>we are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views. We are open-minded: to new ideas, new partnerships, new ways of working.</p> <p><strong>You're optimistic<em>:</em></strong> we approach all that we do with confidence: to try the new and to seek the unexpected.</p> <p><strong>You're extraordinary:</strong> We are stronger together: through collaboration we achieve the amazing. We are creative leaders and pioneers of our industry; we provide extraordinary every day.</p> <p>&nbsp;</p> <p></p> <p><span style="text-decoration: underline;"><strong>What we'll give you:</strong></span></p> <p><strong>Passionate, inspired people</strong> – we champion a culture of people that do extraordinary work</p> <p><strong>Scale and opportunity</strong> – we offer the opportunity to create, influence and deliver projects at a scale that is unparalleled in the industry.</p> <p><strong>Challenging and stimulating work</strong> – unique work and the opportunity to join a group of creative problem solvers.&nbsp;</p> <p>&nbsp;</p> <p><span style="color: rgb(236, 240, 241);">#LI-Hybrid&nbsp;</span></p><div class="content-conclusion"><p><strong>We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we’ve adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.</strong></p> <p><strong>WPP is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.</strong></p> <h4><strong>Please read our Privacy Notice (<a href="https://www.wpp.com/en/careers/wpp-privacy-policy-for-recruitment">https://www.wpp.com/en/careers/wpp-privacy-policy-for-recruitment</a>) for more information on how we process the information you provide.</strong></h4></div>