The Data & Analytics Senior Analyst will report into the Direct Group Financial Planning & Analysis team and play a critical role by leveraging both their technical skills to collaborate with stakeholders throughout the group and develop datasets and management information reports to support analytical reviews of operational workflows, marketing performance, and profitability to guide financial decision-making for the Direct Group.

Successful candidates will leverage SQL, automation, and data visualization tools (e.g., Tableau) to deliver timely, accurate, and actionable insights across the organization, owning analyses from start to finish. The role also provides hands-on exposure to forecasting, budgeting, variance analysis, and executive-level reporting. This opportunity is well-suited for candidates who are motivated by problem-solving, data-driven analysis, and collaboration with business leaders.

RESPONSIBILITIES

Work with large-scale datasets within the enterprise data warehouse to support analytical and reporting needs.
Build and maintain SQL-driven automated reporting and data visualizations using Excel and BI tools.
Design, enhance, and maintain recurring and ad hoc reporting to improve insight delivery, reduce redundancy, and increase automation and efficiency.
Support financial planning and analysis activities, with cross-training across forecasting, budgeting, and performance management.
Demonstrate or develop a strong understanding of insurance and financial concepts, including P&Ls, expense and loss ratios, rate impacts, and marketing performance across underwriting, sales, and claims.
Communicate analytical insights and recommendations clearly to FP&A leadership and cross-functional stakeholders, with guidance from senior team members.
Collaborate with analytics and finance teams across the organization to align methodologies and share insights.

QUALIFICATIONS

Bachelor’s degree in a quantitative or business-related field (e.g., Analytics, Data Science, Economics, Finance, Statistics, or Computer Science).
5-8 years of relevant experience in analytics, finance, business intelligence, or a related discipline; insurance industry experience preferred but not required.
Strong analytical mindset with intellectual curiosity and attention to detail.
Extensive SQL expertise, including the ability to write complex queries, joins, aggregations, and optimize performance.
Ability to manage multiple priorities, work independently, and collaborate effectively across teams.
Strong candidates will be able to not just support the analytics by curating datasets and building dashboards but also complete the analytics themselves.
Advanced Excel skills, including formulas, pivot tables, and data modeling.
Experience developing dashboards and reports using Tableau or similar BI visualization tools.
Proficiency in Microsoft Office applications (Word, PowerPoint, Excel).
Strong verbal and written communication skills, with the ability to translate data into clear, actionable business insights.

SALARY RANGE

The pay range for this position is $95,000 to $125,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”.

#LD-DNI

Learn more about this Employer on their Career Site