Manager, Business Intelligence & Data Visualization

$60,000 - $140,000/Yr

WPP - San Francisco, CA

Full-time - Mid Level

San Francisco, CA

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

In this role, you will build, develop, and maintain the reporting infrastructure, business intelligence, and data visualization to deliver campaign reporting insights and 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.

Responsibilities

• Collect data requirements from client teams to understand the measurement framework and critical metrics for database build.
• Manage data provisioning and define the taxonomy for the activation team to ease data retrieval.
• Manage the retrieving, compiling, and formatting of large volumes of data (ETL).
• Manage data cleansing processes.
• Assist in the set-up of clients' environments including 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 business intelligence platforms (Tableau) for insight generation.
• Help develop automated QA processes to ensure data accuracy and timeliness.

Requirements

• Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field OR equivalent professional work experience.
• 3 - 5 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.
• 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, campaign planning tools, website analytics software, and paid search engine marketing data sources is strongly preferred.

Nice-to-haves

• Knowledge of visual techniques for data analysis and presentation.

Benefits

• Competitive medical, vision, and dental insurance
• Significant paid time off
• Preferential partner discounts
• Employee mental health awareness days