Substack · 3 days ago
Technical Analyst - Market Intelligence
San Francisco, CA
Full-time
Hybrid
Mid, Senior Level
$150K/yr - $210K/yr
4+ years expSubstack is building a new economic engine for culture, empowering creators with economic autonomy and a direct connection to their audiences. They are seeking a scrappy technical talent to join their Market Intelligence team, where the role involves building internal tools and data pipelines to enhance market understanding and support growth initiatives.
Content CreatorsMedia and EntertainmentNewsPublishingSubscription Service
Responsibilities
Build and maintain the internal operating system that provides a real time view of the network, both on Substack and off-platform
Design and implement data pipelines that synthesize information from diverse sources, including hard-to-find public data into actionable intelligence
Work with large network datasets on clustering analysis, market mapping, and audience segmentation
Partner with internal stakeholders to understand their underlying needs, then build tools that exceed their expectations
Ship code every day, while maintaining high standards for quality and legibility
Qualification
Required
4+ years of experience in software engineering, data engineering, or a related technical role
Proficiency in SQL and modern data tools (Snowflake, Airflow, etc.)
Full-stack web development skills (TypeScript, React, Node.js)
Proven ability to use LLMs as a force multiplier in your development workflow. You should be fluent in building software with AI and well-versed enough to understand its limitations
Sound engineering fundamentals: you can write robust, non-buggy, legible, and scalable code, even when heavily LLM-assisted
Experience working with large datasets for network products, familiarity with graph analysis, clustering algorithms, and market segmentation
Experience with data acquisition from public sources (web scraping, API integration, data enrichment)
Hacker mindset: you get creative to solve hard problems and aren't blocked by ambiguity
Strong product sense: You understand what people actually need, not just what they ask for
Independent and autonomous; comfortable owning projects end-to-end with minimal direction
Benefits
Equity for all full time roles
Exceptional benefits
Company
Substack
Substack is a subscription-based newsletter publishing platform for independent writers.
51-200 employees
H1B Sponsorship
Substack has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (8)
2024 (1)
2022 (3)
2021 (2)
Funding
Current Stage
Growth StageTotal Funding
$200.23MKey Investors
Andreessen HorowitzFifty YearsY Combinator
2025-07-17Series C· $100M
2024-11-12Series Unknown· $10M
2023-05-26Equity Crowdfunding· $7.81M
Leadership Team
Hamish McKenzie
Co-founder and Chief Writing Officer
Jairaj Sethi
CTO
Recent News
2025-12-26
BiometricUpdate.com
2025-12-17
2025-12-12
Company data provided by crunchbase