Marketing Data Analyst: SQL, Looker, dbt

SpotHero; Chicago (IL); On-site; USD 68,000 - 86,000; Full time

Benefits offered by this job

Medical premiums

Dental/Vision premiums 50%

Life Insurance

401(k) with match

Unlimited PTO

Lunch stipend

Learning budget

Parking stipend

Mentorship program

Wellness program

Job summary

SpotHero is seeking a Marketing Analyst to deliver data-driven decision support for our fast-paced ecommerce marketplace. You will join the Marketing Analytics team, powering CAC reporting, marketing mix modelling, and decisions across Marketing, Finance, Sales, CRM, and Customer Service.

You will analyze marketing performance with SQL, build dbt models, maintain attribution models, design campaign lift tests, and create Looker dashboards while supporting cross-functional partnerships and data

Qualifications

• 2+ years of experience in data analysis, marketing analytics, or analytics engineering.
• Experience with dbt and git-based development workflows.
• Strong SQL skills with joins, subqueries, CTEs, and window functions.
• Working knowledge of relational databases and spreadsheet analysis.

Responsibilities

• SQL-based marketing performance analysis and stakeholder recommendations.
• Build and maintain dbt models in the marketing data warehouse.
• Maintain marketing spend and attribution models across channels.
• Design and measure test/control campaign lift for email/CRM.
• Create Looker dashboards and automate reporting workflows.
• Collaborate with Finance, Sales, CRM, and Data Science on analyses.
• Identify and fix data quality issues and flag discrepancies.

Skills

SQL

dbt

Python

Looker

Data analysis

Git version control

Tools

Looker

Snowflake

Redshift

Trino

Job description

SpotHero is seeking a Marketing Analyst to deliver data-driven decision support for our fast-paced ecommerce marketplace. You will join the Marketing Analytics team, powering CAC reporting, marketing mix modelling, and decisions across Marketing, Finance, Sales, CRM, and Customer Service.

You will analyze marketing performance with SQL, build dbt models, maintain attribution models, design campaign lift tests, and create Looker dashboards while supporting cross-functional partnerships and data