Business Intelligence Analyst

Plymouth Rock Assurance Corporation; Woodbridge Township (NJ); On-site; USD 71,000 - 94,000; Full time

Benefits offered by this job

PTO & holidays

Health insurance

401(k) contribution

Onsite gym

Professional development (LinkedIn-L)

Paid family leave

Tuition reimbursement

Job summary

Plymouth Rock Assurance Corporation is seeking a Business Intelligence Analyst in Woodbridge, NJ to analyze underwriting, sales and claims workflows and measure profitability across channels. You will build and maintain databases, dashboards and ETL processes to drive actionable insights for management.

The role requires strong SQL Server and Tableau experience, a BA/BS in a quantitative field, and excellent communication skills.

Qualifications

• BA/BS degree in quantitative field.
• Property and Casualty Insurance experience preferred.
• Analytical problem solver with attention to detail.
• Strong SQL Server and Tableau reporting experience.
• Excellent verbal and written communication.

Responsibilities

• Understand insurance concepts such as P&Ls, expense ratios, rate indications, loss ratio trends, and marketing funnel metrics.
• Identify reporting solutions and upgrade reports to increase efficiency and reduce redundancy.
• Collaborate with analytics teams to review insights from recent exercises.
• Build automated reporting and ETL data extraction processes.
• Act as liaison between the BI team and other departments.

Skills

SQL

Tableau

Data analysis

Excel

Communication

Education

BA/BS in quantitative field

Tools

SQL Server

ETL tools

Job description

The Business Intelligence Analyst supports the analysis 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 assisting in the creation and maintenance of various databases, performance metrics and analytics required to achieve these goals.

Essential Functions and Responsibilities

• Works closely with others to gain 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.
• Acts as a liaison between the Business Intelligence team and other departments within the Direct Group.

Qualifications and Education

• Demonstrated problem solving experience gained through related coursework and work experience.
• BA/BS degree in quantitative field of study.
• Property and Casualty Insurance experience preferred.
• 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.
• Excellent verbal and written communication skills.
• Collaborative nature but also has the ability to work independently and efficiently on a high volume of tasks.

Salary Range

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

• 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

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

Location(s)

581 Main Street, Woodbridge , New Jersey 07095 , United States

Plymouth Rock is committed to a policy ofnon-discrimination and equal opportunity for all qualified applicants andemployees without regard to race, color, religion, gender, sexual orientation,age, national origin, ancestry or disability.