# Marketing Analyst

**Company:** [SpotHero](https://hotfix.jobs/companies/spothero)
**Location:** Chicago, IL
**Role:** Data Analytics
**Salary:** $68k – $86k/yr
**Experience:** 2+ years
**Skills:** SQL, dbt, Git, Looker, Python, Snowflake, Redshift, trino, ETL, marketing mix modeling, A/B Testing
**Posted:** 2026-07-16

> Marketing Analyst responsible for SQL analysis, dbt data modeling, attribution, CRM measurement, and building Looker dashboards to drive marketing, finance, and cross-functional decisions at SpotHero. Requires 2+ years analytics experience and strong SQL skills.

## Job Description

## What you will do

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

## Who you are

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

## What you bring

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

## You may also have

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

## Compensation in Illinois

Depending on your skillset and experience, you can expect your base salary to be between $68,000 - $86,000 as well as a discretionary bonus, and leading total rewards package.

## Similar roles

- [Media Insights Associate](https://hotfix.jobs/jobs/9a77f05b-15b5-42ec-8367-8cbc318dfe60) - Muck Rack - Remote - $70k – $80k/yr
- [Data Science Analyst](https://hotfix.jobs/jobs/602c47dd-c4cf-4b97-82db-6774f920850f) - Tatari - New York, NY - $70k – $85k/yr
- [Data Analyst, Revenue Operations](https://hotfix.jobs/jobs/c21b304f-1340-4e7b-b5a4-4e5569fbec74) - NMI - Remote - $65k – $85k/yr
- [Actuarial Analyst II](https://hotfix.jobs/jobs/d5957bdc-00f1-435c-ac1d-21639d4e98e2) - Openly - Remote - $77k – $128k/yr
- [Energy Markets Analyst](https://hotfix.jobs/jobs/a1557fe4-4f65-4ab8-9b6c-42219c1098a6) - Voltus - Remote - $80k – $95k/yr

**Apply:** https://hotfix.jobs/jobs/0a191207-2362-404f-924c-a399819c4f0e
**Canonical:** https://hotfix.jobs/jobs/0a191207-2362-404f-924c-a399819c4f0e