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. 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 docs.google.com.

Requirements

Must-haves

Product Analytics at Substack
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.
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.

Nice-to-haves

Experience working with Trust & Safety and/or Sales and Partnerships data is a plus!

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: ashby
Effort: quick