[Hiring] Data Analyst I @Mercury Insurance Services

Role Description

Under close supervision and guidance, the Data Analyst I, Product supports analysis of personal lines product performance and competitive position. The analyst gathers, validates, and organizes internal and external data; prepares reports and visualizations; and shares findings with Product and cross-functional partners. The role applies foundational analytical and statistical methods to defined business questions and contributes to product and process improvement work.

Responsibilities

• Gather, organize, and prepare data from internal and external sources for analysis; perform basic checks for completeness and accuracy and flag data issues.
• Analyze product and competitive data to identify trends, differences, and potential issues or opportunities, with guidance from senior team members or Product leaders.
• Support recurring and ad hoc analyses related to products’ competitive position.
• Prepare and maintain reports, charts, spreadsheets, and basic dashboards to communicate analysis results.
• Assist with data ingestion, data cleanup, and documentation for competitive data used in personal lines analysis.
• Use established SQL queries, analytical code, and reporting processes; make routine updates and seek review for material changes.
• Document methods, assumptions, and findings so analyses can be understood and repeated.
• Work with Product and other partners to clarify data needs and provide analysis support.
• Contribute to small, defined-scope projects and process improvements; escalate questions, data-quality concerns, and unexpected results.
• Present findings to colleagues and managers as appropriate, with support in developing recommendations.
• Perform other related duties as assigned.

Qualifications

• Minimum: Bachelor’s degree in an analytical field such as mathematics, statistics, economics, data science, engineering, finance, or a related discipline preferred, or an equivalent combination of education and experience.
• Minimum: 1+ year of experience in data analysis, product development, competitive intelligence, insurance, financial services, or a related field preferred; equivalent education or experience may be considered.
• Preferred: Property and casualty insurance or personal lines experience is a plus.
• Preferred: Experience using SQL, Excel, or similar tools to organize and analyze data.

Knowledge and Skills

• Foundational analytical and statistical skills, including the ability to interpret results and recognize when findings need further review.
• Proficient in SQL and Microsoft Excel; exposure to Python, R, dbt, Git/GitHub, or business intelligence and reporting tools is a plus.
• Ability to work with structured data, follow established procedures, and perform basic data-quality checks.
• Strong attention to detail, problem-solving skills, and willingness to learn new tools and business processes.
• Clear written and verbal communication skills, including the ability to explain analysis in a straightforward way.
• Ability to collaborate effectively and manage assigned tasks with guidance.

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

Pay Range

USD $63,410.00 - USD $117,348.00 /Yr.