Senior manager- Data Engineer

About WPP Media 

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients and communities. For more information, visit wpp.com. 

WPP Media is WPP’s global media collective. In a world where media is everywhere and in everything, we bring the best platform, people, and partners together to create limitless opportunities for growth. For more information, visit wppmedia.com 

At WPP Media, we believe in the power of our culture and our people. It’s what elevates us to deliver exceptional experiences for both our clients and each other. In this role it will be critical to embrace WPP & WPP Media’s shared core values: 

• Be Extraordinary by Leading Collectively to Inspire transformational Creativity. 
• Create an Open environment by Balancing People and Client Experiences by Cultivating Trust. 
• Lead Optimistically by Championing Growth and Development to Mobilize the Enterprise. 

What will you do :

• Lead the development of automated data management and reporting solutions, reducing manual reporting efforts and significantly improving reporting efficiency and turnaround time.
• Develop and maintain Python scriptsto interact with various advertising platforms through API integrations (e.g., Facebook Ads, Google Ads, Programmatic Ads Platforms), enabling seamless data extraction and loading to desired platforms.
• Provide mentorship and technical guidance to team members, promoting the adoption of best practices in Python scripting, data engineering, and API integrations.
• Development and maintain data quality checks and procedures, helping stakeholders overcome data issues before they impact the quality of the reporting solutions.
• Monitor automated jobs, troubleshooting data issues as-and-when they arise
• Develop and manage interactive dashboardsto deliver actionable insights for clients.
• Support the development of strong working relationshipswith third-party data providers that we rely on for access to necessary data.

What you’ll need :

• Exceptional communication skills and can communicate effectively to both technical and non-technical stakeholders.
• 4-5+ years of experience with AWS(including Redshift) and other cloud technologies
• 4-5+ years of experience designing and maintaining data warehouses (e.g., Redshift, Big Query)as well as building complex ETL/ELT
• Expertise in working with real-time and batch data pipelines, including API-based integration workflows.
• Experience in maintaining and executing data onboarding blueprints which map source and target data strategies and aggregations.
• Advanced SQLproficiency, including concepts such as query optimization, indexing, and partitioning.
• Hands-on experience with Pythonfor data-related processes, using libraries like pandas, numpy, and frameworks like Flask.
• Experience with data monitoring, detection, troubleshooting as well as validation frameworks.
• Proven track record of delivering well-designed, well-tested and performant software solutions and pipelines within an agile environment.

Life at WPP Media & Benefits 

Our passion for shaping the next era of media includes investing in our employees to help them do their best work, and we’re just as committed to employee growth as we are to responsible media investment. WPP Media employees can tap into the global WPP Media & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include 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 are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

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.