Senior Operations Analyst

Auto Club Of Southern Calif; Costa Mesa (CA); On-site; USD 80,000 - 107,000; Full time

Benefits offered by this job

Health coverage

401(K) with company match and Pension

Tuition assistance

Floating holidays and PTO

Paid parental leave

Wellness programs

Employee discounts

Job summary

Auto Club Enterprises is seeking a Senior Operations Analyst to provide analytical and organizational support in KPI reporting, budgeting, forecasting, and incentive programs across operations. The role involves building dashboards, conducting data audits, and collaborating with BI teams to drive continuous improvement.

Strong SQL, Teradata, Tableau, and Excel skills are essential. The position emphasizes data-driven decision making, process development, and cross-functional coordination to

Qualifications

• Bachelor's degree or equivalent with experience.
• 4–6 years in business operations and data analytics.
• Strong verbal and written communication skills.
• Proficient SQL with data mining knowledge.
• Advanced Excel skills including VBA/macros.
• Tableau preferred; Python a plus.
• MS Office suite including Outlook, Word, Excel and Access; MS Project/Publisher a plus.

Responsibilities

• Develop and administer programs impacting service delivery, benefits, and incentives.
• Assist with annual budgeting, forecasting, and strategic plan updates.
• Design, build, and maintain KPI reports and internal dashboards.
• Provide ad hoc data analysis using SQL, Teradata, Tableau, Excel, Access.
• Assist with Teradata data table design for query optimization.
• Collaborate with BI and Market Research to achieve goals.
• Identify continuous improvement opportunities and design solutions.
• Develop and conduct program audits for accuracy and procedures.
• Handle large data sets, troubleshoot data issues, and compute incentives/forecasts.

Skills

SQL skills & data mining

Communication skills

Time management

Education

Bachelor's degree or equivalent

Tools

Tableau

Python

Excel (VBA/macros)

Access

MS Project

Publisher

Job description

Senior Operations Analyst

This position provides analytical and organizational support to the business unit operations/management in KPIs reporting, compensation/incentives, forecasting and budget updates. The position performs all related duties in support of goals and objectives, as well as developing processes and proposals to increase the effectiveness of the operations. In addition, the position fosters continued program development and growth by conducting research and audits, as well as by producing statistical reports and analyses. The position coordinates project implementation across all facilities as needed

Responsibilities

• Develop and administer new and existing programs impacting service delivery and quality, member benefits, employee performance, internal and external performance management and service provider compensation/incentive payments.
• Assist with development and preparation of annual budget, goals, and objectives. Provide monthly forecasting and effective budget updates. Implement individual portions of the strategic business plan. Assess, evaluate and recommend alterations to the business plan as needed.
• Under close guidance, design, build, and maintain reporting that measures key operational KPIs. Develop internal reports on expenses, incentive programs, initiatives, and performance goals and results, including ad-hoc reports as needed.
• Provide ad hoc data analysis in a variety of source systems and using a variety of data analysis tools/ languages (SQL, Teradata, Tableau, Excel, Access). Identify and analyze trends with root cause analysis while providing solutions.
• Assist with designing, building, and maintaining data tables in Teradata for query optimization.
• Collaborate with other Business Units such as Business Intelligence and Market Research to accomplish common goals and objectives.
• Recognize, design, and integrate continuous improvement components to meet redesign needs.
• Develop, implement, conduct, document and report result of program audit techniques required to ensure accuracy and adherence to policies, practices and operating procedures.
• This position requires extensive knowledge in Teradata and SQL databases with data mining knowledge as well as data visualization through Tableau. Work regularly requires the exercise of discretion and independent judgment in areas such as:
• Querying large data sets, validating data,
• Developing specialized reports/dashboards
• Troubleshooting data issues
• Developing solutions to complex data issues
• Formulation of calculations to compute incentives, goals, forecasts

Qualifications

• Bachelors' Equivalent combination of education and experience
• 4-6 years Business operations and data analytics.
• Professional verbal and written communication skills.
• Strong SQL skills with data mining knowledge.
• Advanced Excel skills (incl. VBA, macros, complex calculations, etc.).
• Tableau preferred, Python a plus.
• Proficiency in Microsoft Office software products, including Outlook, Word, Excel and Access required. Additional computer software skills such MS Project and Publisher desired.
• Professional organizational and time management skills, as well as the ability to multitask and meet project deadlines as set by management.

#LI-LG1

The starting pay range for this position is: $80,100.00 - $107,000.00 Additionally, for full time positions, you will be eligible to participate in our incentive program based upon the achievement of organization, team and personal performance.

Remarkable benefits

• Health coverage for medical, dental, vision
• 401(K) saving plans with company match AND Pension
• Tuition assistance
• Floating holidays and PTO for community volunteer programs
• Paid parental leave
• Wellness programs
• Employee discounts (membership, insurance, travel, entertainment, services and more!)

Auto Club Enterprises is the largest club within the national AAA federation. We have nearly 17,000 employees in 24 states helping more than 18 million members. The strength of our organization is our employees. Bringing together and supporting different cultures, backgrounds, personalities, and strengths creates a team capable of delivering legendary, lifetime service to our members. When we embrace our diversity - we win. All of Us! With our national brand recognition, long-standing reputation since 1900, and constantly growing membership, we are seeking career-minded, service-driven professionals to join our team.

"Through dedicated employees we proudly deliver legendary service and beneficial products that provide members peace of mind and value."

AAA is an Equal Opportunity Employer

Our organization participates in E-Verify

The Automobile Club of Southern California will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state, and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance (FCIHO), the