Senior Product Analyst (dbt) at SpotOn | Chicago, USA | Rezi

Senior Product Analyst (dbt) at SpotOn

Senior Product Analyst (dbt)

SpotOn · Chicago, USA

1 months ago

Senior Product Analyst (dbt)

SpotOn · Chicago, USA

2 months ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

SpotOn is seeking a strategic, highly collaborative, and deeply analytical Senior Product Data Analyst to partner with a designated pod or product area. This role will own complex behavioral analyses end-to-end, driving data-informed decision-making by partnering closely with product managers, engineers, and designers to shape product strategy, uncover user interactions within our software and hardware ecosystems, and translate findings into actionable recommendations.

Responsibilities

  • Conduct deep-dive cohort, funnel, and segmentation analyses to diagnose merchant churn, optimize activation paths, and map feature adoption profiles.
  • Translate complex behavioral patterns into actionable recommendations influencing product prioritization and roadmap direction.
  • Establish clear intake workflows, project boundaries, and self-serve frameworks to scale analytics capabilities.
  • Enable cross-functional stakeholders to answer baseline data questions independently via BI tools.
  • Partner with data engineering to design and maintain clean, performant data models in dbt.
  • Transform raw event-tracking data into structured, reusable tables.
  • Partner with product managers to define definitive success criteria and tracking requirements before new features launch.
  • Collaborate with engineering to ensure instrumentation is accurate, audit pipelines for data gaps, and mitigate data debt.
  • Define team's core metric frameworks and tracking standards.
  • Mentor junior-level analysts, lead documentation or training efforts, and set a high bar for analytical rigor and execution.

Requirements

  • Strong SQL skills and proven experience using dbt to transform raw data into production-grade analytics tables inside a cloud data warehouse (e.g., Snowflake).
  • Practical experience leveraging a modern data stack, specifically combining dbt with behavioral event tools (e.g., Heap) or flexible business intelligence platforms (e.g., Metabase).
  • Active use of modern AI assistants to accelerate workflow (code generation, debugging, automated documentation) paired with a practical understanding of how data structures must be formatted to feed AI-driven application layers.
  • Strong grasp of how product metrics drive core business outcomes (retention, conversion, revenue).
  • Ability to translate complex data into clear, contextual narratives that influence product strategy.
  • A proactive partner who thrives in ambiguity, confidently challenges assumptions with data, and works cleanly across product and engineering boundaries to solve problems.
  • Experience in point-of-sales (POS), or the Food and Entertainment industry.
  • Experience with Python, Jinja, or reverse ETL workflows.
  • Experience developing and managing centralized semantic/metric layers or data catalogs optimized for LLM text-to-SQL utilities.
  • 4+ years of progressive experience in product analytics, data analytics, or a related data field.
  • Work authorization in the U.S. is required.

Skills

  • SQL
  • dbt
  • Snowflake
  • Heap
  • Metabase
  • AI assistants
  • Python
  • Jinja
  • Reverse ETL

Location

  • Hybrid

Work Type

  • Hybrid
  • Full-time

Experience Level

  • Senior
  • 4+ years

Education Level

  • Bachelors in a quantitative field of study

Salary/Compensations

  • $119,000 - $142,000

Benefits

  • Medical, Dental and Vision Insurance
  • 401k with company match
  • RSUs
  • Paid vacation, 10 company holidays, sick time, and volunteer time off
  • Employee Resource Groups
  • Monthly cell phone and internet stipend
  • Tuition reimbursement for up to $2,000 per calendar year

About the Company

  • SpotOn is building restaurant tech, giving independent restaurants the tools to compete and win with award-winning point-of-sale and AI-powered profit tools.
  • Named the #1 Restaurant POS by G2 (Fall 2025).
  • Rated the top-rated point-of-sale (POS) for restaurants, bars, retail, and small businesses by Capterra users.
  • Awarded Great Places to Work and Built In’s Best Workplaces for multiple years running.
  • We move fast, care hard, and fight for independent restaurant operators to do what they love, and love doing it.
  • We are known for our innovative software and technology solutions, and we stand out because of the hard-working humans behind the tech.
  • We can’t take care of our clients without taking care of our employees first.

Equal Opportunity

  • SpotOn is an equal employment opportunity employer. Qualified candidates are considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, military or veteran status, disability, or any other characteristic protected by applicable law.
  • SpotOn is an E-Verify company.