JobsSpotHero

Marketing Analyst

SpotHero · Chicago, IL · Marketing

Posted Jul 24, 2026 · We last checked this listing on Sep 20, 2026

Apply at SpotHero

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

Behavioral

Tell me about a time you found a data quality issue before it caused a bad decision. How did you catch it and what did you do next?

proactive vigilance around data correctness and whether they escalate rather than quietly fix and move on

Tell me about a time you had to explain a technical or statistical finding to someone who wasn't analytically minded. How did you adjust your explanation?

ability to translate technical work into plain language for non-technical partners like Sales or Customer Service

Describe a project where you automated a manual reporting process. What made you decide it was worth automating, and what was the outcome?

initiative and cost-benefit thinking around engineering time versus recurring manual effort

Tell me about a time you had to push back on a request because the scope wasn't clear or the ask didn't make sense. How did you handle it?

whether they ask clarifying questions early rather than building the wrong thing

How comfortable are you picking up new tools like Python or Snowflake on the job, and can you give an example of teaching yourself something technical quickly?

self-directed learning ability, since the role explicitly promises growth into new tools with coaching

Technical

Walk me through a SQL query you've written that used window functions or CTEs to solve a real analysis problem. What was the business question behind it?

whether the candidate has genuine hands-on SQL depth beyond basic joins, not just textbook familiarity

Say you're asked to build a CAC or ROAS report that pulls from paid search, paid social, app store, and affiliate spend data. How would you think about unifying those sources into one attribution model?

understanding of multi-channel attribution logic and the practical mess of reconciling inconsistent spend data

Have you built or maintained dbt models before? If so, walk me through how you approached testing and getting a pull request through peer review.

actual familiarity with dbt workflows and git-based code review, or how quickly they could ramp up if new to it

How would you design a test and control setup to measure the lift from a CRM email campaign?

grasp of experiment design fundamentals like control group selection, contamination risk, and measuring incrementality

What's your experience building dashboards in Looker or a similar BI tool, and how do you decide what belongs on a dashboard versus a one-off analysis?

practical reporting judgment and whether they understand who consumes dashboards and why

Situational

Imagine Finance and the CRM team ask for conflicting numbers on customer retention from the same dataset. How do you figure out what's actually going on?

diagnostic approach to discrepancies and comfort being the referee between stakeholders with competing definitions

If a stakeholder asked you to help evaluate whether a new parking partnership was worth pursuing, what data would you want and how would you structure the analysis?

ability to scope an open-ended business question into a concrete analytical plan

Suppose you're asked to help flag fraud or account abuse using marketing and transaction data. What kind of patterns or signals would you look for first?

analytical creativity applied to an unfamiliar, less structured problem outside core marketing metrics

Practice this interview out loud.

Offer builds a real interview for this exact role at SpotHero from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by SpotHero.

<h3><strong>Who we are:&nbsp;</strong></h3> <p>At SpotHero, we work as a team to empower people to get everywhere, easier! We’re rapidly growing with the mission of bringing the parking industry into the future through technology. Drivers across the nation use the SpotHero mobile app and website to reserve convenient, affordable parking in advance, on-the-go or through their connected cars, and parking companies rely on us to help them reach new customers while optimizing their business. We connect the dots with cutting-edge technology, delivering value to both sides of this exciting, evolving marketplace. We’ve been quite busy, take a peek at some of our recent&nbsp;<a href="https://spothero.com/press/">announcements</a>.</p> <p>&nbsp;</p> <h3><strong>Marketing Analyst at SpotHero:&nbsp;</strong></h3> <p>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.</p> <p>&nbsp;</p> <h3><strong>What you will do:&nbsp;</strong></h3> <ul> <li>Marketing analytics: use SQL to analyze marketing performance, customer retention, pricing, and consumer segments, and turn findings into clear recommendations for stakeholders.</li> <li>Data modeling: build and maintain dbt models in our marketing data warehouse — shipping work as tested, peer-reviewed pull requests following team architecture standards.</li> <li>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.</li> <li>CRM and campaign measurement: design and measure test/control campaign lift, and support the data pipelines behind email/CRM targeting.</li> <li>Reporting and dashboards: build Looker dashboards and reporting for stakeholders, and automate manual reporting workflows.</li> <li>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.</li> <li>Data quality: proactively identify and fix data-correctness issues, and flag discrepancies to stakeholders before they mislead decisions.</li> <li>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.</li> </ul> <p>&nbsp;</p> <h3><strong>Who you are:</strong></h3> <ul> <li><em>Analytical</em> - Your strong quantitative skills lend to creative and effective problem solving.</li> <li><em>Inquisitive</em> - 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.</li> <li><em>Data-driven</em> - Your attention to detail is excellent. You are obsessive about measurement and can synthesize data into insights and recommendations.</li> <li><em>Collaborative</em> - You communicate technical findings clearly to non-technical partners and keep stakeholders informed as work progresses.</li> </ul> <p>&nbsp;</p> <h3><strong>What you bring:&nbsp;</strong></h3> <ul> <li>Strong SQL, including joins, subqueries, CTEs, and window functions.</li> <li>2+ years experience in data analysis, marketing analytics, or analytics engineering.</li> <li>Experience with (or strong interest in learning) dbt and git-based development workflows, including code review.</li> <li>Working knowledge of relational databases and spreadsheet analysis (pivot tables).</li> </ul> <p>&nbsp;</p> <h3><strong>You may also have:&nbsp;</strong></h3> <ul> <li>Expertise in marketing reporting, tracking and measurement, segmentation and attribution.</li> <li>Experience with dbt, Looker, Snowflake/Redshift/Trino, or Python.</li> <li>Experience with experiment design (test/control) or marketing mix models.</li> <li>Experience with ETL pipelines or marketing data sources (ad platforms, ESP/CRM data such as Iterable).</li> </ul> <p>&nbsp;</p> <h3><strong>Seeking Candidates in:&nbsp;</strong></h3> <ul> <li>Chicago, Illinois&nbsp;</li> </ul> <h3><strong>What we are offering:</strong></h3> <ul> <li>Career game changer – A truly unique experience to work for a fast-growing company in a role with unlimited growth potential.</li> <li>Excellent benefits</li> <ul> <li>We cover a generous portion of Medical Premiums, 50% of Dental and Vision Premiums, company-sponsored Life Insurance, STD, and AD&amp;D coverage, a 401(k) with match and immediate vesting, and comprehensive leave policies to meet your needs in creating space for life.</li> </ul> <li>Flexible PTO policy and outstanding work/life balance – We value and support each individual team member.</li> <li>UberEats weekly lunch stipend for in-office days&nbsp;</li> <li>Udemy License and Personal Learning Budget – We support the professional and personal growth of our people by providing everyone with learning resources and development opportunities.&nbsp;</li> <li>Annual parking stipend – Duh. We help people park!</li> <li>The opportunity to collaborate with fun, innovative, and passionate people in a casual yet highly productive atmosphere.</li> <li>Our commitment to allyship has been a central driver of how we Respect Fellow Drivers. You’ll have the opportunity to be part of Employee Resource Groups, access allyship learning resources, and actively contribute to our ongoing effort of making SpotHero inclusive for all.</li> <li>Employee programs to grow and support our people such as Discovery Days for Product and Engineering, Gearing up for Aspiring Leaders, and Mentorship Program.&nbsp;</li> <li>Wellness program – a workplace that actively supports your physical and mental wellbeing through ongoing events, initiatives, resources, and thoughtful perks and benefits.&nbsp;</li> <li>A workplace recognized as&nbsp;<a href="https://1871.com/1871-news-and-content/1871-momentum-awards-winners-2023/">CityLights award winner&nbsp;</a>by 1871,&nbsp;<a href="https://builtin.com/awards/chicago/2026/best-midsize-places-to-work#spothero">2026 Best Places To Work&nbsp;</a>by BuiltIn,&nbsp;<a href="https://mostlovedworkplace.com/companies/spothero/">Most Loved Workplace Certified</a>&nbsp;by the Best Practice Institute, and recipient of multiple Comparably awards, including&nbsp;<a href="https://www.comparably.com/companies/spothero">Best Company Culture, Best Company for Women, and Best Company for Diversity.</a></li> </ul> <h3>&nbsp;</h3> <h3><strong>Compensation in Illinois</strong>:</h3> <ul> <li>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.</li> </ul> <p>&nbsp;</p> <p>&nbsp;</p> <p>At SpotHero, we Respect Fellow Drivers by providing an inclusive interview experience for everyone, including people with disabilities. We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process. Please let our team know of your need when you apply or as you begin interviewing with our team.</p> <p>SpotHero is an equal opportunity employer. We know that a diverse workforce is the strongest workforce, and are committed to building and supporting an inclusive environment for all.Additionally, because we want to Remember to Signal, if you choose to provide us personal information in connection with a job application, please review our&nbsp;<a href="https://spothero.com/legal/applicant-privacy-notice" target="_blank">Applicant Privacy Notice&nbsp;</a>which provides details about what information we collect and process about you in order to consider your candidacy.</p> <p>PLEASE NOTE: This position is ineligible for visa sponsorship. To be considered for this role, you must be legally authorized to work in the US and not require sponsorship for employment now or in the future.</p>

Apply at SpotHero

Related jobs

Senior Data Engineer I

SpotHero · Chicago, IL

Posted Sep 18 · Verified Sep 20

Affiliate Marketing Specialist (Contract to Hire)

SpotHero · Chicago, IL

Posted Sep 9 · Verified Sep 20

Senior Product Manager, Acquisitions

SpotHero · Chicago, IL

Posted Sep 4 · Verified Sep 20

Digital Marketing Specialist II (SEM)

SpotHero · Chicago, IL

Posted Aug 27 · Verified Sep 20

Join Our Talent Community!

SpotHero · Chicago, IL

Posted Mar 9 · Verified Sep 20