Data Analyst Claims

Data Analyst Claims

**Must live within 40 miles of Costa Mesa, CA**

This role is responsible for developing and implementing statistically valid sampling methodologies, including designing random samples and calculating optimal sample sizes based on staffing constraints, desired confidence intervals, and acceptable error rates. Additionally, it supports audit objectives by conducting significance testing, identifying trends, quantifying error rates, and delivering actionable insights through advanced statistical analysis.

Responsibilities

• Develop SQL scripts and long-term reporting using a variety of data analysis tools / languages (SQL, Teradata, Tableau, and Excel). Identify and analyze trends with root cause analysis while providing solutions.

• Provide semi-complex ad hoc data analysis in a variety of source systems and using a variety of data analysis tools/ languages (SQL, Teradata, Tableau, Excel). Identify and analyze trends with root cause analysis while providing solutions.

• Assists in the design, build, and maintenance of reporting that measures performance of KPIs such as Service Quality, Productivity, Frequency, and Severity. Develop internal reports on expenses, incentive programs, initiatives, and performance goals and results. Organize projects clearly with accurate plan for speed of delivery of initiatives.

• Meet with Team and Claims Management concerning semi-complex production reporting and enhancements. Provides detail regarding challenges and offer solutions and recommendations.

• Continuous technical, analytical, and business acumen development. Learn and apply best practices and share knowledge with others.

• Collaborate with other Business Units such as Underwriting and Product Management to accomplish common goals and objectives.

Qualifications

• Bachelors Computer and Information Science

• Bachelors Equivalent combination of education and experience

• 4-6 years Experience in a traditional data or analytics corporate environment. Required

• 1-3 years Experience in providing qualitative or quantitative data compilation, analysis and reporting. Preferred

• 1-3 years Experience with manipulating data with SQL, Python, R or related technologies. Preferred

• Advanced PowerPoint and Excel skills required (incl. VBA, macros, complex calculations, etc.).

• Strong SQL skills with data mining knowledge preferred.

• Proficient in Tableau and Python preferred.

• Professional verbal and written communication skills required.

• Analytical, organizational and time management skills required.

• Able to rapidly learn new processes, databases, applications.

• Innovative mindset with demonstrated creativity or innovation in some past work experience preferred.

• Data Science Nanodegree within 1 Year Preferred

• Tableau Certified Associate within 1 Year Preferred

• Must live within 40 miles of Costa Mesa.

#LI-LG1

The starting pay range for this position is:

$72,700.00 - $96,800.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 plan with company match AND Pension
•    Tuition assistance
•    PTO for community volunteer programs
•    Wellness program
•    Employee discounts

Auto Club Enterprises is the largest federation of AAA clubs in the nation. We have 14,000 employees in 21 states helping 17 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 1902, 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

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 Unincorporated Los Angeles County (ULAC) regulation, and the California Fair Chance Act (CFCA).