Senior Product Analyst

PEMCO; Columbus (OH); Hybrid; USD 103,000 - 125,000; Full time

Benefits offered by this job

401(k) plan with employer match

Paid holidays and vacation

Floating holidays and sick leave

Job summary

PEMCO is seeking a Senior Product Analyst to perform complex quantitative analysis of property and casualty products. You will partner with Product Managers and Actuarial teams to improve product performance and support initiatives.

You will plan large projects, document workflows, develop analytical strategies, and build dashboards to track product success and drive data-driven pricing decisions. Occasional travel to headquarters in Seattle may be required.

Qualifications

• 3 years in property and casualty insurance required.
• 6+ years in analytical roles with pricing experience and large data manipulation.
• Proficiency in SQL, data modeling, and reporting tools.

Responsibilities

• Plan and manage large-scale projects with support.
• Document complex workflows and business processes.
• Develop analytical strategies with Product Managers and Actuarial team.
• Create queries, dashboards, and tools to analyze product success.
• Submit materials for rate filings and communicate findings to stakeholders.
• Build efficiencies in data strategy and warehousing.

Skills

Analytical mindset

Presentation skills

Detail-oriented

Time management

MS Office proficiency

SQL proficiency

Data visualization

Independent work

Communication

Problem solving

Education

B.A. or B.S. in economics, business, IT, math, or quantitative field

Graduate degree preferred

Tools

SQL Server

Power BI

Tableau

WTW Radar

Job description

Applicants must be a resident and work from one of the following states: WA, OR, OH, IL, MN, NC, SC, FL, AZ, 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 Senior Product Analyst position is responsible for conducting complex quantitative analysis of property & casualty products to improve product performance and support PEMCO’s and Product’s initiatives.

What You’ll Be Doing:

• 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.

What You’ll Bring:

• B.A. or B.S. degree or equivalent work experience (economics, business, information technology, mathematics, or equivalent quantitative field of study) is required
• Graduate or other professional degree or equivalent work experience is preferred
• 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
• Problem Solver: Ability to analyze, diagnose and resolve complex unstructured problems quickly, efficiently, and collaboratively is required
• Presenter: Organizes data visually and speaks clearly and persuasively in group presentations and meetings with multiple peer groups and senior management is required
• Precision: Is detail orientated and has a strong desire for accuracy and thoroughness is required
• Organized: Has excellent time management skills and easily manages multiple tasks, activities, and projects is required
• MS Office: Skilled proficiency in Excel, Word, PowerPoint, Outlook is required
• Job specific: Proficiency in SQL, SQL Server, and data visualization is required
• Job specific: Ability to demonstrate high level of skill in quantitative modeling, knowledge of data structures and ability to write complex SQL queries is required
• Independent: 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
• 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
• Compliance: Knowledge and understanding of relevant laws, rules, and regulations 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: Proficiency in Power BI, Tableau, and WTW Radar is preferred

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: $116,338 - $142,190. The full pay range is $96,948 - $161,580.Outside Greater Seattle area target pay range: $102,670 - $125,486. The full pay range is $85,559 - $142,598.

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)