[Remote] Product Analyst II

Note: The job is a remote job and is open to candidates in USA. Mercury Insurance is a company dedicated to helping people reduce risk and navigate unexpected events. They are seeking a Product Analyst II to support their Product Management team by analyzing product performance, developing analytics tools, and collaborating with various departments to implement product changes.

Responsibilities

• 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
• Compare proposed rating plans to current plans and competitors to understand rate level, segmentation, and dislocation impacts; summarize results and implications for Product Managers
• Validate data quality and ensure analytic outputs are accurate, reproducible, and aligned with business definitions
• Recommend and implement process improvements to streamline recurring analyses and reduce manual effort
• Partner with Actuarial, R&D, Underwriting, Sales, IT, and Claims, and others to define requirements and support implementation of rate and product changes in assigned states
• Support state rate filing efforts by preparing exhibits and analysis under direction of Product Managers and/or Actuarial
• Help translate technical findings into clear, business friendly summaries and talking points for leadership, field partners, and other non technical audiences
• Prepare written summaries, presentations, and visualizations (charts, graphs, dashboards) that communicate key insights, recommended actions, and expected impacts
• Present analysis and recommendations to Product Managers and other stakeholders; respond to questions and refine analyses as needed
• May mentor or coach Product Analyst I or other team members on tools, methods, and best practices

Skills

• 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
• 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, with the ability to build effective working relationships across Product, Actuarial, Underwriting, Sales, IT, Claims, and other partners
• Proven history of taking initiative and driving projects or analyses from concept through implementation and monitoring
• 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

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

Company Overview

Company H1B Sponsorship