Data Analyst I Product

Mercury Insurance; United States; Remote; USD 63,000 - 117,000; Full time

Benefits offered by this job

Competitive pay

Remote-friendly

Paid time off

Bonus programs

Insurance coverage

401(k)

Job summary

Mercury Insurance in the United States is hiring a Data Analyst I, Product to support analysis of personal lines product performance and competitive position. Under supervision, you gather, validate, and organize data, prepare reports and visualizations, and share findings with Product and cross-functional partners.

This entry-level role applies foundational analytical methods to define business questions and contribute to product and process improvements.

Qualifications

• Bachelor's degree in an analytical field or equivalent experience.
• 1+ year of data analysis or related experience.
• Experience with SQL and Excel preferred.

Responsibilities

• Gather, organize, and prepare data for analysis; perform basic quality checks.
• Analyze product and competitive data to identify trends and opportunities with guidance.
• Prepare reports, charts, and dashboards to communicate results.
• Assist with data ingestion, cleanup, and documentation for competitive data.
• Present findings and provide recommendations to colleagues and managers.

Skills

SQL

Excel

Statistics

Python

R

Git

Data visualization

Education

Bachelor's degree

Tools

dbt

GitHub

BI tools

Job description

Join an amazing team that is consistently recognized for our achievements and culture, including our most recent Forbes award of being one of America's Best Midsize Employers for 2026!

Position Summary

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.

Geo-Salary Information

An in-person interview may be required during the hiring process

• $63,410 to $117,348 (NJ, NY, WA, HI, AK, MD, CT, RI, MA)
• $57,646 to $106,680 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)
• $51,881 to $96,012 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)
• In CA: Typical hiring range is $81,341 to $112,974

Responsibilities

Essential Job Functions:

• 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; elevate 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.

Education

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

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.
• Experience using SQL, Excel, or similar tools to organize and analyze data is preferred.

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.

About The Company

Why choose a career at Mercury?

At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t imagine a world without it.

Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life.

We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a variety of benefits to help our team members reach their health, retirement, and professional goals.

Learn more about us here: https://www.mercuryinsurance.com/about/careers

Perks And 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

Mercury Insurance is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law.

Pay Range

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