Pilot
Senior Analytics Engineer
San Francisco, CA · Senior
Sponsorship not specifiedDetected 50 days ago
PythonCode ReviewSQLSnowflakeAirflowdbtData EngineeringData VisualizationAgentic AI
About the role
- Today, with 3,000+ customers and a fast-growing roster of AI-native services, the company runs on data, and the foundation underneath it is being rebuilt to keep up.
- You'll architect the warehouse and the semantic layer, bring new data sources online as the business expands, and operate it like a well-oiled production system.
Responsibilities
- Lead the ingestion of new data sources as the business expands: scope what's needed, choose the right pattern (Fivetran, custom Airflow DAG, or partner share), and ship it production-grade with tests and docs
- Build AI tools and workflows that uplevel the data team's own work (Claude Code skills, MCP-driven agents)
- Enable other teams to safely AI-enable their own workflows on Pilot data. For example, scope governed access surfaces, build the patterns that route them to the semantic layer first, and partner on intake review for new Claude Project integrations
- Own Pilot's canonical metrics across the company (including Finance, Sales, Operations, and Marketing)
- A track record of architecting data platforms that other teams build on
Requirements
- 5+ years experience as an Analytics Engineer or Data Engineer with end-to-end ownership of a production warehouse and modeling layer
- Strong SQL and production dbt experience at meaningful scale, including layered architecture, tests, documentation, and CI
- Experience with a semantic layer (LookML, dbt Semantic Layer, Cube, MetricFlow, or comparable)
- Even if you don't have experience with the specific technologies in our stack, we'd love to talk to you!
Nice to have
- <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo
Skills
- Pilot launched in 2017 to bring the back office into the modern era.
This listing is sourced directly from Pilot's careers page and normalized into a canonical job model.