Senior Product Analyst, Insurance Data & Pricing

PEMCO; Seattle (WA); On-site; USD 116,000 - 142,000; Full time

Benefits offered by this job

401(k) plan with employer match

Paid vacation and holidays

Life and disability insurance

Job summary

PEMCO, a mutual insurance company based in Seattle, is seeking a Senior Product Analyst to conduct complex quantitative analysis of property & casualty products, improve performance, and support product initiatives. The role collaborates with Product Managers and Actuarial teams to develop analytical strategies, create dashboards, and identify efficiency gains in data strategy and warehousing.

It requires strong SQL, data visualization, and communication skills, with a focus on delivering

Qualifications

• 3 years of experience in the property and casualty insurance industry
• 6+ years of analytical roles with increasing scale and complexity in pricing insurance products
• Proficiency in SQL, SQL Server, and data visualization
• Strong presentation and communication skills
• Detail-oriented with excellent time management
• Ability to work with large data files from multiple sources
• Knowledge of relevant laws, rules, and regulations
• Experience with data modeling and building scalable data infrastructures

Responsibilities

• Plan and manage large-scale, complex projects with support
• Document complex system workflows and business processes
• Create queries, dashboards, and tools for analyzing product success
• Compile and submit materials for rate filings
• Communicate analysis to stakeholders to demonstrate value
• Build tools to create efficiencies in data analysis
• Assist in product and rating reviews and pricing recommendations
• Perform complex analysis to identify trends and make actionable improvements
• Demonstrate PEMCO policies and ethics
• Support PEMCO Brand and talent recruitment
• Other duties as assigned

Skills

SQL/SQL Server

Data visualization

Power BI

Tableau

Analytical modeling

Communication

Excel

Education

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

Graduate degree preferred

Tools

SQL Server

Power BI

Tableau

WTW Radar

Job description

PEMCO, a mutual insurance company based in Seattle, is seeking a Senior Product Analyst to conduct complex quantitative analysis of property & casualty products, improve performance, and support product initiatives. The role collaborates with Product Managers and Actuarial teams to develop analytical strategies, create dashboards, and identify efficiency gains in data strategy and warehousing.

It requires strong SQL, data visualization, and communication skills, with a focus on delivering