Data - job 1 of 2

San Francisco or New York City

The data team at Substack is focused on delivering insights to our different business units. To accomplish this task, we build data infrastructure; we deeply scrutinize our data; we construct reports; and we measure everything. If you have a passion for investigating what makes a growing business tick, and if you enjoy exploring data across our entire ecosystem, then we want to talk with you.

We are looking for an individual familiar with contemporary software development and processes and a well-stocked analyst's toolbox to join in helping us shape our data-driven culture. You will be an early leader in establishing key product metrics, enabling the company to learn from our data, answering key questions, and making better decisions.

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 $140,000 - $200,000. Final offer amounts are determined by multiple factors including candidate experience and expertise and may vary from the amounts listed above.

Responsibilities

• Deeply understand the behaviors of Substack readers and writers
• Explore, measure, and track metrics related to the Substack ecosystem
• Derive denormalized tables to enable simplified analytics
• Partner with product teams on developing key metrics and testing intuitions with data to inform better decision making
• Develop data insights that can empower Substack writers to better understand their newsletters

Requirements

• 5+ years experience in product analytics
• Love analyzing problems with data and synthesizing results to tell the narrative of the product
• Have strong expertise in SQL (we use Postgres + Snowflake) and event-based analytics and metrics
• Understand growth funnels and how to measure them
• Enjoy building dashboards (Sisense/Periscope Data) to memorialize findings and monitor key metrics
• Believe that building canonical datasets can empower an organization
• Have a proven track record of making meaningful impacts through data insights and discovery in past roles
• Nice to haves: Airflow, Python, Node

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.