Actuarial Intern (Competitor Analysis) - Summer 2027

Greater-Ny-Insurance-Companies; City of Niagara Falls (NY); On-site; USD 28,000 - 48,000; Full time

Benefits offered by this job

Discretionary bonus

Job summary

Greater-Ny-Insurance-Companies is seeking an intern to assist with competitor analysis across Commercial GL, Property, and Auto lines. You will research rate filings, maintain a competitor database, and update Tableau dashboards for presentation of results.

The role requires basic programming in SQL/R/VBA and strong Excel skills, with preference for Tableau experience and quick learning ability. Strong communication and analytical skills are essential.

Qualifications

• Two years of college completed in actuarial, statistics, computer science, math, engineering or related field.
• Experience building spreadsheets in Microsoft Excel.
• Programming experience in SQL, R, VBA, or other languages preferred.
• Working knowledge of Tableau preferred.
• Ability to quickly learn new programming languages or software.
• Strong accuracy and efficiency in work.
• Excellent oral and written communication skills.
• Ability to read through and analyze policy coverages.

Responsibilities

• Research competitor rate filings for Commercial GL, Property, and Auto lines of business.
• Perform competitor analyses and update the competitor database.
• Update Tableau dashboards to compare GNY and competitor filings.
• Update and maintain SQL code to output final competitor analysis tables.
• Contribute to special projects as required.

Skills

Programming languages adaptability

Excel proficiency

Tableau knowledge

SQL

Education

Two years of college in a related field

Tools

SQL Server

Tableau

Job description

Position Summary:The purpose of this internship is to assist team members in conducting competitor analysis to provide market competitiveness insights for Commercial GL, Property, and Auto lines of business. Competitor analysis involves researching competitor rate filings, updating competitor database, and maintaining Tableau dashboard for presentation of results.Essential Duties and Responsibilities:Research on competitor rate filings for Commercial GL, Property, and Auto lines of businessPerform competitor analyses for Commercial GL, Property, and Auto lines of business.Update Tableau dashboards to compare GNY and competitor filings.Update competitor analysis SQL Server database tables based on rate filings research.Update and maintain SQL code to output final competitor analysis tables.Participate in special projects and performs additional duties as required.Education and Experience:Minimum two years of college completed in Actuarial, Statistics, Computer Science, Math, Engineering or related field.Experience in building spreadsheets in Microsoft Excel required.Programming experience in SQL, R, VBA, or other languages preferred.Working knowledge of Tableau preferred.Skills:Strong ability to quickly learn new programming languages or softwareStrong ability to perform work efficiently and accuratelyExcellent oral and written communication skillsOther Requirements:Strong ability to read through and analyze policy coverages.The salary range for this role is $20/hr - $35/hr. The listed annual salary range posted for this position is subject to change and may vary depending on performance, education, experience, skills, geographic location, travel requirements, demonstrated proficiency in the competencies required for the role and business needs. Base pay is just one component of GNY’s total compensation package for employees. Other rewards include eligibility for an annual discretionary bonus based on performance.