Stagiaire Product Analyst H​/F

Applicants must be a resident and work from one of the following states: WA, OR, OH, IL, MN, NC, SC, FL, AZ, TX, or , with occasional travel to our headquarters, located in Seattle, WA. 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. 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.

The Principal 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. As a principal level role, this position helps to shape Product strategy through data analysis and guide product development with relevant analytical insights.
Serve as a thought leader for new, complex, and ambiguous business questions; represent Product in cross-functional projects.
Represent the Product department in development of company data strategy; serve as catalyst of change for Product data warehousing and processes.
Proactively lead complex analysis to evaluate the performance of our products; maintain a constant pulse on health of the business and Product department by tracking key performance indicators against targets and investigating key trends and their underlying drivers.
Present analysis and data visualizations to stakeholders and executives clearly and persuasively.
Plan and manage large-scale, complex projects independently.
Pioneer best practices in PEMCO product builds, tools, and processes to improve analysis and efficiencies.
Lead the development and implementation of analytical strategies with our Product Manager(s) and Actuarial team.
Develop and document complex system workflows and business processes.
identify enhancements and efficiency gains in data strategy and warehousing; consult on data fields, calculations, and methodology.
Mentor less experienced analysts, helping them improve and sharpen their skills by sharing best practices.
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.

• S. degree or equivalent work experience (Business, Economics, mathematics, or other quantitative fields of study) is required
• ~ Graduate or other professional degree or equivalent work experience is preferred
• ~10+ years of experience in corporate 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
• ~ 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
• ~ Skilled proficiency in SQL, SQL Server, and data visualization is required
• ~ Communicator:
  The ability to communicate clearly and informatively, verbally and in writing, with colleagues,…