Senior Analyst-BI, GOC

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. }

OVERVIEW:

Building on your foundational experience, the Senior Associate role recognizes your growth into a reliable core performer on our Activation Team. In this role, you will be responsible for measurement planning, weekly reporting, media and creative testing/analysis, and competitive research and analysis. You will be a key contributor to the team's success, known for your precision and dependability. As a trusted member of the team, you will also help newer Associates navigate their roles by sharing your knowledge and experience.

KEY RESPONSIBILITIES:

• Collect data requirements under the guidance of the Client Activation Lead and in partnership with Client Analytics to understand the measurement framework, the most critical metrics to implement for database build and business logic for data stitching.
• Manage data provisioning.
• Define the taxonomy for the activation team to implement to ease data retrieval.
• Manage the retrieving, compiling, and formatting of large volumes of data (ETL).
• Manage data cleaning.
• Assist in the set-up of the clients’ environment
• Assist in the build and development of custom databases on the reporting platform.
• Assist in the strategy and development of the data visualization layer of the business intelligence platforms for insight generation for use in campaign monitoring and optimization.
• Help the development of automated QA processes to ensure data accuracy and timeliness.
• 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.

WHAT YOU BRING

• Bachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.
• 1 – 3 years hands on experience in data management, data visualization and data analytics preferably in a marketing and/or media agency.
• Experience in database structure work and in building dashboards with Tableau and/or Power BI (important) and Google Data Studio, Datorama, Domo (desirable), knowledge of visual techniques for data analysis and presentation is a plus.
• Experience working with SQL or Python (desirable)
• Experience with digital data from ad serving platforms (e.g. Google Campaign Manager, Other adservers), campaign planning tools (e.g. Prisma, Lumina, MediaOcean), website analytics software (e.g. Adobe Analytics, Google Analytics), paid search engine marketing data sources (e.g. Adwords, Marin, …) and others is strongly preferred.
• Ability to reliably execute tasks with autonomy, while keeping team members informed of progress and challenges.
• Strong analytical skills with a solid understanding of mathematical concepts and their application to campaign performance.

Please read our Privacy Notice for more information on how we process the information you provide.