Marketing Analyst

Join SpotHero, a fast-growing e-commerce marketplace, as a Marketing Analyst. In this role, you will deliver data-driven decision support, analyze marketing performance, build and maintain data models, and support cross-functional decision-making. You will have the opportunity to enhance your skills and work in a collaborative and innovative environment. Benefits include flexible PTO, an annual parking stipend, and comprehensive medical, dental, and vision coverage.

• Analyser les performances marketing, la rétention des clients, la tarification et les segments de consommateurs en utilisant SQL.
• Construire et maintenir des modèles dbt dans notre entrepôt de données marketing, en expédiant le travail en tant que demandes de tirage testées et examinées par des pairs.
• Aider à maintenir nos modèles de dépenses et d'attribution marketing unifiés à travers les canaux, alimentant les rapports CAC/ROAS utilisés au niveau exécutif.
• Collaborative - You communicate technical findings clearly to non-technical partners and keep stakeholders informed as work progresses
• Analytical - Your strong quantitative skills lend to creative and effective problem solving
• Data-driven - Your attention to detail is excellent. You are obsessive about measurement and can synthesize data into insights and recommendations
• 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
• 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
• Strong SQL, including joins, subqueries, CTEs, and window functions
• Working knowledge of relational databases and spreadsheet analysis (pivot tables)
• Expertise in marketing reporting, tracking and measurement, segmentation and attribution
• Experience with experiment design (test/control) or marketing mix models
• Experience with dbt, Looker, Snowflake/Redshift/Trino, or Python
• Experience with ETL pipelines or marketing data sources (ad platforms, ESP/CRM data such as Iterable)