Analytics Engineer

Pilot (View all Jobs)

San Francisco, CA

Please mention No Whiteboard if you apply!
I'm a one-man team looking to improve tech interviews, and could use any support! 😄


Interview Process

1. Introduction one (30m) + verification of communication skills and remote work experience (15m) 2. 1 hour DIY practical coding assessment, & feature implementation or bug fix of any app/project of your choosing

Programming Languages Mentioned

ETL, SQL, Python, Java


The Role

We are looking for an analytics engineer to improve and expand our data capabilities, with an emphasis on contributing to our ELT process. As an early member of the data team, this role will act as a full-stack data analyst or engineer. Specifically, this role will work cross-functionally to identify analytics and BI tooling needs, optimize our data workflows, and scale our data pipelines to support self-service analytics. This will be 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 data ready for analysis
  • Become a go-to expert and owner of tools up and down our data stack, including Snowflake, dbt, Fivetran, and Stitch
  • Work with internal customers and stakeholders to ensure we’re solving the right problems
  • Help to define and improve our internal standards for style, maintainability, and best practices for a high-scale data infrastructure

About you

  • 4+ years of experience working in a data engineering or analytics engineering capacity
  • Expert-level knowledge of SQL, dbt, Snowflake
  • Good understanding of object-oriented programming (e.g. Python, Java)
  • Experience with building and maintaining data pipeline and workflows
  • Familiar with ETL/ELT tools (we use Fivetran, Stitch and Census)
  • Able to work collaboratively across functions
  • Clear and direct communication skills about complex, technical topics
  • Experience with Looker is a plus

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 such as Modern Health, Headscape, One Medical, Aaptiv and Rightway
  • Parental leave for birthing or non-birthing parents – 100% pay for 12 weeks
  • 401(k) plan

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.

Please mention No Whiteboard if you apply!
I'm a one-man team looking to improve tech interviews, and could use any support! 😄


Get weekly alerts of new jobs from companies not using whiteboard interviews!