Data Engineer

<div class="content-intro"><h3><strong>Who We Are</strong></h3> <p>VML, part of WPP, is a leading creative company that combines brand experience, customer experience, and commerce, creating connected brands to drive growth. VML is celebrated for its innovative and human first, award-winning work for blue chip client partners including AstraZeneca, Colgate-Palmolive, Dell, Ford, Microsoft, Nestlé, The Coca-Cola Company, and Wendy's. The agency is recognized by the Forrester Wave™ Reports, as a Leader among Marketing Creative and Content Service Providers, Commerce Services, Global Digital Experience Services, Global Marketing Services and, most recently, Marketing Measurement &amp; Optimization. In addition, VML’s specialist health network, VML Health, is one of the world’s largest and most awarded health agencies. VML’s global network is powered by 26,000 talented people across 55+ markets, with principal offices in Kansas City, New York, Detroit, London, São Paulo, Shanghai, Singapore, and Sydney.</p> <p><strong>About WPP</strong></p> <p>WPP is the trusted growth partner for the world’s leading brands. We unite&nbsp;cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel&nbsp;in a single company –&nbsp;powered by exceptional talent and our agentic marketing platform, WPP Open,&nbsp;to help our clients navigate change, capture opportunity and deliver transformational growth. For more information, visit&nbsp;<u><a href="http://wpp.com/" data-outlook-id="2714312b-312f-4651-9f88-d8a4e47547bc">WPP.com</a></u>.</p></div><p>At VML, we are architects of&nbsp;connected brands and experiences&nbsp;for a changing world. We believe in the powerful synergy of&nbsp;creativity, technology, data, and culture&nbsp;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>Overview</strong></p> <p>The Data Engineer, Marketing &amp; Analytics, is a key technical contributor responsible for designing, building, and maintaining 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 ensuring high-quality, reliable, and accessible data for analysis, reporting, and advanced analytical initiatives, including feeding platforms like&nbsp;Amplitude.</p> <p>You will leverage a modern data stack including Google Cloud Platform (GCP), Matillion for ETL/ELT, Snowflake as our cloud data warehouse, and Rudderstack for customer data ingestion. Your work will directly enable our analytics and data science teams to derive critical insights, fuel AI/ML applications, and provide robust data to product analytics platforms like Amplitude. Beyond pipeline development, you will also be responsible for monitoring, troubleshooting, and optimizing data workflows. This position requires strong engineering principles, a meticulous approach to data quality, and a collaborative spirit to work with cross-functional teams.</p> <p><strong>Responsibilities:</strong></p> <p>As a Data Engineer, your duties will include, but will not be limited to, the following:</p> <ul> <li><strong>Data Pipeline Development: Design</strong>, develop, and implement scalable and reliable ETL/ELT pipelines using Matillion and GCP services (e.g., Cloud Functions, Cloud Storage, Big Query, Composer/Airflow) to ingest, transform, and load digital and media data into Snowflake.</li> <li><strong>Data Ingestion &amp; Integration: Configure</strong> and manage data streams from various sources, including customer data platforms like Rudder stack, APIs (e.g., ad platforms, analytics tools), and other raw data feeds. Understand and integrate data from advanced omnichannel tagging and data collection systems, ensuring data readiness for tools like&nbsp;Amplitude.</li> <li><strong>Data Transformation &amp; Modeling: Develop</strong>&nbsp;complex SQL transformations within&nbsp;Snowflake&nbsp;to clean, enrich, and model data for optimal performance and usability by reporting tools (e.g.,&nbsp;Tableau,&nbsp;Amplitude) and analytical applications. Design and implement data schemas (star, snowflake, data vault) to support business requirements.</li> <li><strong>Infrastructure Management: Monitor</strong>, maintain, and optimize the performance, security, and cost-efficiency of our data infrastructure components across&nbsp;GCP&nbsp;and&nbsp;Snowflake.</li> <li><strong>Quality Assurance &amp; Monitoring: Implement</strong>&nbsp;robust data quality checks, validation rules, and automated monitoring solutions for all data pipelines to ensure accuracy, completeness, and timeliness of data delivered to various platforms, including&nbsp;Amplitude. Troubleshoot and resolve data discrepancies and pipeline failures promptly.</li> <li><strong>Reporting &amp; Visualization Support: Collaborate</strong>&nbsp;with analytics specialists and data visualization experts (e.g., those using&nbsp;Tableau&nbsp;and&nbsp;Amplitude) to ensure data models meet their reporting needs and are optimized for query performance.</li> <li><strong>Documentation &amp; Governance: Create</strong>&nbsp;and maintain comprehensive documentation for data pipelines, data models, schemas, and data dictionaries. Adhere to data governance best practices, including data privacy (GDPR, CCPA) and security standards.</li> <li><strong>Collaboration &amp; Innovation: Work</strong>&nbsp;closely with data analysts, data scientists, product managers (who often use&nbsp;Amplitude), solution architects, and client teams to understand data requirements and translate them into technical solutions. Stay informed on emerging data engineering technologies, AI/ML data preparation techniques, and best practices.</li> <li><strong>Automation: Automate</strong> routine data management tasks, monitoring, and deployments where possible using scripting languages like Python.</li> </ul> <p><strong>REQUIREMENTS</strong></p> <ul> <li>Minimum 5 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 organization 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: Proven</strong>&nbsp;experience with&nbsp;Google Cloud Platform (GCP), particularly BigQuery, Cloud Storage, Cloud Functions, and orchestration tools like Cloud Composer (Apache Airflow).</li> <li><strong>Data Warehousing: Solid</strong>&nbsp;expertise in&nbsp;Snowflake&nbsp;including data loading, SQL querying, performance tuning, and schema design (star schema, snowflake schema).</li> <li><strong>ETL/ELT Tools: Strong</strong>&nbsp;hands-on experience designing and building data pipelines with&nbsp;Matillion&nbsp;(or similar tools like Fivetran, Stitch).</li> <li><strong>Customer Data Platforms (CDPs): Experience</strong> with Rudder stack for event collection, data routing, and destination management.</li> <li><strong>Product Analytics Platforms: Familiarity</strong>&nbsp;with or experience integrating data with&nbsp;Amplitude&nbsp;(or similar product analytics tools like Mixpanel, Pendo).</li> <li><strong>Programming &amp; Scripting: Advanced</strong>&nbsp;proficiency in&nbsp;SQL&nbsp;for data manipulation and transformation. Experience with&nbsp;Python&nbsp;for scripting, automation, and API integrations.</li> <li><strong>BI &amp; Reporting: Experience</strong>&nbsp;supporting data consumers using BI tools like&nbsp;Tableau&nbsp;(or Looker Studio, Power BI), understanding the data needs for dashboarding, and the data structures required by&nbsp;Amplitude.</li> <li><strong>Data Collection &amp; Integration: Experience</strong>&nbsp;integrating data from various sources, including APIs (REST, GraphQL), SFTP, and understanding of event-driven data architectures, especially from advanced tagging and data collection systems.</li> <li><strong>Data Modeling: Practical</strong>&nbsp;experience with data modeling techniques for analytical databases.</li> <li><strong>Version Control: Proficiency</strong>&nbsp;with Git and modern software development practices.</li> <li><strong>Beneficial: Experience</strong> with other cloud platforms (AWS, Azure), knowledge of containerization (Docker, Kubernetes), or exposure to streaming data technologies (Kafka).</li> </ul> <p><strong>Functional &amp; Domain Expertise:</strong></p> <ul> <li><strong>Marketing &amp; Product Data: Strong</strong>&nbsp;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: Familiarity</strong>&nbsp;with data privacy regulations (GDPR, CCPA) and best practices for data security and compliance.</li> <li><strong>Analytics Ecosystem: Understanding</strong>&nbsp;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: Demonstrated</strong>&nbsp;experience as a senior consultant, engaging directly with clients to gather requirements, present solutions, and manage expectations.</li> <li><strong>Communication: Exceptional</strong> written and oral communication skills, capable of authoring complex technical specifications, blueprints, and proposals, and confidently leading technical discussions.</li> <li><strong>Problem-Solving: Proven</strong> ability to work collaboratively as part of a team to solve complex problems in varied, fast-paced environments.</li> <li><strong>Project Management Acumen: Experience</strong>&nbsp;working effectively within a project management office framework.</li> <li><strong>Methodologies: Familiarity</strong> and experience with best practice development methodologies.</li> <li><strong>Adaptability: Ability</strong> to instill confidence through maturity, expertise, and impeccable communications.</li> </ul> <p>&nbsp;</p> <p><em><strong>*Please note that our business is an equal opportunity employer and preference in appointment for the role will be in line with the EE strategy of our organisation*</strong></em></p> <p><strong><span class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">#LI-HYBRID </span></strong><strong><span class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak">#LI-EMEA</span></strong></p> <p>&nbsp;</p><div class="content-conclusion"><p><span class="normaltextrun"><span lang="EN-GB"><span lang="EN-GB">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 an average of four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.</span></span></span></p> <p><span class="normaltextrun"><span lang="EN-GB">WPP (VML) 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><span class="scxw176048299"><span lang="EN-GB">VML is a WPP agency (NYSE: WPP). For more information, please visit  <a href="https://www.vml.com/" target="_blank">www.vml.com</a>, and follow along on&nbsp;<a href="https://www.instagram.com/vml_global/?hl=en">Instagram</a>, <a href="https://www.linkedin.com/company/vml/">LinkedIn</a>, and <a href="https://x.com/vml_global?lang=en">X</a>.</span></span></p> <p>When you click "Submit Application", this will send any information you add below to VML. Before you do this, we think it's a good idea to read through our&nbsp;<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>