Marketing Analyst, SpotHero

• Analytical - Your strong quantitative skills lend to creative and effective problem solving
• Inquisitive - You are innovative, resourceful, and naturally curious. You ask the right questions, raise scoping questions early, and are constantly looking for ways to improve upon things
• Data-driven - Your attention to detail is excellent. You are obsessive about measurement and can synthesize data into insights and recommendations
• Collaborative - You communicate technical findings clearly to non-technical partners and keep stakeholders informed as work progresses
• Strong SQL, including joins, subqueries, CTEs, and window functions
• 2+ years experience in data analysis, marketing analytics, or analytics engineering
• Experience with (or strong interest in learning) dbt and git-based development workflows, including code review
• Working knowledge of relational databases and spreadsheet analysis (pivot tables)

Desirable

• SpotHero is seeking a Marketing Analyst to deliver data-driven decision support in our fast-paced and growing e-commerce marketplace
• You'll join the Marketing Analytics team, whose work powers company-level CAC reporting, marketing mix modeling, and decisions across Marketing, Finance, Sales, CRM, and Customer Service — with coaching and support to keep developing your analytical and data-engineering skillset
• Marketing analytics: use SQL to analyze marketing performance, customer retention, pricing, and consumer segments, and turn findings into clear recommendations for stakeholders
• Data modeling: build and maintain dbt models in our marketing data warehouse — shipping work as tested, peer-reviewed pull requests following team architecture standards
• Attribution and spend: help maintain our unified marketing spend and attribution models across channels (paid search, paid social, app stores, affiliates, partnerships), powering CAC/ROAS reporting used at the executive level
• CRM and campaign measurement: design and measure test/control campaign lift, and support the data pipelines behind email/CRM targeting
• Reporting and dashboards: build Looker dashboards and reporting for stakeholders, and automate manual reporting workflows
• Cross-functional decision support: partner directly with Finance, Sales, CRM, Customer Service, and Data Science (including inputs to our marketing mix model) on analyses ranging from partnership evaluation to fraud and abuse detection
• Data quality: proactively identify and fix data-correctness issues, and flag discrepancies to stakeholders before they mislead decisions
• Enhance your skills: we provide progressively complex projects — and encourage use of AI-assisted development tools — to grow your SQL, dbt, Python, and analytical skills on the job