Senior Product Analyst

PEMCO•Seattle, WA

7d•$81,437 - $153,797

About The Position

At PEMCO, a mutual insurance company owned by Northwest policyholders, we provide auto, home, renters, and boat coverage. We are recognized by Forbes as one of America’s Best Insurance Companies for 2025 and by Newsweek as one of America’s Greatest Midsize Workplaces 2025, consistently praised for outstanding customer service, employee expertise, community partnerships, and social impact programs. Our social impact initiatives focus on youth education, building stronger and greener communities, and increasing safety. We are committed to diversity, equity, inclusion, and belonging, fostering an inspiring and inclusive workplace that promotes fairness, understanding, collaboration, flexibility, and celebrates individual differences to enable full potential. PEMCO is seeking a Senior Product Analyst to conduct complex quantitative analysis of property & casualty products, aiming to improve product performance and support PEMCO's and Product's initiatives.

Requirements

B.A. or B.S. degree or equivalent work experience (economics, business, information technology, mathematics, or equivalent quantitative field of study) is required.
3 years of experience in the property and casualty insurance industry is required.
6+ years of experience in analytical roles with increasing scale, scope and complexity involving pricing insurance products or similar work including experience in integrating, managing, and manipulating large data files from various corporate systems and external sources is required.
Ability to analyze, diagnose and resolve complex unstructured problems quickly, efficiently, and collaboratively is required.
Organizes data visually and speaks clearly and persuasively in group presentations and meetings with multiple peer groups and senior management is required.
Is detail orientated and has a strong desire for accuracy and thoroughness is required.
Has excellent time management skills and easily manages multiple tasks, activities, and projects is required.
Skilled proficiency in Excel, Word, PowerPoint, Outlook is required.
Proficiency in SQL, SQL Server, and data visualization is required.
Ability to demonstrate high level of skill in quantitative modeling, knowledge of data structures and ability to write complex SQL queries is required.
Is highly self-motivated and self-directed. The ability to work with limited direction and communicate relevant information to the appropriate levels during times of uncertainty is required.
Is passionate about working with disparate datasets bringing data together to answer business questions. Collaborates to create, manage, and translate data to meaningful insights. Can work with external vendors to integrate data for analysis; knows how to build efficient and scalable infrastructure and data models is required.
Knowledge and understanding of relevant laws, rules, and regulations is required.
The ability to communicate clearly and informatively, verbally and in writing, with colleagues, customers, and the community in both technical and non-technical professional language is required.
Thinks analytically; a structured thinker who can put complex ideas into clear frameworks; uses data to conduct root cause analysis and develops high quality, consumable, and consistent metrics that drive strategic objectives and priorities is required.

Nice To Haves

Graduate or other professional degree or equivalent work experience is preferred.
Proficiency in Power BI, Tableau, and WTW Radar is preferred.

Responsibilities

Plan and manage large-scale, complex projects with support.
Document complex system workflows and business processes.
Develop and implement analytical strategies as a partner to our Product Managers and Actuarial team.
Create queries, dashboards, and tools for analyzing and tracking product success; identify enhancements and efficiency gains in data strategy and warehousing; consult on data fields, calculations, and methodology.
Compile and submit materials for rate filings.
Communicate analysis with business stakeholders to understand its value.
Build tools and processes to create efficiencies, especially in analyzing metrics.
Assist less experienced analysts as needed or assigned.
Assist in product and rating reviews, including making pricing recommendations.
Perform complex analysis to evaluate the performance of and identify trends and issues for our products and make actionable recommendations for improvements.
Demonstrate behaviors consistent with PEMCO's policies, values, code of ethics and business conduct.
Authentically support the PEMCO Brand and constantly are on the lookout for top talent to join us to achieve our Mission to Worry Less and Live More.
Other duties as assigned.

Benefits

Employer-paid basic life and accidental death & dismemberment insurance policies
Long- and short-term disability benefit coverages
401(k) plan which includes a generous employer match (2 for 1 on the first 6% employee pre-tax and/or Roth deferral, up to federal maximums)
Vacation accrues at a rate of 10 days for new hires, and increases based on a schedule to a maximum annual accrual of 25 days based on tenure
Four (4) personal days immediately upon hire
Paid holidays for the eight (8) holidays observed by PEMCO throughout the calendar year
Up to ten (10) days of sick leave immediately upon hire (pro-rated based on hire date and full-time/part-time status), which is approximately 28 hours more per year than the Washington state-required accrual
Paid time off for bereavement
Paid time off for jury duty
Paid time off for employee volunteering in the community
Flexible Spending Accounts
Education Assistance Program after one year of service
Scholarship program for children of PEMCO employees after one year of service
Employee Assistance Program
Well-being program
Discretionary taxable gifts and gift cards
Perks & Benefits including discounts on computer software and hardware, cell phone plans, and rental cars
Discretionary bonuses
Tiered sales commissions and/or incentives (from 5-25% of employee’s monthly sales)
Employee referral bonuses
Shift differential pay
Medical, dental, and vision plans for themselves and their eligible family members with generous employer premium cost shares