Data Analyst

Substack

Substack lets writers connect with their audience on their own terms and earn money doing it. We make it simple for writers to publish to an email list that they own, get discovered on the web, and charge for subscriptions.

More than 1 million people pay to subscribe to writers across the Substack network, and the top writers make millions of dollars a year. Substack’s model depends on the success of writers using Substack – we only make money when they do.

_“Substack makes it dead simple to start a newsletter and get paid for it.” – _Judd Legum, author of Popular Information

_"Substack gives me a way to connect with my audience on my own terms.” – _Lyz Lenz, author of God Land and Men Yell At Me

Make something that matters

Great writing is valuable. It respects readers' time, their intelligence, and their trust. It helps us make sense of and change the culture we live in. At Substack, we're building a business model that enables great writing to thrive. Learn more about our opportunity and mission. 

We are a small but growing team, and there is more to build than we could ever imagine. That’s why we need you.

Every person at the company participates in customer support. We do this to build empathy with our users and enable us to build better products.

We believe that a diverse team will help us build a product that best serves the needs of a wildly diverse ecosystem of writers. So whatever your background or perspective, we’d welcome your input to help build the best possible version of Substack.

Data at Substack

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.

This position is based in San Francisco but can be remote.

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

• 4+ years experience in product analytics
• Love analyzing problems with data and synthesizing results to tell the narrative of the product
• Have expertise in SQL (we use Postgres + Snowflake) and event-based analytics and metrics (à la Segment)
• 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, other DAG tool experience, Python, Node

Substack is an equal opportunity employer. All applicants will be considered for employment without regard to race, color, religion, sex, sexual orientation, age, gender identity, 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.