Claims Analyst

The Claims Analyst supports the Claims Department's Operations and Management Teams by developing/maintaining or supporting business reports, applications, and analytical solutions. This role participates in systems implementations, data management initiatives, and analytics work that strengthens Plymouth Rock's performance in loss management, customer service, expense control, and employee engagement.

RESPONSIBILITIES

• Partner with Claims leadership and cross-functional teams to deliver recurring reports/visuals and ad hoc datasets using SQL Server Management Studio, Visual Studio, MS Access, Excel and Tableau.
• Manage the claim department's letter library using low code/no code third party vendor software, including creating/updating letters and creating/maintain automated batch jobs.
• Collaborate with IT on claims technology initiatives, including but not limited to providing subject matter expertise, writing business requirements, performing user acceptance testing, training and postproduction support.
• Oversee regulatory reporting automated process and ensure compliance within the department.

QUALIFICATIONS

• Bachelor's degree required, master's degree preferred, ideally in a technical or analytical discipline (Computer Science, Engineering, Mathematics, Statistics).
• 1-2 years' experience with SQL, including writing complex queries, stored procedures, and functions.
• Proficient in Microsoft applications including Word, Excel, Access and Visual Studio.
• Experience in SSIS package development a plus.
• Business intelligence development experience (Tableau preferred)
• Previous experience in an insurance industry preferred.
• Strong analytical, problem-solving and attention-to-detail skills.
• Excellent written and verbal communication skills
• Self-motivated, organized and able to prioritize in a fast-paced environment.

SALARY RANGE

The pay range for this position is $ 63,500 to $88,000 annually. Actual compensation will vary based on multiple factors, including employee knowledge and experience, role scope, business needs, geographical location, and internal equity.

PERKS & BENEFITS

• 4 weeks accrued paid time off, 8 paid national holidays per year, and 2 floating holidays
• Low cost and excellent coverage health insurance options that start on Day 1 (medical, dental, vision)
• Annual 401(k) Employer Contribution
• Free onsite gym and health center at our Woodbridge Location
• Resources to promote Professional Development (LinkedIn Learning and licensure assistance)
• Robust health and wellness program and fitness reimbursements
• Various Paid Family leave options including Paid Parental Leave
Tuition Reimbursement

ABOUT THE COMPANY

The Plymouth Rock Company and its affiliated group of companies write and manage over $2 billion in personal and commercial auto and homeowner's insurance throughout the Northeast and mid-Atlantic, where we have built an unparalleled reputation for service. We continuously invest in technology, our employees thrive in our empowering environment, and our customers are among the most loyal in the industry. The Plymouth Rock group of companies employs more than 1,900 people and is headquartered in Boston, Massachusetts. Plymouth Rock Assurance Corporation holds an A.M. Best rating of “A-/Excellent”.

#LI-DNI