Product Analyst

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

Applicants must be a resident and work from one of the following states: WA, OR, OH, IL, MN, NC, SC, FL, TX or ID, with occasional travel to our headquarters, located in Seattle, WA.

Who We Are:

At PEMCO, we’re all about people – our customers, our employees, and the community. We’re a mutual insurance company owned by our Northwest policyholders. We provide auto, home, renters, and boat coverage. Recognized by Forbes as one of America’s Best Insurance Companies in both Auto and Home for 2026, based on customer survey feedback, and by Newsweek as one of America’s Greatest Midsize Workplaces 2025. We are consistently recognized for our outstanding customer service, employee expertise, community partnerships, and social impact programs. All of which makes PEMCO a great place to work!

Our social impact programs motivate high achievement by youth in education; build stronger and greener communities; and increase safety at home, on the road, and at play. We’re committed to diversity, equity, inclusion, and belonging, and to fostering an inspiring and inclusive workplace. These efforts create and cultivate an environment that builds fairness and understanding, encourages collaboration and flexibility, and celebrates all the ways in which we’re different and the same – enabling all individuals to achieve their full potential.

Why We Need You:

The Product Analyst position is responsible for working closely with our Product Managers and Actuaries to provide analyses and to contribute to the development of recommendations that will support PEMCO's and Product's initiatives.

What You’ll Be Doing:

• Manage expectations; prioritize own workload and communicate status.
• Perform semi-complex analysis to evaluate the performance of and identify trends and issues for our products and make actionable recommendations for improvements.
• Document system workflows and business processes.
• Contribute to the achievement of short and long-term strategies to achieve profitable growth leveraging quantitative and qualitative data.
• Compile and submit materials for rate and form filings.
• Build tools to create efficiencies, especially in analyzing metrics.
• Assist in product and rating reviews.
• Plan and manage small to medium scale projects.
• Query databases to generate scheduled and ad hoc reports and analysis to support department goals.
• 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.
  

What You'll Bring:

• B.A. or B.S. degree or equivalent work experience (Business, Economics, mathematics, or other quantitative fields of study)
• 1 year of experience in the property and casualty insurance industry is required
• 3+ years of experience in analytical roles pricing insurance products or similar work is required
• Problem Solver: Ability to analyze, diagnose and resolve complex unstructured problems quickly, efficiently, and collaboratively is required
• Precision: Is detail orientated and has a strong desire for accuracy and thoroughness is required
• MS Office: Skilled proficiency in Excel, Word, PowerPoint, Outlook is required
• Job specific: Experience in SQL and SQL Server is required
• Highly Analytical: 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
• Communicator: 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
• Analytical and data-driven: 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
• Job specific: Experience in data visualization, PowerBI, and Tableau is preferred
• Compliance: Knowledge and understanding of relevant laws, rules, and regulations

Compensation:

The pay range for this role is shown below. Compensation decisions are determined based on an individual’s qualifications, job-related knowledge, skills, and experience.

• Greater Seattle area target pay range: $96,147 - $117,513. The full pay range is $80,123 - $133,538.
• Outside Greater Seattle area target pay range: $84,852 - $103,708. The full pay range is $70,710 - $117,850.

Greater Seattle Area is defined as working within approximately 100 miles of Seattle.
Outside Greater Seattle is defined as working approximately 100 miles or more from Seattle.

Benefits:

Regular part-time PEMCO employees working at least 24 hours per week and regular full-time PEMCO employees are eligible to elect coverage under medical, dental, and vision plans for themselves and their eligible family members with generous employer premium cost shares. In addition, as a benefits-eligible employee, you are:

• covered by employer-paid basic life and accidental death & dismemberment insurance policies as well as long- and short-term disability benefit coverages.
• eligible to participate in PEMCO’s 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).

PEMCO provides the following paid leave programs for benefits-eligible employees in their first year of PEMCO employment:

• Vacation and eight (8) paid holidays.
• Granted four (4) floating holidays and up to ten (10) days of sick leave immediately upon hire (pro-rated based on hire date and full-time/part-time status).
• In addition, PEMCO provides paid time off for bereavement, jury duty, and employee volunteering in the community.

Other miscellaneous benefit programs offered by PEMCO include:

• Education Assistance Program after one year of service.
• Scholarship program for children of PEMCO employees after one year of service; children’s birthday gift program
• Flexible Spending Accounts, Employee Assistance Program, and charitable gift matching

Other compensation depending on role, contributions, and performance may include:

• Discretionary bonuses.
• Tiered sales commissions and/or incentives

Equal Employment Opportunity:

At PEMCO, we celebrate and support our differences. We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products, and our community to flourish. PEMCO is honored to be an equal opportunity workplace. We are dedicated to equal employment opportunities regardless of race, color, ancestry, religion, sex, national orientation, age, citizenship, marital status, disability, gender identity, sexual orientation, or veteran status.

Accommodations

At PEMCO, people are at the heart of our business. We’re committed to providing an inclusive hiring experience for all candidates. If you need reasonable accommodations to apply for a role or participate in an interview, please contact us by email with your name, the job reference number(s), your preferred contact method, and a brief description of the accommodation needed. Requests are considered on a case by case basis in accordance with applicable disability laws, including the ADAAA.

Applicants have rights under Federal Employment Laws:

• Family and Medical Leave Act (FMLA)
• Equal Employment Opportunity (EEO)
• Employee Polygraph Protection Act (EPPA)