Principal Product Analyst

PEMCO•Seattle, WA

20d

About The Position

The Principal Product Analyst conducts complex quantitative analysis of property and casualty insurance products to improve product performance and support PEMCO’s initiatives. This principal-level position helps shape Product strategy through data analysis and guides product development with relevant analytical insights. Applicants must reside and work in WA, OR, OH, IL, MN, NC, SC, FL, AZ, TX, or ID, with occasional travel to PEMCO’s Seattle, WA headquarters. The role serves as a thought leader on complex and ambiguous business questions and represents Product in cross-functional projects and company data strategy. It proactively evaluates product performance, tracks key indicators, identifies trends and underlying drivers, and presents actionable recommendations to product managers, leadership, stakeholders, and executives. The analyst independently plans and manages complex projects, leads product and rating reviews, makes pricing and underwriting recommendations, and manages filing workflows. The position also develops analytical strategies with Product Managers and Actuarial, builds and improves queries, dashboards, tools, data processes, and system workflows, and consults on data fields, calculations, and methodology. It pioneers product-build practices and efficiency improvements, mentors less experienced analysts, and demonstrates PEMCO’s values, policies, and code of conduct while supporting the brand and talent recruitment. PEMCO is a mutual insurance company owned by its Northwest policyholders, offering auto, home, renters, and boat coverage. It highlights its customer service, employee expertise, community partnerships, and social impact programs, and is committed to diversity, equity, inclusion, belonging, and an inclusive workplace.

Requirements

B.A. or B.S. degree, or equivalent work experience, in Business, Economics, mathematics, or another quantitative field.
At least 10 years of experience in corporate analytical roles of increasing scale, scope, and complexity involving insurance product pricing or similar work, including integrating, managing, and manipulating large data files from corporate systems and external sources.
At least 5 years of experience in the property and casualty insurance industry.
Excellent time management and ability to manage multiple tasks, activities, and projects.
Thorough understanding of the insurance industry, business landscape, growth trends, and insurance environments, with ability to identify early indicators of change and adapt strategies.
Knowledge and understanding of relevant laws, rules, and regulations.
Skilled proficiency in Excel, Word, PowerPoint, and Outlook.
Skilled proficiency in SQL, SQL Server, and data visualization.
Ability to quickly, efficiently, and collaboratively analyze, diagnose, and resolve complex, unstructured problems.
Ability to communicate clearly and informatively, verbally and in writing, with technical and non-technical audiences.
Ability to organize data visually and present persuasively in meetings with peer groups and senior management.
High-level quantitative modeling skills, knowledge of data structures, and ability to write complex SQL queries.
Attention to detail and a strong commitment to accuracy and thoroughness.
Self-motivation and self-direction; ability to work with limited direction and communicate relevant information during uncertainty.
Ability to work with disparate datasets, integrate external vendor data, and develop efficient, scalable infrastructure and data models.
Analytical, structured thinking; ability to conduct root-cause analysis and develop high-quality, consistent metrics that support strategic objectives.
Cross-functional effectiveness combining technical depth and business understanding, with critical thinking, listening, and observation skills.

Nice To Haves

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

Responsibilities

Serve as a thought leader for new, complex, and ambiguous business questions and represent Product in cross-functional projects.
Represent Product in development of company data strategy and catalyze improvements to Product data warehousing and processes.
Lead complex analysis of product performance, identify trends and anomalies, make actionable recommendations, and track key performance indicators and underlying business drivers.
Present analysis and data visualizations clearly and persuasively to stakeholders and executives.
Independently plan and manage large-scale, complex projects.
Develop best practices in product builds, tools, and processes to improve analysis and efficiency.
Own end-to-end product and rating reviews, including pricing and underwriting recommendations.
Manage filing workflows for Product initiatives and improve internal and external filing processes.
Lead analytical strategy development and implementation with Product Managers and the Actuarial team.
Develop and document complex system workflows and business processes.
Create advanced queries, dashboards, and tools to analyze and track product success; identify data strategy and warehousing enhancements; and consult on data fields, calculations, and methodology.
Mentor less experienced analysts and share best practices.
Demonstrate behaviors consistent with PEMCO policies, values, and code of ethics and business conduct.
Support the PEMCO Brand, look for talent to join the company, and perform other duties as assigned.

Benefits

Medical, dental, and vision coverage for eligible employees and eligible family members, with employer premium cost shares.
Employer-paid basic life and accidental death and dismemberment insurance.
Long- and short-term disability coverage.
401(k) plan with employer match of 2 for 1 on the first 6% of employee pre-tax and/or Roth deferral, up to federal maximums.
Vacation and eight paid holidays in the first year for benefits-eligible employees.
Four floating holidays and up to ten days of sick leave upon hire, prorated based on hire date and full-time or part-time status.
Paid bereavement leave, jury duty leave, and employee volunteering time.
Education Assistance Program after one year of service.
Scholarship program for employees’ children after one year of service.
Children’s birthday gift program.
Flexible Spending Accounts.
Employee Assistance Program.
Charitable gift matching.
Potential discretionary bonuses and, depending on role, tiered sales commissions and/or incentives.