Mercury Insurance

Product Analyst II

Mercury Insurance

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $76,829 - $142,213 per year

About the role

  • Monitor and analyze product performance (growth, profitability, mix, retention, and segment results) for assigned states and lines of business.
  • Identify emerging issues, trends, and opportunities; recommend actions to improve loss ratio, growth, and mix.
  • Use tools such as SQL/SAS/R/Python, Excel, and PowerBI/Hex, and rating/competitive tools to develop and validate datasets used for performance, pricing, and segmentation analysis and visualizations.
  • Build and maintain repeatable analytics, dashboards, and tools (e.g., Excel, BI tools) to monitor key KPIs and support decision making.
  • Support development of state and line business plans, including forecasts, production expectations, and performance targets.
  • Support Actuarial and Product Managers in designing, testing, and implementing rating and product changes for assigned states.
  • Prepare written summaries, presentations, and visualizations (charts, graphs, dashboards) that communicate key insights, recommended actions, and expected impacts.

Requirements

  • 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.
  • Strong analytical, critical thinking, and problem solving skills; able to structure ambiguous questions and turn data into clear recommendations.
  • Proficiency with Microsoft Excel and SQL required; experience with SAS, R, Python, and/or BI tools (Power BI, Hex, Tableau, etc.) preferred.
Benefits
  • Competitive compensation
  • Flexibility to work from anywhere in the United States for most positions
  • Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
  • Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
  • Medical, dental, vision, life, and pet insurance
  • 401 (k) retirement savings plan with company match
  • Engaging work environment
  • Promotional opportunities
  • Education assistance
  • Professional and personal development opportunities
  • Company recognition program
  • Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLSASRPythonExcelPower BIHexdata analysispricing analysissegmentation analysis
Soft Skills
analytical skillscritical thinkingproblem solvingcommunication skillsdecision making