Data Analyst I Product

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

Benefits offered by this job

Competitive compensation

Remote work flexibility

Paid time off

Bonus programs

Health, dental, vision insurance

401(k) with company match

Professional development

Job summary

Mercury Insurance Services, LLC is seeking a Data Analyst I, Product to support analysis of personal lines product performance and competitive position. You will gather, validate, and organize data, prepare reports and visualizations, and share findings with Product and cross-functional partners.

Under supervision, you will apply foundational analytical methods to defined business questions and contribute to product and process improvements, with opportunities to grow alongside senior team

Qualifications

• 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
• 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
• 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

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; 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

Skills

SQL

Excel

Python

R

dbt

Git/GitHub

BI tools

Education

Bachelor's degree in analytical field

Tools

Python

R

dbt

Git/GitHub

BI tools

Job description

Overview

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

State specific pay scales for this role are as follows:

$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

The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.

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.

Qualifications

Education:

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:

Minimum:

• 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

#LI-ZK1

Perks and Benefits

We offer many great benefits, including:

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