Insurance Optimization Intern at AAA-The Auto… · Hybrid -…

Summary: AAA The Auto Club Group is seeking a motivated student to join their Insurance Optimization team as an intern. The role involves developing dashboards to enhance transparency in business results and collaborating on various auditing projects within the organization. Responsibilities: - Drive business results by collaboratively developing various dashboards that will provide greater transparency into the health and well-being of The Auto Club Group - Broaden your knowledge and create meaningful connections by cross-collaborating among the many business lines of ACG in a wide range of auditing projects - Utilize Google Cloud Platform – Looker Studio to create various dashboards - Perform quality audits across various product lines such as Auto, Home, Life, and Personal Umbrella Policies - Assist with flowcharting audit samples that provide transparency into agent performance - Support our Insurance Optimization Team with investigating trends within our Trailing Document audit process - Generate new ideas and provide input towards the creation and utilization of Looker Studio Dashboards - Expand your investigation and analysis techniques - Develop strong project management skills through the development and presentation of dashboards that highlight audit processes and premium recovery opportunities - Gain real-world experience in SQL, GCP Looker Studio, and insurance audit techniques - Cross-collaborate and network among various business lines of ACG Required Qualifications: - Must be at least a junior currently enrolled in bachelor's or master's degree program in a related field (e.g., Business Administration, Data Science, Statistical Analysis, MIS, Finance, or related field), with a 3.0 GPA minimum - Legally authorized to work in the U.S - Strong interpersonal skills, communication skills (oral and written), organization skills, and strong situational adaptability - Strong analytical and critical thinking skills - Strong problem-solving skills and attention to detail - Ability to work in a fast-paced, dynamic environment - Ability to multi-task and appropriately prioritize tasks to ensure timely solutions to problems that meet business line goals - Experience with PC software applications (e.g., Word, Excel, PowerPoint, Access, etc.) - Proficiency in Excel and SQL - Basic math calculations to accurately perform various types of transactions - Knowledge of statistical analysis techniques and data visualization tools - Learn the full range ACG products, services and functions to perform the responsibilities of assigned job - Assist internal/external client in response to questions, requests and resolution of problems - Review records, system files, reports, etc. to ensure correct information is reflected and/or assigned - Gather data and prepare/track reports - Assist and/or develop reports/presentations/recommendations for management review - Communicate effectively with others in a work environment and with the public - Rotate within department/field location to cross-train on various business line functions - Work independently and on teams Preferred Qualifications: - Proficiency in programming languages such as Python, R, and/or Tableau - Experience with GCP/Looker Studio and Salesforce - Ability to learn and adapt to corporate cultures and processes and provide own relevant and effective experience and best practices - Be comfortable in an environment where responsibilities are broadly defined, resources are limited, and collaboration is critical to success - Ability to provide good service to internal and/or external customers Required Skills: SQL, GCP Looker Studio Important Skills: Statistical analysis, Data visualization Nice-to-Have Skills: Python, R, Tableau, Project management