Back to jobs
Senior Associate, Business Intelligence
Bogota, Colombia
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.
Role Summary and Impact
As a Senior Associate, Business Intelligence on the Offshore team, who will support and build reporting, the business intelligence, and the data visualization to deliver campaign reporting insight. In this role, he/she will be responsible to retrieve, compile, cleanse and transform data to create the intelligence layer leading to analysis and optimize media investments.
- Collect data requirements from client teams including the Business Intelligence (Analytics) team to understand the measurement framework, the most critical metrics to implement for database build and business logic for data stitching and reporting.
- Manage the retrieving, compiling, and formatting of large volumes of data (ETL); data cleaning
- Assist in the build and development of weekly, monthly, quarterly reporting.
- Work with Global team in the US to ensure connectivity between regions reporting, US reporting and Global; across pods
- 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.
Skills and Experience
- Bachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.
- 1-2 years of work 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 Power BI, Tableau, Looker, Domo is required; knowledge of visual techniques for data analysis and presentation is a plus.
- Experience compiling media analytics performance reports & monthly/quarterly business reviews
- Experience working with SQL.
- 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.
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 particular 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.
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.
This position is in a Remote or Hybrid Work Modality and must be performed within Colombian territory. Only candidates residing in Colombia with a valid work permit may apply. Remote work contracts do not allow employment or relocation abroad.
Please read our Privacy Notice (https://www.wppmedia.com/pages/privacy-policy ) 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.
#LI-GOC
Please read our Privacy Notice for more information on how we process the information you provide.
Apply for this job
*
indicates a required field