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.
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
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 (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.