Plymouth Rock Assurance · 21 hours ago
Data & Analytics Analyst
Woodbridge, NJ
Full-time
Onsite
Entry, Mid Level
$72K/yr - $105K/yr
2+ years expPlymouth Rock Assurance is a leading insurance provider in the Northeast and mid-Atlantic regions, focusing on personal and commercial auto and homeowner’s insurance. The Data & Analytics Analyst will leverage technical skills to support analytical reviews, develop datasets, and provide insights to guide financial decision-making.
Auto InsuranceFinancial ServicesInsurance
Hiring Manager
Donald Bjornsen
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
Qualification
Required
Bachelor's degree in a quantitative or business-related field (e.g., Analytics, Data Science, Economics, Finance, Statistics, or Computer Science)
2–4 years of relevant experience in analytics, finance, business intelligence, or a related field; insurance experience is a plus but not required
Strong analytical mindset with intellectual curiosity and attention to detail
Proficiency in SQL, including the ability to write complex queries, joins, aggregations, and optimize performance
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)
Ability to manage multiple priorities, work independently, and collaborate effectively across teams
Strong verbal and written communication skills, with the ability to translate data into clear, actionable business insights
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 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
Company
Plymouth Rock Assurance
If you’ve found your way to our LinkedIn page, you’re likely here for one of two reasons: You’re reviewing insurance companies or you’re browsing new career opportunities.
1001-5000 employees
H1B Sponsorship
Plymouth Rock Assurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (11)
2024 (12)
2023 (6)
2022 (7)
2021 (5)
2020 (12)
Funding
Current Stage
Late StageLeadership Team
Bill Martin
President and CEO of Home Assurance
Max Malaret
Vice President of Claims - Independent Agency Auto Group
Recent News
Plymouth Rock
2025-10-14
2025-08-13
Company data provided by crunchbase