Wavemaker
Associate Director, Business Intelligence & Data Visualization
Wavemaker, San Francisco, California, United States, 94199
Wavemaker positively provokes growth for clients by reshaping consumer decision-making and experiences through media, content, and technology. Our name is both our mission and our method. We do our best work for brave brands and people who relish being challenged to go further and faster, together.
Please double check you have the right level of experience and qualifications by reading the full overview of this opportunity below.
Role Summary & Impact
In this role, you 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. You will be responsible for retrieving, compiling, cleansing, and transforming data to create the intelligence layer leading to the analysis and optimization of media investments.
Key ResponsibilitiesDefine the strategy for performance and competitive reporting solutions (business logic, data visualization, data feeds, and taxonomy).Contribute to offshoring strategy through the definition and implementation of process (e.g., automation).Ensure documented 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.Maintain API connections for data access and ingestion and contribute to the development of the API roadmap.Support Associates up to Managers on the creation of the taxonomy and support the adoption by activation teams.Support Associates up to Managers on retrieving, compiling, and formatting of large volumes of data (ETL).RequirementsBachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.5 – 8 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, and 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.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 mSix&Partners, 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.
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 GroupM Leave Administration at Leave.Administration@groupm.com 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 $75,000 to $180,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 this link for more details.#J-18808-Ljbffr
Please double check you have the right level of experience and qualifications by reading the full overview of this opportunity below.
Role Summary & Impact
In this role, you 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. You will be responsible for retrieving, compiling, cleansing, and transforming data to create the intelligence layer leading to the analysis and optimization of media investments.
Key ResponsibilitiesDefine the strategy for performance and competitive reporting solutions (business logic, data visualization, data feeds, and taxonomy).Contribute to offshoring strategy through the definition and implementation of process (e.g., automation).Ensure documented 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.Maintain API connections for data access and ingestion and contribute to the development of the API roadmap.Support Associates up to Managers on the creation of the taxonomy and support the adoption by activation teams.Support Associates up to Managers on retrieving, compiling, and formatting of large volumes of data (ETL).RequirementsBachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.5 – 8 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, and 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.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 mSix&Partners, 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.
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 GroupM Leave Administration at Leave.Administration@groupm.com 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 $75,000 to $180,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 this link for more details.#J-18808-Ljbffr