Data Analyst I Product

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!

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.

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.

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

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

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.

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