
Product Analyst II
Mercury Insurance
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
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