Data Analyst

Mercury Insurance

Data Analyst at Mercury Insurance interpreting complex claims data and performing data-driven analysis. Responsibilities include trend analysis and development of reports and visualizations.

Posted 7/31/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $76,829 - $142,213 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates strong analytical capabilities with advanced proficiency in SQL and experience in data visualization tools like PowerBI. Possesses a solid foundation in statistics and model building, along with the ability to communicate insights effectively to leadership.

Highest-signal resume keywords

Advanced Proficiency In SQLProficiency In PowerBIExperience With Python And/or RStrong Data SkillsExcellent Written And Verbal 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 KnowledgeModel BuildingData InterpretationData VisualizationTrend IdentificationData RetrievalReport PreparationForecastingData Accuracy Review

Soft Skills

Problem-SolvingAnalytical ThinkingAttention To DetailTime ManagementTeam Collaboration

Tools & Technologies

SASSQLPowerBIPythonR

Industry Keywords

InsuranceClaims DepartmentData-Driven AnalysisBusiness DecisionsData Support

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

The primary job function, under general supervision, is interpreting complex data sets related to various operations of the Claims Department and provide data-driven analysis.
Responsible for analyzing and interpreting data, identifying trends and patterns, and providing insights to drive business decisions.
Use knowledge of statistics and various data analytical tools to develop reports, dashboards, and visualizations.
Works with claims leaders and independently to identify and provide data support to recognize opportunities.
Collaborates with other departments in Claims and other divisions of the company (Product, U/W, IT Domain Teams, etc.) on implementing solutions to business problems.
Supports claims projects by applying general knowledge of the business area processes, including best practices.
Retrieves data from various sources and prepares data for analysis.
Reviews data for accuracy and revises methods of data retrieval when necessary.
Prepares reports, graphs and charts based on research and analyses.
Analyzes data and identifies trends in data to provide meaningful suggestions and recommendations to leadership.
May assist with forecasting future claims activity to plan for future risks.
Serves as a contact for basic reporting needs/issues and on demand reports.
Communicates proactively, clear, and consistently with SME’s and leadership in the various claims operations to understand each job function.
Creates presentations breaking down problems identified, potential solutions.
Develops spreadsheets and visual tools for management use.
May attend management meetings to present findings and recommendations.

Requirements

What you’ll need

Bachelor’s degree in an analytical concentration, such as math, statistics, engineering.
SAS and SQL Training
At least 3 years experience of insurance related experience preferably in an analytical role, or equivalent combination of education and experience.
Advanced proficiency in SQL required.
Proficiency in PowerBI and other data visualization tools.
Experience with Python and/or R a plus.
Knowledge of statistics and general model building/validation procedures required.
Strong data skills and ability to work with massive datasets.
Good problem-solving skills required.
Good analytical and critical thinking required.
Strong attention to detail and accuracy.
Excellent written and verbal communication skills required.
Must have the ability to produce quality work within tight timeframes, simultaneously manage multiple projects and the ability to work in a team setting.
Requires the ability to work a flexible schedule and travel as needed, which may require overnight and/or weekend stays.
Requires the ability to adhere to the Company’s privacy policy due to the sensitive nature of information handled in this position.

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