Senior Operations Analytics Lead: KPIs & Forecasting

Socket.dev; San Jose (CA); On-site; USD 80,000 - 107,000; Full time

Benefits offered by this job

Health coverage

401(K) matching and Pension

Tuition assistance

Floating holidays and PTO

Paid parental leave

Wellness programs

Employee discounts

Job summary

The Automobile Club of Southern California is seeking an Operations Analyst to support KPIs reporting, budgeting, forecasting, and incentive programs across the business unit. The role involves designing and maintaining dashboards, conducting ad hoc analyses, and driving continuous improvement initiatives.

Ideal candidates have 2–3 years of analytical experience, strong SQL skills, advanced Excel, and experience with AWS or Snowflake.

Qualifications

• Bachelors equivalent combination of education and experience.
• Professional verbal and written communication skills required.
• Strong SQL skills with data mining knowledge in AWS or Snowflake.
• Advanced Excel skills (incl. VBA, macros, complex calculations).
• 2-3 years analytical experience mandatory.
• Proficiency with Microsoft Office products (Outlook, Word, Excel, Access).
• Tableau preferred; Python a plus.

Responsibilities

• Develop and administer new and existing programs impacting service delivery and quality, employee performance, internal and external performance management and provider compensation/incentive payments.
• Assist with annual budget development, forecasting, and objective setting; update budgets regularly.
• Design, build, and maintain reporting that measures operational KPIs and prepares internal expense/incentive reports.
• Provide ad hoc data analysis using SQL, Tableau, Excel, and Access; identify trends and root causes.
• Design and maintain data tables in AWS/Snowflake for efficient querying; collaborate with Database/Analytics teams.

Skills

SQL

Advanced Excel

Data mining

Education

Bachelor’s degree or equivalent

Tools

Tableau

AWS

Snowflake

Python

Access

Job description

The Automobile Club of Southern California is seeking an Operations Analyst to support KPIs reporting, budgeting, forecasting, and incentive programs across the business unit. The role involves designing and maintaining dashboards, conducting ad hoc analyses, and driving continuous improvement initiatives.

Ideal candidates have 2–3 years of analytical experience, strong SQL skills, advanced Excel, and experience with AWS or Snowflake.