Product Analyst
San Francisco (HQ) · Remote · USD 130,000-225,000 · 4+ years experience · Full-time · Posted Oct 1, 2026
At a glance
- Experience
- 4+ years experience
- Employment
- Full-time
- Location
- San Francisco (HQ) · Remote
- Salary
- USD 130,000-225,000
About the role
- Product Analytics at Substack is embedded in the Product organization to help the product team make better decisions.
- The team is small and scrappy, covering a lot of ground as the fourth individual joining the team.
Responsibilities
- Take ownership of continuously improving our understanding of the product, user base, growth trajectory, and state of play.
- Proactively partner with PMs and company leadership to inform the long term, medium term, and short term strategy of your product area.
- Help the team define useful metrics and set clear goals.
- Share regular insightful updates with your team and across the company.
- Proactively partner with engineers to invest in clean and thorough logging, ETL, and improving the ergonomics of our data.
Requirements
- 4+ years of experience as analyst or in a similar technical role.
- Solid understanding of product growth concepts and frameworks (e.g. retention curves, cohort analysis, growth accounting).
- Advanced SQL knowledge, and familiarity with BI tools (we use Snowflake and Periscope every day).
- Strong data visualization and written/verbal communication skills, must be able to design legible dashboards dashboards and clearly convey the salient insights for any analysis.
- Solid understanding of A/B test and experimentation concepts (proper test design, power calculation, post-hoc analysis, novelty effects, etc.).
- Strong product sense and intuition, a deep understanding of Substack’s product, user base, and market position is a must.
- Ability to roll up your sleeves and do what needs to be done with limited resources and support.
Preferred qualifications
- Experience working with Trust & Safety and/or Sales and Partnerships data is a plus!
Benefits
- market competitive salary
- equity for all full time roles
- exceptional benefits
Skills
- SQL
- Snowflake
- Periscope
- ETL
- Data Visualization