Senior Analytics Engineer
Job Location:
San Francisco, CA - USA
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
- Architect Pilots data foundation: the warehouse layout the semantic layer and the access patterns that let humans and AI agents use Pilots data safely and well
- Methodically plan what each domains data needs to look like then ship it as durable well-documented well-tested models in dbt
- Lead the ingestion of new data sources as the business expands: scope whats needed choose the right pattern (Fivetran custom Airflow DAG or partner share) and ship it production-grade with tests and docs
- Keep the foundation reliable and clean: operate it as a production system and continuously retire whats stale
- Build AI tools and workflows that uplevel the data teams 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
- Set the technical standards: testing documentation naming materialization deprecation code review
- Own Pilots canonical metrics across the company (including Finance Sales Operations and Marketing)
- 5 years experience as an Analytics Engineer or Data Engineer with end-to-end ownership of a production warehouse and modeling layer
- A track record of architecting data platforms that other teams build on
- Strong SQL and production dbt experience at meaningful scale including layered architecture tests documentation and CI
- Snowflake or comparable cloud data warehouse experience
- Experience with a semantic layer (LookML dbt Semantic Layer Cube MetricFlow or comparable)
- Experience streamlining data processes with AI dev tools and building AI workflows or agents that teammates use day-to-day
- Working Python proficiency for ingestion code (extending or writing Airflow DAGs building custom connectors) plus hands-on experience with managed ingestion (Fivetran or comparable) and reverse-ETL (Census or comparable)
- Cares about driving a company-wide data-driven culture through easy data access and self-service
- Drives to find new tools and ways of working and spreads them to uplevel the team
- Takes pride in end-to-end ownership. Cares about how the platform looks and works with a point of view about where it should go
- Experience setting up safe audited AI access to a data warehouse (allow-listed schemas audit logs kill switches)
- Experience designing data platforms that non-data teams build self-serve workflows on top of
- Airflow production experience
- dbt Cloud experience
- Looker administration experience (permissions content curation Spectacles LAMS)
- Data observability experience (Elementary Monte Carlo or comparable)
- Fintech accounting software or B2B SaaS data background
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 3000 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 Fintechs Newest Unicorn.
- 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 additional 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 $166000 - $224000 in San Francisco CA. Final offer amounts depend on multiple factors such as candidate experience and expertise geographic location total compensation and market 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 Pilots 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.
Required Experience:
Senior IC
About Company
One team for all your accounting needs. Pilot handles your bookkeeping, taxes, forecasting and more. See why thousands of businesses trust Pilot.
