At a Glance
- Tasks: Build and maintain a global data warehouse on Google Cloud for marketing insights.
- Company: Join WPP Media, a leader in AI-driven media solutions.
- Benefits: Enjoy competitive pay, health benefits, and generous time off.
- Other info: Collaborative culture with opportunities for growth and learning.
- Why this job: Make an impact in digital marketing with cutting-edge data engineering.
- Qualifications: Experience in data engineering and proficiency in SQL and GCP.
The predicted salary is between 50000 - 70000 £ per year.
About WPP Media
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 pioneering agentic marketing platform, WPP Open – we help clients navigate change, capture opportunity, and deliver transformational growth. WPP Media is WPP's AI-driven media operating unit, bringing together media, data, and partnerships to deliver creative personalisation at scale.
1344 - Data Engineer Role Summary and Impact
This role forms part of a data engineering team assigned to one of WPP’s major global clients, who will be building and maintaining a global data warehouse, automated reports, and data provisioning applications to ensure that media and marketing stakeholders the world over will have access to the right data and insights to inform their marketing decisions.
The team’s primary responsibility is to build and maintain a global Google Cloud based reporting solution, which automates the collection and transformation of disparate marketing data into a single source of truth. Not only does that mean running and maintaining the solution that already exists, but also continually improving it to incorporate new data sources, and to derive new insights, to support ever-evolving business demands.
As a Data Engineer your primary responsibility will be to support campaign reporting by creating and maintaining infrastructure supporting timely, accurate and meaningful data deliverables & reporting. You will serve as a leader and exemplar of data engineering best practices and thought.
Some of the things we’d like you to do:
- Deploy data collectors in Adverity to gather data from media, agency system, and other sources
- Develop and expand on existing data “recipes” and transformations in SQL via DBT run on Google Cloud Platform
- Development and maintain data quality checks and procedures, helping stakeholders overcome data issues before they impact the quality of the reporting solution
- Support the translation of user requirements and business needs into technical specifications
- Be a proficient user of Google Cloud Platform and associated technologies, ensuring your work incorporates industry best practice
- Monitor automated jobs, troubleshooting data issues as-and-when they arise
- Support other members of the team responsible for “last mile” transformation and visualization of data within Google Data Studio reports and dashboards
- Serve as a technical and professional leader for junior staff
- Provide hands-on support to users of reporting solutions, helping the wider team triage and respond to user queries in a timely manner
- Attend internal stakeholder meetings, presenting your solutions and providing updates on your work
- Support the development strong working relationships with third-party data providers that we rely on for access to necessary data
Skills and Experience Required
- Experience in data engineering, preferably handling advertising media or marketing data
- Experience in GCP
- Professional experience with SQL, preferably deployed via DBT
- Analytically minded, enabling you to understand and overcome technically complex challenges, and to tell compelling stories with data
- Strong organizational skills and attention to detail, including the ability to manage multiple tasks in a fairly autonomous way
- Strong spoken and written communication skills, ensuring your thoughts and needs are heard and understood
- An ability to demonstrate a passion for the digital marketing ecosystem, and an understanding of the role that data plays within it
- Delivers best results when working in a team environment, and an ability to partner effectively with people of varying degrees of technical capability
Desirable
- Previous experience working with data and technology
- Experience with digital marketing platforms and the data they generate, in particular Google Marketing Platform, Facebook, Tiktok etc.
- An understanding of how data is tracked and exchanged in the process of digital advertising (e.g. role of ad servers and other third-party tech vendors)
- Experience using or building reports with business intelligence software, ideally Microsoft PowerBI
- Work experience within a marketing organization, preferably at a media agency or related company (e.g. publisher, ad tech, client marketing org)
Life at WPP Media & Benefits
Our passion for shaping the next era of media is powered by our commitment to Be Extraordinary, investing in our employees to inspire transformational creativity. We also Lead Optimistically, firmly believing in and Championing Growth and Development for every individual. This commitment allows WPP Media employees to leverage the extensive global WPP Media & WPP networks to pursue their passions, build vital professional connections, and learn at the cutting edge of marketing and advertising.
We Create an Open environment built on trust and respect, where everyone feels they belong and has opportunities to progress. This inclusive culture is fostered through a variety of employee resource groups and frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our comprehensive benefits package reflects this commitment, including competitive medical, group retirement plans, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days.
WPP Media is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We believe the best work happens when we're together, fostering creativity, collaboration, and connection in this open and supportive environment. 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.
Please read our Privacy Notice for more information on how we process the information you provide. While we appreciate all applications received, only those candidates selected for an interview will be contacted.
Data Engineer - GCP in London employer: WPP Media
WPP Media is an exceptional employer that prioritises employee growth and development, offering a dynamic work culture where creativity and collaboration thrive. With a commitment to inclusivity and a comprehensive benefits package, including competitive medical plans and significant paid time off, employees are empowered to pursue their passions while working in a supportive hybrid environment. Join us at WPP Media, where your contributions will directly impact the future of media and marketing on a global scale.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer - GCP in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like WPP Media!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer - GCP at WPP Media.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like WPP Media.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer - GCP at WPP Media, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer - GCP in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at WPP Media, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at WPP Media. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at WPP Media
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at WPP Media!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
