Marketing Analyst

SpotHero•Chicago, IL

1d•$68,000 - $86,000•Hybrid

About The Position

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.

Requirements

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).

Nice To Haves

Expertise in marketing reporting, tracking and measurement, segmentation and attribution.
Experience with dbt, Looker, Snowflake/Redshift/Trino, or Python.
Experience with experiment design (test/control) or marketing mix models.
Experience with ETL pipelines or marketing data sources (ad platforms, ESP/CRM data such as Iterable).

Responsibilities

Use SQL to analyze marketing performance, customer retention, pricing, and consumer segments, and turn findings into clear recommendations for stakeholders.
Build and maintain dbt models in our marketing data warehouse — shipping work as tested, peer-reviewed pull requests following team architecture standards.
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.
Design and measure test/control campaign lift, and support the data pipelines behind email/CRM targeting.
Build Looker dashboards and reporting for stakeholders, and automate manual reporting workflows.
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.
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.