Insurance Product Analytics & Insights

PEMCO Mutual Insurance; Seattle (WA); On-site; USD 96,000 - 118,000; Full time

Benefits offered by this job

401(k) match

Education assistance

Scholarship program

Paid time off

Job summary

PEMCO Mutual Insurance seeks a Product Analyst to partner with Product Managers and Actuaries, analyzing performance, identifying trends, and contributing to recommendations. You will document workflows, support rate/rate filings, and build analytical tools to drive profitable growth through data-driven insights.

The role emphasizes strong collaboration, attention to detail, and proficiency in SQL and data visualization, with opportunities to shape PEMCO's product strategy across multiple states

Qualifications

• Bachelor's or equivalent in a quantitative field (Business, Economics, math)
• 1 year of experience in property and casualty insurance required
• 3+ years in analytical roles pricing insurance products or similar work required
• Strong problem solving, accuracy, and attention to detail
• Proficiency in MS Office (Excel, Word, PowerPoint, Outlook) required
• Experience in SQL and SQL Server required
• Proficiency in data visualization tools (PowerBI, Tableau) preferred
• Knowledge of relevant laws, rules, and regulations

Responsibilities

• Manage expectations, prioritize workload and communicate status.
• Perform semi-complex analyses to identify trends and provide actionable recommendations.
• Document system workflows and business processes.
• Support profitable growth using quantitative and qualitative data.
• Prepare rate and form filings materials.
• Build tools to improve efficiency in analyzing metrics.
• Assist in product and rating reviews.
• Plan and manage small to medium projects.
• Query databases to generate scheduled and ad hoc reports.
• Demonstrate PEMCO's ethics and values.
• Support PEMCO brand and talent acquisition.

Skills

Analytical thinking

Problem solving

Communication

Data-driven

MS Office

Education

B.A./B.S. degree or equivalent

Tools

SQL & SQL Server

PowerBI

Tableau

Excel

Job description

PEMCO Mutual Insurance seeks a Product Analyst to partner with Product Managers and Actuaries, analyzing performance, identifying trends, and contributing to recommendations. You will document workflows, support rate/rate filings, and build analytical tools to drive profitable growth through data-driven insights.

The role emphasizes strong collaboration, attention to detail, and proficiency in SQL and data visualization, with opportunities to shape PEMCO's product strategy across multiple states