← Back to Directory

Plymouth Rock Assurance Corporation

Mid-sized

Plymouth Rock Assurance Corporation is a U.S.-based insurance company offering auto and home insurance products, primarily operating in the Northeastern United States. It is known for its customer-focused approach and technology-driven insurance services.

2 interview notes · updated Jul 2026

Plymouth Rock Assurance Corporation·Data Scientist·Technical Phone Screen

Jul 2026
SQL question for a Data Scientist role at Plymouth Rock Assurance Corporation, insurance domain flavor. One question, window function territory, not a bad problem if you've worked with cumulative aggregations before.
  • Given a table of insurance policy term losses, write a SQL query that computes the 'ultimate loss' for each policy term, defined as the sum of loss amounts for that term and all subsequent terms within the same policy.

“The key is recognizing this is a reverse cumulative sum partitioned by policy.”

View Post

Plymouth Rock Assurance Corporation·Data Scientist·Technical Phone Screen

May 2026
Interviewed for a Data Scientist role at Plymouth Rock Assurance Corporation and got a classic Fibonacci question with a complexity discussion tacked on. Pretty standard technical screen but they pushed further than I expected on the large-n handling piece.
  • Write a function to return the nth Fibonacci number (zero-indexed), and discuss the time and space complexity of your solution. Also explain how your approach handles very large values of n or potential integer overflow.

“Started with the naive recursive version because I always do that to show I understand the problem, then walked through memoization.”

View Post