Data Analyst I Product

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

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

• 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

**Education:**

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

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

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

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