Principal Product Analyst

PEMCO•Seattle, WA

22d•$103,526 - $195,511

About The Position

The Principal Product Analyst conducts complex quantitative analysis of property and casualty products to improve product performance and support PEMCO and Product initiatives. This principal-level role helps shape Product strategy through data analysis and guides product development with relevant analytical insights. The position represents Product in cross-functional work and company data-strategy development, leading complex analysis, product and rating reviews, filing workflows, and analytical strategies in partnership with Product Managers and the Actuarial team. The analyst develops queries, dashboards, tools, system workflows, and business processes; presents findings to stakeholders and executives; and mentors less experienced analysts. Applicants must reside and work in WA, OR, OH, IL, MN, NC, SC, FL, TX, or ID, with occasional travel to PEMCO’s Seattle headquarters.

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.
Strong time management and organizational skills, including the ability to manage multiple tasks, activities, and projects.
Thorough understanding of the industry, business landscape, and growth and insurance-environment trends, with the 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 write complex SQL queries and demonstrate advanced quantitative modeling and knowledge of data structures.
Ability to analyze, diagnose, and resolve complex, unstructured problems efficiently and collaboratively.
Clear verbal and written communication with technical and non-technical audiences.
Ability to organize data visually and present persuasively to peer groups and senior management.
Attention to detail and strong commitment to accuracy and thoroughness.
Self-motivated and self-directed, able to work with limited direction and communicate relevant information to appropriate levels during uncertainty.
Ability to work with disparate datasets, integrate external-vendor data, translate data into meaningful insights, and build efficient, scalable infrastructure and data models.
Structured, analytical approach to root-cause analysis and development of high-quality, consistent metrics that support strategic objectives and priorities.
Cross-functional organizational savvy, combining technical depth and business judgment with understanding of company objectives and strong 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 on new, complex, and ambiguous business questions and represent Product in cross-functional projects.
Represent Product in developing company data strategy and drive improvements to Product data warehousing and processes.
Lead complex analysis of product performance; identify trends and anomalies; recommend actions to product managers and leadership; track KPIs against targets and investigate underlying drivers.
Present analyses and data visualizations clearly and persuasively to stakeholders and executives.
Plan and independently manage large-scale, complex projects.
Establish best practices for product builds, tools, and processes to improve analytical capability 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 development and implementation of analytical strategies 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 improvements to data strategy and warehousing; advise on data fields, calculations, and methodology.
Mentor less experienced analysts by sharing best practices and helping them develop their skills.
Demonstrate behavior consistent with PEMCO policies, values, ethics, and business conduct; support the PEMCO brand and help identify talent.
Perform other duties as assigned.

Benefits

Medical, dental, and vision coverage for eligible employees and their eligible family members, with employer premium cost shares.
Employer-paid basic life and accidental death and dismemberment insurance, and long- and short-term disability coverage.
401(k) plan with employer match of 2:1 on the first 6% of employee pre-tax and/or Roth deferrals, up to federal maximums.
Vacation and eight paid holidays.
Four floating holidays and up to ten days of sick leave available upon hire, prorated by 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 and a children’s birthday gift program.
Flexible Spending Accounts and Employee Assistance Program.
Charitable gift matching.
Discretionary bonuses may be offered depending on role, contributions, and performance.