Senior Operations Analyst

AAA • Costa Mesa, CA

2d • $80,100 - $107,000

About The Position

The Senior Operations Analyst provides analytical and organizational support to business unit operations and management, including KPI reporting, compensation and incentives, forecasting, and budget updates. The role supports business goals and objectives, develops processes and proposals to improve operational effectiveness, and advances program development through research, audits, statistical reports, and analysis. It also coordinates project implementation across facilities as needed.

The position develops and administers programs affecting service delivery and quality, member benefits, employee performance, performance management, and provider compensation. It supports annual budgeting, goal setting, forecasting, strategic-plan implementation, operational reporting, and data analysis. The analyst uses SQL, Teradata, Tableau, Excel, Access, and other tools to query and validate large data sets, create reports and dashboards, troubleshoot complex data issues, and develop calculations for incentives, goals, and forecasts. The role also contributes to data-table design and query optimization, cross-functional collaboration, continuous improvement, and program audits.

Requirements

• Bachelor’s degree or equivalent combination of education and experience.
• 4–6 years of experience in business operations and data analytics.
• Professional verbal and written communication skills.
• Strong SQL skills and data-mining knowledge.
• Advanced Excel skills, including VBA, macros, and complex calculations.
• Proficiency with Microsoft Office products, including Outlook, Word, Excel, and Access.
• Professional organizational and time-management skills, with the ability to multitask and meet management-set project deadlines.
• Extensive knowledge of Teradata and SQL databases, data mining, and Tableau data visualization.

Nice To Haves

• Tableau experience.
• Python skills.
• Experience with MS Project and Publisher.

Responsibilities

• Develop and administer programs affecting service delivery and quality, member benefits, employee performance, performance management, and service-provider compensation and incentive payments.
• Assist with developing and preparing the annual budget, goals, and objectives; provide monthly forecasts and budget updates.
• Implement portions of the strategic business plan and assess, evaluate, and recommend changes as needed.
• Design, build, and maintain reporting to measure key operational KPIs.
• Develop internal and ad hoc reports on expenses, incentive programs, initiatives, and performance goals and results.
• Provide ad hoc data analysis using varied source systems and analysis tools or languages, including SQL, Teradata, Tableau, Excel, and Access.
• Identify and analyze trends, conduct root-cause analysis, and provide solutions.
• Assist with designing, building, and maintaining Teradata data tables for query optimization.
• Collaborate with Business Intelligence, Market Research, and other business units to accomplish shared goals and objectives.
• Recognize, design, and integrate continuous-improvement components to meet redesign needs.
• Develop, implement, conduct, document, and report program audit techniques to ensure accuracy and adherence to policies, practices, and operating procedures.
• Query large data sets and validate data; develop specialized reports and dashboards; troubleshoot data issues and develop solutions to complex data problems.
• Formulate calculations to compute incentives, goals, and forecasts.
• Coordinate project implementation across facilities as needed.

Benefits

• Health coverage for medical, dental, and vision.
• 401(k) savings plan with company match and pension.
• Tuition assistance.
• Floating holidays.
• PTO for community volunteer programs.
• Paid parental leave.
• Wellness programs.
• Employee discounts on membership, insurance, travel, entertainment, services, and more.
• Incentive-program eligibility for full-time positions, based on organization, team, and personal performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior