Technical Analyst – Market Intelligence
Substack
full-time
Posted on:
Location Type: Hybrid
Location: San Francisco • California • 🇺🇸 United States
Visit company websiteSalary
💰 $150,000 - $210,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AirflowJavaScriptNode.jsReactSQLTypeScript
About the role
- 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
Requirements
- 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
- market competitive salary
- equity for all full time roles
- exceptional benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLSnowflakeAirflowTypeScriptReactNode.jsdata pipelinesclustering analysismarket mappingaudience segmentation
Soft skills
problem solvingproduct senseindependencecreativitystakeholder collaborationcommunicationadaptabilityattention to detailautonomyunderstanding user needs