AI-Driven Operations Analytics & Automation Specialist

Pilot

San Francisco (CA)

On-site

USD 130,000 - 190,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Ops Systems Architect: Forecasting & AI Automation
Senior Ops Systems Architect: Forecasting & AI Automation

pilothq • San Francisco (CA)

Hybrid
USD 120,000 - 180,000
Ops Analytics & Strategy Analyst
Ops Analytics & Strategy Analyst

Copilotiq • United States

Remote
USD 85,000 - 115,000
Ops Analytics & Automation Specialist
Ops Analytics & Automation Specialist

Pilot.com • San Francisco (CA)

Hybrid
USD 110,000 - 148,000
Health benefits
401(k) plan
Parental leave
+1
Associate Director, Ops Strategy & AI-Driven BI
Associate Director, Ops Strategy & AI-Driven BI

codeandtheory • United States

Remote
USD 120,000 - 180,000
Business Operations Analyst
Business Operations Analyst

Pilot • San Francisco (CA)

On-site
USD 130,000 - 190,000
Flexible vacation
Federal holidays observed
Parental leave 12 weeks (paid)
+3
AI-Driven Operations Leader (Hybrid NYC)
AI-Driven Operations Leader (Hybrid NYC)

Align • New York (NY)

Hybrid
USD 140,000 - 160,000
Comprehensive Medical, Dental, and Vis
Health Savings Account (HSA) and FSA
401(k) plan with company match
+8
Director, Operations Strategy & AI-Driven Automation
Director, Operations Strategy & AI-Driven Automation

Code and Theory, LLC • United States

Remote
USD 130,000 - 210,000
AI-Driven Operations Systems Analyst
AI-Driven Operations Systems Analyst

Kastle • Houston (TX)

On-site
USD 90,000 - 130,000
Medical, dental, and vision coverage
401(k) plan
Generous paid time off
+2
AI-Driven Business Analyst & Automation Specialist
AI-Driven Business Analyst & Automation Specialist

OP • Sunnyvale (CA)

On-site
USD 120,000 - 150,000
401(k)
Dental Insurance
Health insurance
+2
Product Ops Specialist: AI-Driven Delivery & Dashboards
Product Ops Specialist: AI-Driven Delivery & Dashboards

Afsvision • Exton (PA)

On-site
USD 120,000 - 150,000