Data Analyst I, Product

Mercury Insurance

. Gather, organize, and prepare data from internal and external sources for analysis .

Posted 11/10/2026full-timeRemote • United StatesMid-LevelSenior💰 $63,410 - $117,348 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong analytical skills with proficiency in SQL and Microsoft Excel for data analysis and reporting. Capable of interpreting results, ensuring data quality, and effectively communicating findings to stakeholders.

Highest-signal resume keywords

SQL ProficiencyData Analysis ExperienceMicrosoft Excel ExpertiseAttention To DetailClear Communication Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisStatistical SkillsData CleanupData IngestionReporting ProcessesTrend AnalysisCompetitive IntelligenceDocumentationBasic Dashboard PreparationProblem-Solving

Soft Skills

Attention To DetailWillingness To LearnCollaborationClear CommunicationTask Management

Tools & Technologies

SQLMicrosoft ExcelPythonRDbtGit/GitHubBusiness Intelligence ToolsReporting Tools

Industry Keywords

Property And Casualty InsurancePersonal LinesFinancial ServicesCompetitive PositionData Quality Checks

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

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
Support recurring and ad hoc analyses related to products’ competitive position
Prepare and maintain reports, charts, spreadsheets, and basic dashboards
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

Requirements

What you’ll need

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

Comp & perks

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