Business Operations Analyst

Pilot

San Francisco (CA)

On-site

USD 130,000 - 190,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Flexible vacation
Federal holidays observed
Parental leave 12 weeks (paid)
401(k) plan
Development opportunities
Wellness benefits

Job summary

Pilot is seeking a hands-on Operations/Data expert to own and evolve work orchestration systems across the organization. You will build and maintain models to route work as demand and capacity shift, and create real-time KPI dashboards for leadership.

You will also develop forecasting for staffing and billing, ensure accurate billing processes, and drive automation using Excel/Sheets scripting and SQL. Direct collaboration with senior leadership is required.

Qualifications

  • 3–5 years in business operations, analytics, or finance, ideally in a startup or technology-forward environment.
  • Experience owning forecasting, billing, or resource-planning is a strong plus.
  • Expert-level Excel/Sheets (formulas, modeling, automation/scripting) and familiarity with SQL and analytics tools.

Responsibilities

  • Own the systems and processes that plan and allocate work across the organization; build and maintain models that route work as volume and capacity change.
  • Build and maintain KPI reporting that provides leadership with a real-time view of performance and quickly identify anomalies.
  • Develop forecasting models for staffing and capacity needs against demand and translate forecasts into actionable recommendations.
  • Own billing sheet accuracy and QA, including reconciliation at scale.
  • Identify opportunities to automate or leverage AI to replace repetitive work and implement end-to-end solutions.

Skills

Excel/Sheets
Data analytics
SQL
Automation

Tools

Looker
Excel
Sheets

Job description

  • This role sits at the center of how we plan, allocate, and forecast work across the organization, and increasingly, how we automate that work
  • Pilot is moving fast toward agentic, AI-assisted operations, and this person will build and own the systems, models, and reporting that make that shift possible: work orchestration, KPI reporting, resource forecasting, and billing
  • This isn’t a role for someone who wants to build one dashboard and maintain it
  • It’s for someone who wants to keep building better systems as the work itself changes
  • The role requires real fluency with data and automation tools (Excel/Sheets at an expert level, plus a builder’s instinct for where AI and scripts can replace manual work), sharp attention to detail, and good judgment about what results imply for our strategy and performance
  • This person works directly with senior leadership
  • Work Orchestration: Own the systems and processes that plan and allocate work across the organization. Build and maintain the models that route work efficiently as volume, team capacity, and service lines change
  • KPI Reporting: Build and maintain reporting that gives leadership a clear, accurate, real-time view of business performance. Know the data well enough to catch anomalies before they become someone else’s problem
  • Resource Forecasting: Build and maintain forecasting models that project staffing and capacity needs against demand. Translate forecasts into recommendations leadership can act on
  • Billing Operations: Own billing sheet accuracy and process, including the reconciliation and QA that keeps them error-free at scale
  • Automation & AI Adoption: Identify where manual, spreadsheet-based, or repetitive work can be automated or AI-assisted. Build these solutions directly rather than just recommending them, using tools like Excel/Sheets scripting, SQL, and emerging AI tooling
  • Process Optimization: Identify and implement improvements to the processes, workflows, and systems this role owns, so accuracy and efficiency improve as the business changes. When an improvement requires cross-functional buildout, lead it end to end, including the change management to get it adopted
Benefits
  • Flexible vacation/time-off policy
  • All federal holidays are observed
  • Parental leave for birthing or non-birthing parents – 100% pay for 12 weeks
  • 401(k) plan
  • Development opportunities & employee happiness initiatives
  • Seasoned founding team that has led companies through two prior successful startups and acquisitions (by Oracle and Dropbox)
  • Wellness benefits such as Modern Health, Headscape, One Medical, Aaptiv and Rightway

Project Leadership: Demonstrated experience leading the build or overhaul of an operational system, including the change management needed to get a team to adopt it Experience: 3-5 years in business operations, analytics, or finance, ideally in a start-up or technology-forward environment, with a track record of actually building and running a system. Experience owning forecasting, billing, or resource-planning is a strong plus Detail Orientation: A track record of getting the numbers right the first time Communication: Strong verbal and written communication skills, with the ability to work directly with senior leadership and translate technical or data-heavy work into clear recommendations Systems Thinking: Able to see how planning, allocation, forecasting, and billing connect, and to design solutions that account for the whole picture rather than one piece of it Technical Proficiency: Expert-level Excel/Sheets (formulas, modeling, automation/scripting), plus working proficiency in SQL and analytics tools (e.g., Looker). Comfort using AI tools like Claude Cowork

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Manager, Business Operations
Manager, Business Operations

pilothq • San Francisco (CA)

Hybrid
USD 120,000 - 180,000
Business Operations Associate
Business Operations Associate

Midwest Startups • Atlanta (GA)

Hybrid
USD 85,000 - 120,000
Business Operations Analyst
Business Operations Analyst

Pilot.com • San Francisco (CA)

Hybrid
USD 110,000 - 148,000
Health benefits
401(k) plan
Parental leave
+1
Strategy and Planning Lead
Strategy and Planning Lead

Bask Health • United States

Remote
USD 120,000 - 190,000
Health insurance
Commercial Finance and Operations Manager
Commercial Finance and Operations Manager

Grow Therapy • United States

Hybrid
USD 180,000 - 260,000
Learning stipend
Mental health breaks
Unlimited PTO
+3
Strategy and Planning Lead - Billing/Revenue
Strategy and Planning Lead - Billing/Revenue

Bask Health • United States

Remote
USD 120,000 - 170,000
Strategy and Planning Lead - Billing/Revenue
Strategy and Planning Lead - Billing/Revenue

Bask Health • New York (NY)

On-site
USD 120,000 - 180,000
Sales Operations Analyst
Sales Operations Analyst

Flexcompute Inc. • Watertown (MA)

On-site
USD 90,000 - 130,000
Medical, dental, and vision insurance
401(k) Contribution
Gym allowance
+2
Billing & Revenue Operations Analyst
Billing & Revenue Operations Analyst

Flexcompute Inc. • City of Watertown (NY)

On-site
USD 65,000 - 90,000
Medical, dental, and vision insurance
401(k) contribution
Gym allowance
+1
Business Operations Analyst
Business Operations Analyst

Workana • United States

Remote
USD 150,000 - 210,000
Unlimited PTO