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 (Looker, dbt, Snowflake) as part of our day-to-day workflow.
Requirements: Even if you don't have experience with the specific technologies in our stack, we'd love to talk to you!
Working Style
Nice to Have
Pilot launched in 2017 to bring the back office into the modern era. Pilot provides small businesses with dedicated finance experts - which Pilot hires as full-time, U.S.-based employees - who learn the ins-and-outs of their business. Pilot integrates directly with the billing, banking, expense, and payroll systems customers already use. With a special blend of custom software and expert bookkeepers, Pilot delivers accurate, consistent bookkeeping and financial management and tax services that give entrepreneurs the freedom to focus on their business.
Pilot has over 3,000 customers and has raised over $170 million in financing from Sequoia, Index Ventures, Stripe, Bezos Expeditions, and Whale Rock. Our investors also include a long list of world-class entrepreneurs, including Patrick and John Collison, Drew Houston, and Diane Greene. Our most recent funding round doubled our valuation to $1.2 billion – Meet Fintech’s Newest Unicorn
The base pay range target for the role seniority described in this job description is $166,000 - $224,000 in San Francisco, CA. Final offer amounts depend on multiple factors such as candidate experience and expertise, geographic location, total compensation, and market data. In addition to cash pay, full-time regular positions are eligible for equity, 401(k), health benefits, and other benefits; some of these benefits may be available for part-time or temporary positions.
Pilot commits to provide a work environment free of discrimination and harassment, as well as equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. You may view all of Pilot’s recruiting notices here, including our EEO policy, information about requesting a reasonable accommodation in the job application process, recruitment agency policy, recruitment scam notice, and important E-Verify information. You may view our job candidate privacy policy here
Pilot provides the most reliable accounting, CFO, and tax services for startups and small businesses. We partner with thousands of companies to help them grow sustainably and operate more effectively.
