This job is closed
We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.
About the position
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.
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.
Requirements
- 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).
Benefits
- 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
A Smarter and Faster Way to Build Your Resume