Marketing Analyst
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.
About the job
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.
Skills
SQL, dbt, Git, Looker, Python, Snowflake, Redshift, Trino, ETL, Marketing Mix Modeling, A/B Testing
Similar jobs
Data Analytics jobs
Northwood Space
Torrance, CA
Build ETL pipelines, predictive models, dashboards, and scenario analyses to improve demand forecasting, inventory, supplier risk, and operational decision-making. The internship requires strong analytical skills, Excel proficiency, and pursuit of a relevant degree.
Check
United States
The Risk Analyst conducts company reviews, monitors payroll activity, investigates fraud, and analyzes emerging risk signals. The role requires 1–3 years of risk or fraud investigation experience, strong case-management and communication skills, and sound judgment in ambiguous situations.
Crusoe
Denver, CO
The Strategic Sourcing Data Analyst analyzes procurement data, builds reporting and predictive models, and develops AI-enabled workflows to improve sourcing decisions, cost savings, and operational efficiency. The role requires 2–4 years of analytics experience, strong SQL and visualization skills, and familiarity with procurement systems.
Lyft
Nashville, TN
Investigates fraud, analyzes emerging patterns and false positives, and develops operational and analytical controls to reduce financial and reputational risk. The role requires a bachelor's degree, 1–2 years of fraud or risk monitoring experience, strong analytical judgment, and basic SQL knowledge.
Garner Health
New York, NY
The Data Analyst I will produce and automate client-facing healthcare reports, investigate complex business questions, and deliver actionable insights in partnership with client-facing and data engineering teams. The role requires 1–2 years of analytics experience, SQL at scale, and hands-on experience with Snowflake or a comparable warehouse.