Analyze large data sets and marketing results to make data driven recommendations to optimize investments. Enable decision-making by leveraging analytical and database skills to develop analyses and maintain reports that exist across multiple sources including internal data warehouse, marketing mix modeling, web analytics, external marketing platforms, and other digital analytics tools.
Requirements
- SQL, Python, and Excel usage to analyze marketing effectiveness;
- Hands on experience and usage of marketing platform Adobe Analytics;
- Constructing and designing functional dashboards with Data visualization tools PowerBI and Tableau;
- Knowledge of Marketing Mix Modeling inputs, outputs and ability to build functional regression models;
- Experience with media optimization KPIs and diagnostics including: Return on ad spend (ROAS), CPM / CPC, reach / frequency, Cost / Acquisition, and Ecommerce metrics including Conversion, Average Unit Retail (AUR), and Average Order Size (AOS);
- Ability to deliver data visualizations and marketing optimizations via PowerPoint decks and level up insights for leadership teams;
- Understanding of incrementality vs last click attribution and customer lifeycycle metrics (CAC, retention rate, CLV, NPS);
Responsibilities
- SQL, Python, and Excel usage to analyze marketing effectiveness;
- Hands on experience and usage of marketing platform Adobe Analytics;
- Constructing and designing functional dashboards with Data visualization tools PowerBI and Tableau;
- Knowledge of Marketing Mix Modeling inputs, outputs and ability to build functional regression models;
- Experience with media optimization KPIs and diagnostics including: Return on ad spend (ROAS), CPM / CPC, reach / frequency, Cost / Acquisition, and Ecommerce metrics including Conversion, Average Unit Retail (AUR), and Average Order Size (AOS);
- Ability to deliver data visualizations and marketing optimizations via PowerPoint decks and level up insights for leadership teams;
- Understanding of incrementality vs last click attribution and customer lifeycycle metrics (CAC, retention rate, CLV, NPS);
Other
- Partner with Reporting, Engineering teams, and External Vendors to develop new reporting and visualizations as needed.
- Collaborate with vendors and cross functional teams to enable process, documentation, and evolve measurement and reporting for marketing KPIs.
- Proactively identify marketing recommendations and insights across full funnel marketing channels and KPIs.
- Collaborate with cross-brand and cross-functional Marketing Shared Services team members to learn best practices to adopt in your role and identify opportunities to contribute to the larger team.
- Embrace the complexity in the customer journey from awareness through conversion.
- Must live within reasonable commuting distance from SF office and able to appear in office as required.
- three (3) years of experience in the job offered or related role.
