Product Analyst

Substack; United States; Remote; USD 120,000 - 170,000; Full time

Benefits offered by this job

Remote work support

Comprehensive health care

Parental leave

Flexible vacation

Company holidays and Winter shutdown

Phone & internet stipends

Job summary

Substack is seeking a Product Analytics professional to help the product team make better decisions. You will join as the fourth member of the small, scrappy team embedded in Product, taking ownership of product and user insights.

You will proactively partner with PMs and leadership to inform strategy, define metrics, and share clear updates across the company. Strong SQL, BI tool experience (Snowflake/Periscope), and A/B testing expertise are essential.

Qualifications

• 4+ years of experience as analyst or in a similar technical role.
• Advanced SQL knowledge and familiarity with BI tools (Snowflake and Periscope).
• Strong understanding of product growth concepts and frameworks.
• Solid data visualization and written/verbal communication skills.
• Strong knowledge of A/B test design and analysis.
• Strong product sense and understanding of Substack’s product and market.

Responsibilities

• Take ownership of continuously improving understanding of the product and user base.
• Partner with PMs and leadership to inform short-, medium-, and long-term strategy.
• Help define useful metrics and set clear goals.
• Share regular updates with teams and across the company.
• Collaborate with engineers to improve logging, ETL, and data ergonomics.

Skills

Advanced SQL

BI tools

Product growth concepts

Data visualization

A/B testing

Product sense

Substack product understanding

Dashboard design

Tools

Snowflake

Periscope

Job description

• Substack is building a new economic engine for culture, giving the brightest, most interesting, and most creative people on the internet the power of their own publishing platform
• The terms of our culture should not be set by gate-keeping legacy media or chaos-fueling social media, but by the people who make and participate in that culture. Substack’s model, based on direct subscriptions, has fueled an explosion of independent publishing. It empowers creators with economic autonomy, creative ownership, and a direct connection to their most engaged audiences
• The mission of the Product Analytics team at Substack is to help the product team make better decisions. Product Analytics is embedded in the Product organization. We are a small and scrappy team that covers a lot of ground. You would be joining as the fourth individual on the team
• 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

Benefits

• Remote work support - All employees receive a generous allowance to customize their home offices
• Comprehensive health care - Substack covers 100% of premiums for employees and their dependents, and fully funds HRA plans
• Parental leave - We want employees to be fully present for the new members of their family, so we offer generous parental leave
• Flexible vacation and paid time off - You’re the best person to decide when you need a day—or a week—off to travel or decompress. Our flexible vacation policy puts you in control
• Company holidays and Winter shutdown - In addition to flexible time off, we honor 12 paid holidays annually on average. And we close the office between Christmas Eve and New Year’s day to recharge each year
• Phone & internet stipends - Many of our employees work from home or on the go. So we offer full time employees a monthly stipend to cover for phone and internet costs

4+ years of experience as analyst or in a similar technical roleAbility to roll up your sleeves and do what needs to be done with limited resources and supportAdvanced SQL knowledge, and familiarity with BI tools (we use Snowflake and Periscope every day)Solid understanding of product growth concepts and frameworks (e.g. retention curves, cohort analysis, growth accounting)Strong data visualization and written/verbal communication skills, must be able to design legible dashboards dashboards and clearly convey the salient insights for any analysisSolid 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 mustExperience working with Trust & Safety and/or Sales and Partnerships data is a plus!