Senior Manager - BI Engineer
Role details
Job location
Tech stack
Job description
This role will serve as a data visualization expert on a BI and engineering team assigned to one of WPP's major global clients, who will be building and maintaining a global data warehouse, taxonomy management and data checker tools, 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.
WPP has developed the Measure platform, a stack of standardized technologies (Adverity for collection, DBT for modelling, Google Cloud Platform for orchestration, computing, and storage, and Microsoft PowerBI for visualization) and templates to speed the deployment and simplify support for automated reporting and analytics tools. The Measure platform will be utilized along side a third party taxonomy management tool, Accutix, to ensure the quality and availability of media performance data and campaign meta data for all WPP teams working on this account.
The team's primary responsibility is to build and maintain a global Measure-based reporting solution, leveraging existing templates where applicable and building custom collectors, data models, cloud architectures, and/or visualizations when required. The team will automate the collection and transformation of disparate marketing data into a single source of truth, continually improving it to incorporate new data sources, and to derive new insights, to support ever-evolving business demands.
As a Senior Manager, Data Visualization, your primary responsibilities will include the upkeep and light redesigns of existing Microsoft PowerBI dashboards, ensuring that the taxonomy management tool is up to date, aiding the engineers in light technical work collecting and transforming datasets.
Some of the things we'd like you to do:
- Design and maintain rich, useful media campaign performance dashboards in Microsoft PowerBI
- Coordinate with data engineers on the development of data views for use in dashboards
- Build and maintain prototype dashboards' visuals and semantic layers
- Lead UAT processes for revised prototype dashboards, presenting features to and collecting feedback from internal and client-side stakeholders
- Update dashboards per client-prioritized feedback
- Work with team leadership and WPP OMS teams to include dashboards in agency 'operating system'
- Develop technical and training documentation for media, analytic, and technical audiences
- Participate in training sessions for the launch of dashboards
- Coordinate with single-region focused campaign analytics and technical teams to aid in local-market customization efforts
- Gather, vet, and manage changes to the global taxonomy
Requirements
Do you have experience in Taxonomy?, * Experience in data data visuualization, preferably handling advertising media or marketing data
- Professional experience with business intelligence tools, preferably Microsoft PowerBI
- Analytically minded, enabling you to understand and overcome technically complex challenges, and to tell compelling stories with data
- Experience in designing or maintaining taxonomy-based data operations
- Strong organizational skills and attention to detail, including the ability to manage multiple tasks in an 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)
Benefits & conditions
Pulled from the full job description
- Annual leave
- Employee discount, 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.