Mercury Insurance logo
Mercury InsurancePosted 4 months ago

Product Analyst II

$98,569–$136,901 year

RemoteUnited States

Full TimeLarge

Job Summary

Monitor product performance and profitability for assigned states, using SQL, Python, and BI tools to analyze growth, retention, and mix while identifying trends that impact loss ratios. Build repeatable dashboards and validate datasets to support state and line business plans, including forecasts and performance targets. Partner with Actuarial, R&D, and Underwriting teams to design, test, and implement rating changes, preparing filings and translating technical findings into clear summaries for leadership. Present analysis and recommendations to stakeholders, refine outputs based on feedback, and mentor junior analysts on best practices.

Required Qualifications

  • Bachelor's degree in Business, Mathematics, Statistics, Economics, Finance, Actuarial Science, Data Analytics, or a related quantitative field
  • 3+ years of experience in product management, pricing, analytics, actuarial, or related roles in insurance, financial services, or a similar data driven industry
  • Experience working with large datasets and performing analytical work using tools such as SQL, SAS, R, Python, or similar
  • Proficiency with Microsoft Excel and SQL
  • Strong analytical, critical thinking, and problem solving skills
  • Ability to summarize complex technical findings for non technical audiences in clear, concise language
  • Demonstrated ability to manage multiple analyses and deadlines, work independently, and follow through on commitments
  • Strong collaboration and communication skills
  • Proven history of taking initiative and driving projects or analyses from concept through implementation and monitoring
  • Ability to summarize complex technical findings for non technical audiences in clear, concise language
  • Experience supporting state product management, pricing, or filings (e.g., competitive analysis, rate indications, monitoring initiatives) for multi state portfolios
  • Prior work in or with Product Management state teams

Desired Qualifications

  • Master's degree in a related field and/or industry designations (e.g., AINS, CPCU, actuarial exams, or similar)
  • Property & Casualty insurance experience, ideally in Personal Lines Auto and/or Property
  • Experience supporting state product management, pricing, or filings (e.g., competitive analysis, rate indications, monitoring initiatives) for multi state portfolios
  • Prior work in or with Product Management state teams
  • Experience with SAS, R, Python, and/or BI tools (Power BI, Hex, Tableau, etc.)
  • Ability to summarize complex technical findings for non technical audiences in clear, concise language
  • Demonstrated ability to manage multiple analyses and deadlines, work independently, and follow through on commitments
  • Strong collaboration and communication skills
  • Proven history of taking initiative and driving projects or analyses from concept through implementation and monitoring

Hiring someone like this?

Get your role in front of qualified candidates on Sorce.

Get started

Apply to this job in one click with Sorce

Apply on Sorce