Student Intern - Claims Executive Department (Business Intelligence Team) in Lincoln, RI at Amica

Date Posted: 1/7/2020

Job Snapshot

Job Description

Senior Student Intern
Claims Executive Department
100 Amica Way, Lincoln, RI 02865


Want to join a company where doing good is what we do?

The feeling is mutual!

Our internship is designed for individuals who are currently enrolled full time at an accredited college/university. Desired majors/concentrations include Finance, Actuarial Science, Economics, Econometrics, Statistics, Computer Science, Business Administration, Marketing (quantitative), Operations Research, Information Technology, Information Systems, or any similarly quantitative/IT intensive discipline. A GPA of 3.0 or higher is required.


Job Functions and Responsibilities:

The selected candidate will assist in the design and creation of reports and dashboards through advanced reporting tools and data analytics techniques. Primary responsibilities will include:

• Determining requirements and creating reports using MicroStrategy or other Business Intelligence tools based on Claims management needs
• Editing and enhancing existing reports and graphical dashboards
• Writing SQL to manipulate and display large quantities of data


Job Requirements:

• Experience creating reports in MicroStrategy, MS Access, Crystal Reports, QMF, or an equivalent
• Experience using SQL to query databases
• Excellent verbal and written communication skills
• Superior analytical, mathematical, and problem solving skills
• Ability to work with a reasonable degree of independence and with a team
• Effectively manage time to handle multiple projects

Knowledge and skills that would be a plus include:

• Expertise in using probability, statistics, and predictive analytics to understand data sets
• Experience creating data visualizations in MicroStrategy, Tableau, Qlik, or an equivalent
• Familiarity with the insurance industry and claims handling processes

About Amica

Amica Mutual Insurance Company is America’s oldest mutual insurer of automobiles. A direct national writer, Amica also offers home, marine and umbrella insurance. Amica Life Insurance Company, a wholly owned subsidiary, provides life insurance and retirement solutions. Amica was founded on the principles of creating peace of mind and building enduring relationships for and with our exceptionally loyal policyholders, a mission that thousands of employees in offices nationwide share and support.

Equal Opportunity Policy: All qualified applicants who are authorized to work in the United States will receive consideration for employment without regard to race, religion, sex, color, national origin, ethnicity, age, genetic information, disability or sexual orientation. The Age Discrimination in Employment Act prohibits discrimination on the basis of age with respect to individuals who are 40 years of age or older. Employees are subject to the provisions of the Workers' Compensation Act.