Senior Product Analyst (dbt)

SpotOn • Austin, TX

3d • $119,000 - $142,000 • Hybrid

About The Position

We are looking for a strategic, highly collaborative, and deeply analytical Senior Product Data Analyst to join our team. In this role, you will act as the go-to partner for a designated pod or product area, owning complex behavioral analyses end-to-end to drive data-informed decision-making. You will partner closely with product managers, engineers, and designers to shape product strategy, uncover how restaurants interact with our integrated software and point-of-sale (POS) hardware ecosystems, and translate your findings into clear, actionable recommendations. As a Senior Analyst, you will strike a balance between high-impact product partnership and technical rigor. You will ensure our product data is cleanly modeled in dbt, accurately interpreted today, and well-positioned to leverage modern analytical tools tomorrow.

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 your own 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.
• Min: Bachelors in a quantitative field of study
• Work authorization in the U.S. is required.

Nice To Haves

• 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.

Responsibilities

• Drive Strategic Product Insights: Move beyond basic reporting to conduct deep-dive cohort, funnel, and segmentation analyses that diagnose merchant churn, optimize activation paths, and map feature adoption profiles. Translate complex behavioral patterns into actionable recommendations that directly influence product prioritization and roadmap direction.
• Scale Analytics Through Governance: Establish clear intake workflows, project boundaries, and self-serve frameworks to scale analytics capabilities across your product pod. Enable cross-functional stakeholders to answer baseline data questions independently via BI tools, freeing up your time to focus on high-leverage strategic initiatives.
• Own Product Data Transformation (dbt): Take ownership of your pod's data layer by partnering with data engineering to design and maintain clean, performant data models in dbt. Transform chaotic, raw event-tracking data—such as hardware telemetry, digital menu clicks, and ticket processing strings—into structured, reusable tables (like formalized merchant health and feature adoption marts).
• Define Metrics & Champion Tracking Quality: Partner with product managers to define definitive success criteria and tracking requirements before new features launch. Tightly collaborate with engineering to ensure instrumentation is accurate, audit pipelines for data gaps, and aggressively mitigate data debt.
• Define the Standards & Elevate the Team: Actively help define our 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.

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 to build community and inclusion at work
• Monthly cell phone and internet stipend
• Tuition reimbursement for up to $2,000 per calendar year to assist with your professional development

What This Job Offers

• Job Type: Full-time
• Career Level: Senior