Analytics Engineer

The Role

Pilot is building a first-of-its-kind, software-centric solution to tackle the financial back office (bookkeeping, tax, CFO, etc.) so that founders and business owners don’t have to. We already work with 2,000+ tech startup and SMB customers and are expanding rapidly. The data team plays a pivotal role in driving Pilot’s growth.   As an Analytics Engineer, you’ll improve and expand our data capabilities, with an emphasis on contributing to our ELT process and ensuring the integrity of company-wide core metrics. You’ll work cross-functionally to identify analytics and BI tooling needs, optimize data workflows, and scale data pipelines to support self-service analytics. You will play a key role in defining, maintaining, and improving core metrics that drive strategic decision-making across the company. This is a high-impact role with the potential to drive data-fueled productivity and shape our data culture.

Key Responsibilities

• Design, build, and maintain scalable data models that are clean, tested, and well-documented.
• Expand our data warehouse with clean, analysis-ready data.
• Own and manage tools across our data stack, including Snowflake, dbt, Fivetran, and Looker.
• Collaborate with stakeholders to ensure we’re solving the right business problems.
• Define and improve internal standards for maintainability and best practices in a high-scale data infrastructure.
• Ensure company-wide core metrics are built and maintained with the highest quality.
• Enable business stakeholders and analysts to leverage data effectively for decision-making.
• Establish data governance processes to ensure consistency and accuracy of key metrics.

About you

• 5+ years of experience in data engineering or analytics engineering.
• Expert-level knowledge of SQL and Python.
• Experience building and maintaining data pipelines and workflows.
• Familiarity with ETL/ELT tools (e.g., Fivetran, Airbyte, Census).
• Ability to work collaboratively across functions.
• Strong communication skills for explaining complex technical topics.
• Experience with Looker is a plus.
• Ability to commute to the Downtown SF office twice a week (Tuesdays, Thursdays).

About Pilot

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 1,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.

Why Pilot?

• We invest in our employees’ development and happiness because our employees are the keys to our success and ensuring happy customers
• The opportunity to join a seasoned founding team that has led companies through two prior successful startups and acquisitions (by Oracle and Dropbox)
• Flexible vacation/time-off policy
• All federal holidays are observed
• Competitive benefits package including wellness benefits
• Parental leave for birthing or non-birthing parents – 100% pay for 12 weeks
• 401(k) plan

  The base pay range target for the role seniority described in this job description is $156,000 - $211,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, recruitment agency policy, recruitment scam notice, and important E-Verify information. You may view our job candidate privacy policy here.