WPP is the creative transformation company We use the power of creativity to build better futures for our people planet clients and communities Working at WPP means being part of a global network of more than 100 000 talented people dedicated to doing extraordinary work for our clients We operate in over 100 countries with corporate headquarters in New York London and Singapore WPP is a world leader in marketing services with deep AI data and technology capabilities global presence and unrivalled creative talent Our clients include many of the biggest companies and advertisers in the world including approximately 300 of the Fortune Global 500 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 Why we re hiring We are seeking a highly skilled and experienced GCP Data Engineer to join our growing data team In this critical role you will be instrumental in designing building and maintaining robust and scalable data pipelines with a particular focus on integrating and transforming data from Google Analytics 4 GA4 into our BigQuery data warehouse You will leverage your expertise in GCP services SQL and Python to ensure data accuracy accessibility and performance enabling our analytics and business teams to derive actionable insights from our digital platforms This role requires a robust understanding of data warehousing principles a proactive approach to problem-solving and the ability to collaborate effectively with both technical and non-technical stakeholders What you ll be doing GA4 Digital Data Integration Design build and deploy robust ETL and data management processes specifically for ingesting transforming and loading high-volume digital analytics data from Google Analytics 4 GA4 into BigQuery BigQuery Data Architecture Develop and optimize BigQuery datasets tables and views to support various analytical needs ensuring efficient querying and data integrity Data Pipeline Development Design build and deploy ETL job workflows with reliable error exception handling and rollback frameworks primarily utilizing GCP services GCP Resource Management Monitoring and optimizing data processing and storage resources on GCP with a focus on BigQuery performance and cost efficiency Troubleshooting Optimization Troubleshooting and resolving data pipeline issues and performance bottlenecks particularly those related to large-scale digital data processing SQL Development Write complex customized SQL queries within BigQuery to manipulate data generate automatic periodic reports and support ad-hoc analytical requests Python Development Build applications and scripts using Python to automate data processes integrate systems and enhance data quality Documentation Best Practices Document data engineering processes best practices and technical specifications especially for GA4 data models and BigQuery schemas Cross-functional Collaboration Work collaboratively with Business Partner Teams and Business Stakeholders during project scoping and feasibility phases as a Subject Matter Expert SME for concept investigation viability and technical impact identify and communicate technical risks and mitigations Agile Development Conform to agile development practices - Evolutionary design refactoring continuous integration delivery test-driven development Production Support Provide production support for data load jobs ensuring the continuous flow of critical digital data Application Maintenance Maintain or upgrade existing data applications and pipelines Technical Communication Clearly communicate technical terms to non-technical people and help them understand why change might be required to achieve a specific goal or to complete a project Attend key design meetings and provide support Other ad hoc duties as required What you ll need Google Analytics 4 GA4 Expertise Proven experience in working with GA4 data including understanding its data model event-based tracking and integration with BigQuery BigQuery Mastery 5 years of hands-on experience with Google BigQuery including advanced SQL techniques CTEs window functions aggregate functions schema design and performance optimization SQL Expertise 5 years of hands-on experience with advanced SQL techniques CTEs window functions aggregate functions Python Development 5 years of strong experience in Python programming object-oriented functional programming Pandas PySpark Cloud Proficiency 5 years working with GCP tools services BigQuery DataProc DataFlow Terraform CloudRun Cloud Functions Pub Sub etc or equivalent cloud platforms like AWS or Azure Data Modeling Expertise Experience designing star schemas analyzing data warehouses and applying data warehouse methodologies particularly in the context of digital analytics data Source Control CI CD Hands-on experience with GitHub or similar repositories branching strategies and CI CD pipelines for data engineering workflows Testing Skills Proven ability to perform unit testing SQL scripts ETL modules integration testing and performance load stress testing Education Bachelor s degree in Computer Science Engineering Mathematics or a related technical field preferred Bonus Skills Knowledge of dbt data build tool Experience with other web analytics platforms or marketing data sources Familiarity with Looker or other BI tools for data consumption Who you are You re open 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 You re optimistic We believe in the power of creativity technology and talent to create brighter futures or our people our clients and our communities We approach all that we do with conviction to try the new and to seek the unexpected You re extraordinary we are stronger together through collaboration we achieve the amazing We are creative leaders and pioneers of our industry we provide extraordinary every day What we ll give you Passionate inspired people - We aim to create a culture in which people can do extraordinary work Scale and opportunity - We offer the opportunity to create influence and complete projects at a scale that is unparalleled in the industry Challenging and stimulating work - Unique work and the opportunity to join a group of creative problem solvers Are you up for the challenge LI-Onsite 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 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 Please read our Privacy Notice https www wpp com en careers wpp-privacy-policy-for-recruitment for more information on how we process the information you provide