Product Analyst
At a glance
Mid-level Data Analysis & BI role at Substack. San Francisco · full-time · $130,000–$225,000 base.
dataroles summary, based on the employer's posting.
What you'll do
- Keep building a clearer picture of product use, the user base, growth and overall performance
- Work with product managers and leaders to shape near- and long-term plans for your product area
- Help teams choose useful metrics, set goals and share regular findings across the company
- Partner with engineers to improve event logging, data pipelines and the usability of analytics data
What you bring
- At least four years working as an analyst or in a similar technical role
- Strong SQL skills, plus experience with BI tools such as Snowflake or Periscope
- You understand product growth measures, experimentation design and how to interpret test results
- You can build readable dashboards and explain the key findings from an analysis clearly
- A strong grasp of Substack’s product, users and market position
Who this fits
This role suits a hands-on product analyst who can work independently with limited resources and communicate findings to teams and company leaders. It is a hybrid, full-time position based in San Francisco.
From the employer
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.
Product Analytics at Substack
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 sixth individual on 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.
Experience working with Trust & Safety and/or Sales and Partnerships data is a plus!
Substack’s compensation package includes a market competitive salary, equity for all full time roles, and exceptional benefits. Our cash compensation salary range for this role is $130,000 - $225,000. Final offer amounts are determined by multiple factors including candidate experience and expertise and may vary from the amounts listed above.
Substack is an equal opportunity employer. All applicants will be considered for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, gender identity or transgender status), age, national origin, veteran or disability status. We’re seeking people passionate about enabling independent expression and building a better business model for creators. If you want to see what media, communities, and content can become when unmoored from advertising models, and you have the skills and experience to contribute, we’d love to meet you.
Please see our Privacy Notice for details regarding Substack's collection and use of personal information relating to the application and recruitment process by clicking here.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI$130k+
Find me workBy the team behind dataroles.