Senior Product Analyst

Job Description

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 2025 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 '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:

PEMCO has a dynamic and challenging opportunity for a Senior Product Analyst to join our community. In this role, you will be 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.
• Proficiency in Power BI, Tableau, and WTW Radar is preferred.
• 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.
• 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.
• 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…