Product Analyst at Substack

San Francisco, California, United States

Substack Logo
Not SpecifiedCompensation
Junior (1 to 2 years), Mid-level (3 to 4 years)Experience Level
Full TimeJob Type
UnknownVisa
Technology, MediaIndustries

Requirements

  • 3-5+ 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 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
  • Ideally located in the San Francisco Bay Area

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

Skills

Key technologies and capabilities for this role

SQLSnowflakePeriscopeETLdata visualizationcohort analysisretention curvesgrowth accountingA/B testingBI toolsdashboards

Questions & Answers

Common questions about this position

What is the salary range for the Product Analyst role?

The cash compensation salary range is $150,000 - $210,000, with final offers determined by factors like experience and expertise.

Is this a remote or hybrid position?

This is a hybrid position, ideally located in the San Francisco Bay Area where most of the product and leadership team are based.

What skills are required for this Product Analyst role?

Required skills include 3-5+ years as an analyst, advanced SQL and BI tools like Snowflake and Periscope, strong data visualization and communication, understanding of A/B testing and product growth concepts, plus strong product sense.

What is the team structure like for Product Analytics at Substack?

The Product Analytics team is small and scrappy, embedded in the Product organization, and this role would be the fourth individual, reporting to the VP of Product.

What makes a strong candidate for this role?

Strong candidates have 3-5+ years of analytical experience, advanced SQL skills, deep knowledge of product growth and A/B testing, excellent communication for dashboards and insights, and strong product sense for Substack specifically, with the ability to work scrappily with limited resources.

Substack

Digital publishing platform for subscription-based content

About Substack

Substack is a digital publishing platform that connects writers and readers. It allows creators, such as authors, journalists, and chefs, to share their work through newsletters, blogs, podcasts, and videos. Creators can set their own subscription fees, ranging from $5 to $27 per month, enabling them to earn money directly from their content without relying on traditional publishing or advertising. Substack handles administrative tasks, billing, and technical support, allowing creators to focus on their writing. The platform also helps creators grow their audience, as a significant portion of new subscriptions comes from within the Substack network. Substack earns revenue by taking a percentage of the subscription fees, aligning its success with that of its creators. The goal of Substack is to empower creators to monetize their work while providing the necessary tools for managing and expanding their subscriber base.

San Francisco, CaliforniaHeadquarters
2017Year Founded
$97.5MTotal Funding
ANGELCompany Stage
Consumer Software, EntertainmentIndustries
1,001-5,000Employees

Risks

Enterprise offering may lead to competition with established solutions, straining resources.
Elon Musk's acquisition interest could cause market speculation and investor instability.
Integration with Polymarket may expose Substack to reputational risks and regulatory scrutiny.

Differentiation

Substack empowers creators with a subscription-based model, bypassing traditional revenue streams.
The platform offers built-in marketing, aiding creators in growing their subscriber base.
Substack's tools support diverse content, including newsletters, blogs, podcasts, and videos.

Upsides

Spotify integration broadens podcasters' reach, potentially boosting subscribers and revenue.
Mobile editor launch enhances accessibility, increasing content output and engagement.
Enterprise offering partnership with The Free Press opens new revenue streams for Substack.

Land your dream remote job 3x faster with AI