Senior Data Engineer

<div class="content-intro"><h4><strong>Who We Are</strong></h4> <p>WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business transformation and marketing modernization, connecting strategy directly to execution. Our 12,000 experts in engineering and platforms, commerce, consulting, content transformation, CRM, and CX work within a unified global operating unit across 40+ markets. WPP Enterprise Solutions works alongside best-in-class partners including Adobe, AWS, Braze, Google, Microsoft, Salesforce, and Shopify, as well as innovators in AI, to deliver growth solutions tailored to the needs of our clients’ businesses. VML, part of WPP, supports WPP Enterprise Solutions by helping brands activate transformation through creativity and experience.</p></div><p><strong>Overview</strong></p> <p>At VML, we are architects of connected brands and experiences for a changing world. We believe in the powerful synergy of creativity, technology, data, and culture to build brands that not only grow faster but also resonate deeply and personally with their customers. We are experts in marketing transformation, marketing science, and advanced marketing automation and personalization, relentlessly pushing the boundaries of what's possible.</p> <p>We power over 350 million personalized experiences between brands and their customers every day. We achieve this by applying our deep expertise, leveraging strategic partnerships with the biggest technology platforms in the world, and by harnessing cutting-edge advancements in&nbsp;Artificial Intelligence, Machine Learning, and Large Language Models. We work closely with our clients as true growth partners, helping them not just achieve their goals but redefine them for the future.&nbsp;This particular opportunity offers the chance to work directly with one of our tier-one automotive clients, a global brand powerhouse, helping shape their digital future.</p> <p>Our global team of 4,000+ data specialists serves more than 150 markets across the globe. We operate with unwavering integrity, a profound respect for data privacy, and complete transparency. We champion new ideas and diverse perspectives, fostering a culture of creative bravery, open listening, positivity, and collective strength in all that we do. We are constantly evolving, empowering our clients to stay ahead in a rapidly accelerating digital landscape.&nbsp;<strong>Please note that UK working hours will be required for this role.</strong></p> <p><strong>The Role</strong></p> <p>The&nbsp;Senior Data Engineer, Marketing &amp; Analytics, is a&nbsp;technical leader and architect&nbsp;responsible for&nbsp;designing, building, and owning&nbsp;robust data pipelines and infrastructure that power VML's digital and media reporting and product analytics for our tier-one clients. This role focuses on&nbsp;defining data strategy, ensuring high-quality, reliable, and accessible data for complex analysis, advanced reporting, and critical analytical initiatives, including feeding platforms like&nbsp;Amplitude. You will be instrumental in laying the data foundation that fuels AI/ML applications and provides strategic insights.</p> <p>You will&nbsp;leverage and evolve&nbsp;a modern data stack including&nbsp;Google Cloud Platform (GCP),&nbsp;Matillion&nbsp;for advanced ETL/ELT orchestration,&nbsp;Snowflake&nbsp;as our cloud data warehouse, and&nbsp;Rudderstack&nbsp;for customer data ingestion and event streaming. Your work will directly empower our analytics and data science teams to derive critical insights, fuel AI/ML applications, and provide robust data to product analytics platforms like&nbsp;Amplitude. This role demands&nbsp;end-to-end ownership, strategic technical guidance, and the ability to mentor junior engineers, alongside a deep understanding of data engineering principles, meticulous attention to data quality, and a collaborative spirit to drive data initiatives across cross-functional and client teams.</p> <p><strong>Responsibilities:</strong></p> <p>As a Senior Data Engineer within the VML EMEA Enablement Team, your duties will include, but will not be limited to, the following:</p> <ul> <li><strong>Data Architecture &amp; Strategy:</strong>&nbsp;Lead the design and architecture&nbsp;of scalable, resilient, and performant data pipelines and data infrastructure solutions on&nbsp;GCP&nbsp;and&nbsp;Snowflake. Contribute to defining the data engineering roadmap, evaluating new technologies, and establishing best practices.</li> <li><strong>Advanced Data Pipeline Development:</strong>&nbsp;Lead the development and implementation&nbsp;of complex and high-volume ETL/ELT pipelines using&nbsp;Matillion&nbsp;and advanced&nbsp;GCP services&nbsp;(e.g., Dataflow, Dataproc, Pub/Sub, Cloud Functions, BigQuery, Composer/Airflow) to ingest, transform, and load digital and media data into&nbsp;Snowflake. Drive automation and optimization of these pipelines for efficiency and reliability.</li> <li><strong>Complex Data Ingestion &amp; Integration:</strong>&nbsp;Architect and manage&nbsp;sophisticated data streams from diverse sources, including customer data platforms like&nbsp;Rudderstack, numerous APIs (e.g., ad platforms, analytics tools), and other raw data feeds. Ensure seamless and high-fidelity data integration from advanced omnichannel tagging and data collection systems into downstream systems like&nbsp;Amplitude.</li> <li><strong>Data Transformation &amp; Modeling Mastery:</strong>&nbsp;Define, design, and implement&nbsp;advanced SQL transformations and complex data models within&nbsp;Snowflake&nbsp;(e.g., dimensional modeling, data vault, wide table designs) to clean, enrich, and prepare data for optimal performance and usability by reporting tools (e.g.,&nbsp;Tableau,&nbsp;Amplitude) and sophisticated analytical/AI applications.</li> <li><strong>Infrastructure Management &amp; Optimisation:</strong>&nbsp;Oversee, optimise, and secure&nbsp;the performance, reliability, scalability, and cost-efficiency of our data infrastructure components across&nbsp;GCP&nbsp;and&nbsp;Snowflake. Implement robust monitoring, alerting, and incident response solutions.</li> <li><strong>Data Quality, Governance &amp; Security Leadership:</strong>&nbsp;Establish and enforce&nbsp;robust data quality frameworks, validation rules, and automated monitoring solutions for all data pipelines, ensuring accuracy, completeness, and timeliness of data delivered to various platforms, including&nbsp;Amplitude.&nbsp;Drive compliance&nbsp;with data privacy regulations (GDPR, CCPA) and security best practices within the data architecture.</li> <li><strong>Strategic Reporting &amp; Visualisation Support:</strong>&nbsp;Partner closely&nbsp;with analytics specialists, data scientists, and data visualisation experts (e.g., those using&nbsp;Tableau&nbsp;and&nbsp;Amplitude) to define data requirements, optimize data models for query performance, and ensure the delivery of strategic insights.</li> <li><strong>Mentorship &amp; Technical Guidance:</strong>&nbsp;Provide technical leadership, guidance, and mentorship to junior data engineers, fostering a culture of continuous learning, knowledge sharing, and engineering excellence. Conduct thorough code reviews and ensure adherence to best practices.</li> <li><strong>Collaboration &amp; Innovation:</strong>&nbsp;Act as a subject matter expert&nbsp;and partner with data analysts, data scientists, product managers (who extensively use&nbsp;Amplitude), solution architects, and client teams to translate complex business requirements into robust technical data solutions. Proactively research, evaluate, and advocate for emerging data engineering technologies, AI/ML data preparation techniques, and industry best practices.</li> <li><strong>Automation &amp; CI/CD:</strong>&nbsp;Drive automation of data management tasks, monitoring, and implement Continuous Integration/Continuous Deployment (CI/CD) practices for data pipelines and infrastructure.</li> </ul> <p><strong>REQUIREMENTS</strong></p> <ul> <li>Minimum 7 years’ engineering and development experience</li> <li>Strong Client-facing skills – responsive, results-driven, dedicated to customer support, and adept at consulting on complex technical and strategic data challenges.</li> <li>Strong attention to detail, excellent organisation skills, and ability to work independently and manage multiple projects/responsibilities and small teams in a fast-paced environment.</li> <li>Exposure to enterprise-level clients and understanding of complex web/app ecosystems, privacy regulations (GDPR, CCPA), and best practices for data governance.</li> <li>In-depth knowledge and understanding of various client websites, mobile apps, their business models, and online marketing/product strategy.</li> </ul> <p><strong>Technical &amp; Development Expertise:</strong></p> <ul> <li><strong>Cloud Platforms: </strong>Deep expertise&nbsp;with&nbsp;Google Cloud Platform (GCP), particularly BigQuery, Cloud Storage, Cloud Functions, Pub/Sub, Dataflow/Dataproc, and orchestration tools like Cloud Composer (Apache Airflow).</li> <li><strong>Data Warehousing: </strong>Mastery&nbsp;in&nbsp;Snowflake&nbsp;including advanced data loading strategies, complex SQL querying, extensive performance tuning, and designing intricate schema architectures (star schema, snowflake schema, data vault).</li> <li><strong>ETL/ELT Tools: </strong>Expert-level, hands-on experience&nbsp;designing, developing, and managing complex and high-volume data pipelines with&nbsp;Matillion&nbsp;(or similar enterprise-grade ETL tools like Fivetran, Stitch, Talend, Informatica).</li> <li><strong>Customer Data Platforms (CDPs): </strong>Extensive experience&nbsp;with&nbsp;Rudderstack&nbsp;(or Segment) for event collection, transformation, data routing, and destination management, understanding its role in the modern data stack.</li> <li><strong>Product Analytics Platforms: </strong>Proven experience&nbsp;integrating data with, and optimizing data for,&nbsp;Amplitude&nbsp;(or similar leading product analytics tools like Mixpanel, Pendo). In-depth understanding of Amplitude's event taxonomy and user properties.</li> <li><strong>Programming &amp; Scripting: </strong>Advanced proficiency&nbsp;in&nbsp;SQL&nbsp;for complex data manipulation, optimization, and transformation.&nbsp;Strong proficiency in Python&nbsp;for scripting, automation, API integrations, and potentially data processing frameworks.</li> <li><strong>BI &amp; Reporting: </strong>Demonstrated experience working closely with BI developers and analysts using tools like&nbsp;Tableau&nbsp;(or Looker Studio, Power BI), understanding their data needs and optimising data models for reporting performance.</li> <li><strong>Data Collection &amp; Integration: </strong>Expertise&nbsp;in integrating data from a wide variety of sources, including numerous APIs, SFTP, streaming data, and a deep understanding of event-driven data architectures, especially from advanced omnichannel tagging and data collection systems.</li> <li><strong>Data Modeling: </strong>Extensive practical experience&nbsp;with various data modeling techniques for analytical databases and data warehouses, including dimensional modeling, data vault, and normalised/denormalised approaches.</li> <li><strong>Version Control &amp; DevOps: </strong>Strong proficiency with Git&nbsp;and experience implementing CI/CD pipelines for data engineering workflows.</li> <li><strong>Beneficial: </strong>Experience with streaming data technologies (e.g., Kafka, Pub/Sub, Dataflow streaming), experience with containerization (Docker, Kubernetes), or knowledge of other cloud platforms (AWS, Azure).</li> </ul> <p><strong>Functional &amp; Domain Expertise:</strong></p> <ul> <li><strong>Marketing &amp; Product Data: </strong>Strong understanding of digital marketing data (e.g., ad impressions, clicks, conversions), media reporting metrics, product usage data (e.g., events, user flows as seen in&nbsp;Amplitude), and customer journey data.</li> <li><strong>Data Governance: </strong>Familiarity with data privacy regulations (GDPR, CCPA) and best practices for data security and compliance.</li> <li><strong>Analytics Ecosystem: </strong>Understanding of how data engineering supports analytics, reporting, and machine learning initiatives across various platforms including&nbsp;Amplitude.</li> </ul> <p><strong>Leadership &amp; Interpersonal Skills:</strong></p> <ul> <li><strong>Client Engagement: </strong>Demonstrated experience as a senior consultant, engaging directly with clients to gather requirements, present solutions, and manage expectations.</li> <li><strong>Communication: </strong>Exceptional written and oral communication skills, capable of authoring complex technical specifications, blueprints, and proposals, and confidently leading technical discussions.</li> <li><strong>Problem-Solving: </strong>Proven ability to work collaboratively as part of a team to solve complex problems in varied, fast-paced environments.</li> <li><strong>Project Management Acumen: </strong>Experience working effectively within a project management office framework.</li> <li><strong>Methodologies: </strong>Familiarity and experience with best practice development methodologies.</li> <li><strong>Adaptability: </strong>Ability to instill confidence through maturity, expertise, and impeccable communications.</li> </ul> <p>&nbsp;</p> <p><span data-teams="true">&nbsp;</span>WPP Enterprise Solutions is committed to Employment Equity and transformation. In accordance with our Employment Equity objectives, preference may be given to candidates from designated groups.</p> <p>#LI-EMEA</p><div class="content-conclusion"><h4><strong>About WPP</strong></h4> <p class="p1">WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence and world-class partnerships – all united by our agentic marketing platform, WPP Open – we help clients navigate change, capture opportunity and deliver transformational growth. For more information, visit <a href="http://wpp.com/"><span class="s1">WPP.com</span></a><span class="s2">.</span></p> <p><span class="normaltextrun"><span lang="EN-GB">WPP (VML/WPP Enterprise Solutions) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to 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.</span></span><span class="scxw176048299"><span lang="EN-GB">&nbsp;</span></span></p> <p>When you click "Submit Application", this will send any information you add below to WPP (VML/WPP Enterprise Solutions). Before you do this, we think it's a good idea to read through our <a href="https://www.vml.com/recruitment-privacy-policy">Recruitment Privacy Policy</a>. California residents should read our&nbsp;<a href="https://www.vml.com/california-recruitment-privacy-notice">California Recruitment Privacy Notice</a>. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.</p></div>