Senior Associate, Data & Analytics Services
Description
GroupM Nexus brings together 9,000 practitioners globally across ad ops, addressable content & TV, AI, commerce, programmatic, search and social, among others, to deliver transformational outcomes across digital channels and platforms and create exciting new career paths for our people. GroupM Nexus is the world's largest performance engine that integrates paid, owned, and earned to deliver true business outcomes for our clients.
Role Summary & Impact
We are looking for a Business Intelligence and Data Management Senior Associate who will build develop and maintain the reporting infrastructure, the business intelligence, and the data visualization 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.
Assist in the strategy and development of the data visualization layer of the business intelligence platforms (Tableau) 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.
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.
GroupM provides equal employment opportunities to applicants and employees without regard for factors such as race, religion, national origin, colour, sex, sexual orientation, gender identity or expression, age, protected veteran status, disability, or other protected status.
GroupM is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with GroupM, please send an e-mail to [email protected] or call (212) 297-8507 and let us know the nature of your request and your contact information.
The base salary for this position at the time of this posting may range from $45,000 to $90,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/people/wellbeing/benefits-at-wpp-in-the-us for more details.