Senior Product Analyst

PEMCO•Seattle, WA

5d•Remote

About The Position

The Senior Product Analyst conducts complex quantitative analysis of property and casualty insurance products to improve product performance and support PEMCO and Product initiatives. The role partners with Product Managers and the Actuarial team to develop analytical strategies, evaluate product performance, identify trends and issues, and make actionable recommendations, including pricing recommendations. The analyst plans and manages large-scale, complex projects with support; documents system workflows and business processes; builds queries, dashboards, tools, and processes to analyze product metrics; and identifies improvements to data strategy, data warehousing, and analytical efficiency. The position also prepares materials for rate filings, communicates analysis and its value to business stakeholders, and may assist less experienced analysts. Applicants must reside and work in WA, OR, OH, IL, MN, NC, SC, FL, AZ, TX, or ID. Occasional travel to PEMCO’s Seattle, Washington headquarters is required. Compensation depends on qualifications, job-related knowledge, skills, experience, and location. The Greater Seattle target pay range is $116,338–$142,190, with a full range of $96,948–$161,580. Outside Greater Seattle, the target range is $102,670–$125,486, with a full range of $85,559–$142,598.

Requirements

B.A. or B.S. degree, or equivalent work experience, in economics, business, information technology, mathematics, or an equivalent quantitative field of study.
At least 3 years of experience in the property and casualty insurance industry.
At least 6 years of experience in analytical roles of increasing scale, scope, and complexity involving insurance product pricing or similar work.
Experience integrating, managing, and manipulating large data files from various corporate systems and external sources.
Ability to analyze, diagnose, and resolve complex, unstructured problems quickly, efficiently, and collaboratively.
Ability to organize data visually and present clearly and persuasively to peer groups and senior management.
Strong attention to detail and a desire for accuracy and thoroughness.
Excellent time-management and organizational skills, including the ability to manage multiple tasks, activities, and projects.
Proficiency in Excel, Word, PowerPoint, and Outlook.
Proficiency in SQL, SQL Server, and data visualization.
High-level skill in quantitative modeling, knowledge of data structures, and ability to write complex SQL queries.
Self-motivation and ability to work independently with limited direction and communicate relevant information during uncertainty.
Ability to analyze disparate datasets, collaborate to turn data into meaningful insights, work with external vendors to integrate data, and build efficient, scalable infrastructure and data models.
Knowledge and understanding of relevant laws, rules, and regulations.
Clear, informative verbal and written communication with colleagues, customers, and the community in technical and non-technical professional language.
Analytical, structured thinking; ability to frame complex ideas clearly, perform root-cause analysis, and develop high-quality, usable, consistent metrics that support strategic objectives and priorities.
Must reside and work in WA, OR, OH, IL, MN, NC, SC, FL, AZ, TX, or ID.
Must be able to travel occasionally to PEMCO’s headquarters in Seattle, Washington.

Nice To Haves

Graduate or other professional degree, or equivalent work experience.
Proficiency in Power BI, Tableau, and WTW Radar.

Responsibilities

Plan and manage large-scale, complex projects with support.
Document complex system workflows and business processes.
Develop and implement analytical strategies in partnership with Product Managers and the Actuarial team.
Create queries, dashboards, and tools to analyze and track 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 to business stakeholders and explain its value.
Build tools and processes that improve efficiency, especially in analyzing metrics.
Assist less experienced analysts as needed or assigned.
Assist in product and rating reviews, including making pricing recommendations.
Conduct complex analysis to evaluate product performance, identify trends and issues, and recommend actionable improvements.
Demonstrate behaviors consistent with PEMCO policies, values, code of ethics, and business conduct.
Support the PEMCO brand and help identify top talent aligned with PEMCO’s mission.
Perform other duties as assigned.

Benefits

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