Sr. Data Analyst

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 2000+ customers and are expanding rapidly, and the data team has a pivotal role in driving Pilot’s growth.   As a data analyst at Pilot, you'll join a group of high-performing and motivated data professionals focused on impact and collaboration. You’ll work closely with stakeholders across the organization to solve business-critical problems with your analytical skills.   We are seeking an individual who has demonstrated success in leveraging data to solve real-world business problems. You’re passionate about using data to solve hard problems, and you’re an expert in analyzing complex data and crafting compelling narratives to communicate your insights.

Key Responsibilities

• Perform deep-dive analyses to uncover insights and influence business decisions
• Create and maintain company-wide metrics and reporting in Looker
• Build high-quality DBT pipelines to automate data analysis and empower scalable analytics
• Handle ad-hoc data requests, while addressing stakeholder teams’ long-term goals
• Train and mentor other teams on how to best use data to drive their decisions

About You

Our requirements for this role are:

• 5+ years of relevant experience as data analyst
• Experience leveraging data to inform business decisions
• Expert-level knowledge of SQL
• Experience with scripting languages such as Python
• Experience with BI tools such as Looker
• Strong communication skills
• Ability to commute to the Downtown SF office twice a week (Tuesdays, Thursdays)

Here are some preferred qualifications:

• Experience working with sales, marketing, or finance teams
• Experience with DBT, Snowflake, and Fivetran
• Experience working with Salesforce and Zuora data

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 2,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 $126k - $170k 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.