Senior Analytics Engineer

The Role Pilot is hiring a Senior Analytics Engineer to own our data foundation: the warehouse, the semantic layer, and the ingestion that every team at Pilot runs on. Pilot launched in 2017 to bring the back office into the modern era. 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. As the Senior Analytics Engineer on this team, you'll own that foundation end-to-end. 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. The work you ship is the foundation every team at Pilot reports, decides, and forecasts against. You own how Pilot's data is shaped, modeled, and surfaced for AI tools, so every team can integrate AI into their workflows safely and reliably. This is a strong fit for someone who strives to enable and empower others, brings a critical eye to processes and looks for opportunities to automate and streamline them, has clear opinions about what good data foundations look like, and treats AI-coding tools as a default part of how they build. Pilot's data stack is Snowflake, dbt, and Looker, with Fivetran and Airflow for ingestion and Fivetran Activations (formerly Census) for reverse-ETL. We use Claude Code or Cursor with governed MCP servers (Lo...