Description
Position at GroupM Choreograph
WHO WE ARE
Choreograph is WPP's global data products and technology company. We're on a mission to transform marketing by building the fastest, most connected data platform that bridges marketing strategy to scaled activation.
We work with agencies and clients to transform the value of data by bringing together technology, data and analytics capabilities. We deliver this through the Open Media Studio, an AI-enabled media and data platform for the next era of advertising.
We're endlessly curious. Our team of thinkers, builders, creators and problem solvers are over 1,000 strong, across 20 markets around the world.
Role Summary & Impact
Want more jobs like this?
Get jobs in New York, NY delivered to your inbox every week.
We are looking for a Business Intelligence Senior Associate who will build, develop, and maintain the reporting infrastructure and business intelligence to deliver campaign reporting insights as well as competitive insights. 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.
Key Responsibilities
- Collect data requirements from client teams including the Marketing Intelligence & Science team 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 (Cloud infrastructure and data lakes ...)
- Assist in the build and development of custom databases on the reporting platform.
- 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.
Requirements
- Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.
- 1 - 3 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 Tableau and/or Power BI, Google Data Studio, Datorama, Domo is required; knowledge of visual techniques for data analysis and presentation is a plus.
- Experience with Alteryx for business logic design required as well as ability to operate in Cloud environment (Azure. GCP, AWS, IBM data cloud pack).
- Experience working with SQL or Python.
- 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.
- Strong speaking and written professional communication skills.
- Strong analytical, critical thinking, and problem-solving skills.
- The ability to thrive in a fast-paced and deadline-driven environment.
- Strategic Thinker & Doer.
- Curious and excited to learn.
- High sense of accountability and ownership.
- Collaborative with a partnership mindset.
Life at GroupM
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. GroupM employees can tap into the global GroupM & 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, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days.
GroupM is WPP's media investment group and the world's leading media investment company with a mission to shape the next era of media where advertising works better for people. The company is responsible for more than $60 billion in annual media investment, as measured by the independent research bureau COMvergence. Through its global agencies Mindshare, Wavemaker, EssenceMediacom, and T&Pm, and cross-channel performance (GroupM Nexus), data (Choreograph), entertainment (GroupM Motion Entertainment) and investment solutions, GroupM leverages a unique combination of global scale, expertise, and innovation to generate sustained value for clients wherever they do business. Discover more at www.groupm.com.
The base salary for this position at the time of this posting may range from $45,000 to $100,000. Individual compensation varies based on job-related factors, including business needs, experience, level of responsibility and qualifications. We offer a competitive benefits package, please visit https://www.wpp.com/careers/wellbeing/benefits-at-wpp-in-the-us for more details.