What are the responsibilities and job description for the Data Analyst Claims position at ACSC Management Services Inc?
Please Note: This position has a hybrid schedule; however, you must reside within 25 miles of our Costa Mesa, CA office. You will be asked to come into the office for specific training courses and for bi-annual team meetings to meet senior leaders and other members of the organization.
As a mid-level Data Analyst, you are capable of developing, testing, and deploying reports used to support the business. You will be querying large datasets with SQL, developing Tableau reports, and working on various ad-hoc data requests.
What You Will Do
You will develop SQL scripts to develop data sources for Tableau reports and ad-hoc requests
You will be responsible for developing comprehensive forecasting and statistical models.
You will identify trends and perform in-depth analyses to uncover underlying drivers, providing clear, actionable insights to peers, managers, and leadership.
You will design, develop, and deploy various KPIs to track Service Quality, Productivity, Frequency, and Severity, along with developing reports to track new initiatives, annual performance goals, and provide analysis for recent results
You are highly organized and able to work on multiple projects and ad-hoc requests each week, prioritize the various tasks for each project, communicate effectively on the progress made during the week or explain the challenges that are impacting a deadline and estimate when that project can be delivered.
What You Will Need
To thrive in the role requires experience in a corporate data or analytics setting.
You have excellent Tableau and SQL skills. Tableau/SQL certification is a plus.
You possess a background in statistical mathematics.
You have the ability to learn new methodologies, databases, and analytical tools.
You have excellent skills in using Microsoft Excel and PowerPoint.
You have excellent experience with Python and Jupyter Notebooks.
You have the ability to analyze, organize and shift priorities to meet the needs you your manager/supervisor.
#LI-LD1
The starting pay range for this position is:
$74,500.00 - $99,500.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:
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 Unincorporated Los Angeles County (ULAC) regulation, and the California Fair Chance Act (CFCA).
As a mid-level Data Analyst, you are capable of developing, testing, and deploying reports used to support the business. You will be querying large datasets with SQL, developing Tableau reports, and working on various ad-hoc data requests.
What You Will Do
You will develop SQL scripts to develop data sources for Tableau reports and ad-hoc requests
You will be responsible for developing comprehensive forecasting and statistical models.
You will identify trends and perform in-depth analyses to uncover underlying drivers, providing clear, actionable insights to peers, managers, and leadership.
You will design, develop, and deploy various KPIs to track Service Quality, Productivity, Frequency, and Severity, along with developing reports to track new initiatives, annual performance goals, and provide analysis for recent results
You are highly organized and able to work on multiple projects and ad-hoc requests each week, prioritize the various tasks for each project, communicate effectively on the progress made during the week or explain the challenges that are impacting a deadline and estimate when that project can be delivered.
What You Will Need
To thrive in the role requires experience in a corporate data or analytics setting.
You have excellent Tableau and SQL skills. Tableau/SQL certification is a plus.
You possess a background in statistical mathematics.
You have the ability to learn new methodologies, databases, and analytical tools.
You have excellent skills in using Microsoft Excel and PowerPoint.
You have excellent experience with Python and Jupyter Notebooks.
You have the ability to analyze, organize and shift priorities to meet the needs you your manager/supervisor.
#LI-LD1
The starting pay range for this position is:
$74,500.00 - $99,500.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,
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 Unincorporated Los Angeles County (ULAC) regulation, and the California Fair Chance Act (CFCA).
Salary : $74,500 - $99,500