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.

 

• 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