At a Glance
- Tasks: Build and maintain a global data warehouse and automated reporting solutions.
- Company: Join WPP Media, a leader in AI-driven media and marketing.
- Benefits: Enjoy competitive pay, health benefits, and generous paid time off.
- Other info: Collaborative culture with opportunities for growth and professional development.
- Why this job: Make an impact by transforming data into actionable insights for global brands.
- Qualifications: Experience in data engineering and proficiency in SQL required.
The predicted salary is between 45000 - 55000 £ 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. Connected through WPP Open and powered by Open Intelligence, clients see exactly where, how, and why their media investment is working.
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. In doing so you will exhibit a foundational understanding of cloud technology and key data engineering skills and knowledge to help your team build their career in this fast evolving, and in demand, industry.
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
- 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 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 and retirement plans, employees are empowered to pursue their passions while enjoying a supportive environment. Located in a vibrant setting, WPP Media fosters strong professional connections and provides opportunities for meaningful contributions to the evolving landscape of marketing and advertising.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in London
✨Tip Number 1
Network like a pro! Reach out to current employees at WPP Media on LinkedIn. Ask them about their experiences and any tips they might have for landing the Data Engineer role. Personal connections can make a huge difference!
✨Tip Number 2
Prepare for your interview by brushing up on your SQL skills and Google Cloud Platform knowledge. Be ready to discuss how you've tackled data challenges in the past. Show us your analytical mindset and how you can tell compelling stories with data!
✨Tip Number 3
Don’t just focus on technical skills; highlight your teamwork abilities too! WPP Media values collaboration, so share examples of how you've worked effectively with others, especially in a data-driven environment.
✨Tip Number 4
Finally, apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining the WPP Media team. Good luck!
We think you need these skills to ace Data Engineer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Engineer role. Highlight your experience with SQL, Google Cloud Platform, and any relevant data engineering projects. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to tell us why you're passionate about data engineering and how you can contribute to our team. Be sure to mention any specific experiences that relate to the job description.
Showcase Your Technical Skills:Don’t hold back on showcasing your technical skills in your application. Mention your experience with data quality checks, automated reporting, and any tools you've used like DBT or Google Data Studio. We love seeing candidates who are technically savvy!
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people. Plus, it shows you're serious about joining our team!
How to prepare for a job interview at WPP Media
✨Know Your Data Engineering Basics
Before the interview, brush up on your data engineering fundamentals, especially around SQL and Google Cloud Platform. Be ready to discuss how you've used these technologies in past projects, as this will show your practical experience and understanding of the role.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled complex data challenges. Think about times when you had to troubleshoot data issues or improve reporting solutions. This will demonstrate your analytical mindset and ability to overcome obstacles.
✨Communicate Clearly and Effectively
Since strong communication skills are key for this role, practice explaining technical concepts in simple terms. You might be asked to translate user requirements into technical specifications, so being able to articulate your thoughts clearly will set you apart.
✨Demonstrate Your Passion for Digital Marketing
Research WPP Media and its approach to digital marketing. Be prepared to discuss how data plays a crucial role in marketing strategies. Showing genuine interest in the industry and the company's mission will resonate well with the interviewers.
