This site uses cookies. To find out more, see our Cookies Policy

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

Date Posted: 3/14/2019

Job Snapshot

Job Description

Are you looking for a job in a growing industry with new products, new markets and new technology?

With locations across the country, Amica Mutual Insurance Company offers opportunities to join this dynamic field with a financially strong and respected insurance provider. Amica, based in Lincoln, RI, is a national writer of auto, home, marine and umbrella insurance. Amica Life Insurance Company, a wholly owned subsidiary, offers a full line of life insurance products.

We are recognized as a leader in customer service and credit this success to our 3,800 employees in 44 offices across the country.

Our office located in Lincoln, RI, is seeking a student intern for our Business Intelligence Team within the Claims Executive Department. This is a paid internship, and the working hours require a minimum of 37.5 hours per week during the summer.

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

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.