The Business Intelligence Supervisor is responsible for developing methods and leading analytical reviews of operational workflows and lifetime profitability to measure operational and marketing channel effectiveness, and ensure adequate profitability for the business being written by the Direct Group. The person is responsible for creating analytics, databases and performance metrics required to achieve these goals.  In addition, the person will work closely with the Business Intelligence Director to help determine ongoing priorities for the unit.

Essential Functions and Responsibilities

• Has a strong understanding of insurance concepts such as financial P&Ls, expense ratios, rate level indications, loss ratio trends, and marketing funnel metrics and to get familiar with internal workflows (i.e. underwriting, sales and claims handling).
• Identify creative reporting solutions, including ad-hoc analysis that facilitates effective measurement of operational effectiveness. Upgrade existing reports to increase efficiency of distribution, reduce redundancy across reports and to improve ease of presentation.
• Collaborate with other analytical teams throughout the enterprise to review insights from recent analytical exercises.
• Effectively uses available front end reporting tools, data systems and information gathered from different areas throughout the company to analyze business issues. Communicate results to management. 
• Work with large databases from Production Data warehouse. Collaborate with data teams to leverage tools and techniques developed for effective data extraction, transformation and loading (ETL).
• Build automated reporting and analytical tools, which includes a) queries that extract and summarize data from our data warehouse and b) procedures that integrate this data into dynamic workbooks allowing for multiple levels of analysis.
• Proven ability to work independently with other departments to lead assigned analytical exercises, as well as present observations and recommendations to a wide variety of stakeholders. This includes:
  • Gaining subject-matter expertise to independently drive the analysis
  • Deploying the appropriate analytical techniques to yield practical insights
  • Effective presentation and communication skills

Qualifications and Education

• Demonstrated problem solving experience gained through related coursework and work experience. BA/BS degree in quantitative field of study.
• Several years of Property and Casualty Insurance experience required.    
• Analytical problem solver with a high level of intellectual curiosity and attention to detail. Prior Product or Actuarial experience desired.                                 
• Strong programming/query experience in SQL Server and Tableau report building.
• Proficient with all Microsoft Office products.
• Three or more years of experience with relational database tools and concepts.             
• Demonstrated experience leading projects from start to finish with a high degree of autonomy.
• Excellent verbal and written communication skills.
• Collaborative nature, but also has the ability to work independently and efficiently on a high volume of tasks.

 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