Data Analyst
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Analyst interpreting claims data for Mercury Insurance. Building SQL reports, dashboards, and visualizations to guide insurance operations.
Responsibilities:
- Interpret complex data sets related to Claims Department operations and provide data-driven analysis
- Analyze and interpret data, identify trends and patterns, and provide insights to drive business decisions
- Develop reports, dashboards, and visualizations presenting complex data clearly and concisely
- Work with claims leaders to identify opportunities and provide data support
- Collaborate with Claims departments and other company divisions, including Product, Underwriting, and IT Domain Teams, to implement solutions
- Support claims projects using knowledge of business-area processes and best practices
- Retrieve data from various sources and prepare it for analysis
- Review data accuracy and revise data retrieval methods when necessary
- Prepare reports, graphs, and charts based on research and analysis
- Provide suggestions and recommendations to leadership based on identified data trends
- Assist with forecasting future claims activity and planning for future risks
- Serve as a contact for basic reporting needs, issues, and on-demand reports
- Communicate with subject matter experts and leadership to understand claims operations, processes, and KPIs
- Create presentations explaining identified problems and potential solutions
- Develop spreadsheets and visual tools for management use
- Present findings and recommendations at management meetings as needed
- Coordinate and execute reporting using Guidewire Database, NextGen Database, and Enterprise Data Warehouse
- Direct and support underwriting users and leaders in identifying data needed for reporting
- Maintain regular full-time attendance of at least 8 hours and 40 hours per week
- Perform other assigned functions
Requirements:
- Bachelor’s degree in an analytical concentration, such as math, statistics, or engineering
- SQL Training
- Master’s degree is required in lieu of work experience
- At least 3 years 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 is 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
- Professional written and verbal communication skills and ability to present findings on underwriting data projects
- Ability to produce quality work within tight timeframes and simultaneously manage multiple projects
- Ability to work in a team setting
- Ability to work a flexible schedule and travel as needed, potentially including overnight and/or weekend stays
- Ability to adhere to the Company’s privacy policy due to the sensitive nature of information handled
Benefits:
- 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
Similar Jobs
Biomedical Data Analyst
Biomedical Data Analyst supporting NIH’s National Library of Medicine. Analyzing PubMed data and MeSH indexing performance to improve biomedical literature search.
VP, Analytics, Data Science & AI Data Enablement
VP leading analytics, data science, and AI enablement for Walker & Dunlop’s commercial real estate finance business. Modernizing BI, predictive modeling, governance, and AI-assisted analysis.
Senior Solution Sales Executive – Data & Analytics – Healthcare
ServiceNow Data & Analytics sales executive selling AI, data, and analytics solutions to healthcare customers. Leading strategic sales cycles, executive discovery, demos, and adoption.
Junior Data Analyst
Analista de Dados Júnior desenvolvendo soluções de BI e dashboards em Power BI para o Grupo Bancorbrás. Apoio a decisões baseadas em dados em turismo, consórcios e seguros.
Manager – Data & Analytics, Banking and Capital Markets
Data and analytics manager guiding banking and capital markets clients through analytics roadmaps, predictive models, and data modernization. CrossCountry Consulting helps CFOs transform finance operations with data, AI, and technology.
Data Analyst
Lead Data Analyst transforming complex claims and survey datasets into insights for Avar Consulting's CMS policy research contract. Applying statistical methods, machine learning, and data visualization.
Senior Data & Analytics Solution Sales Executive – Financial Markets
Senior sales executive selling ServiceNow’s AI, data, and analytics portfolio to financial-market customers. Leading discovery, demos, account strategy, and end-to-end sales cycles.
Working Student: Business Intelligence – Reporting, Data Analytics
Werkstudent:in supporting Qlik Sense BI reporting, dashboards, and data quality. Helping Austrian company teams turn business data into informed decisions.
Client Data & Analytics Lead
Client Data & Analytics Lead helping energy utilities build modern analytics capabilities with Kraken’s AI-driven energy platform. Advising data leaders and shaping client-focused data products.
Analyst / Senior Analyst, Data Quality
Data quality analyst investigating P&C insurance data and building controls. Supporting Ledgebrook’s AI-native specialty insurance platform through reliable reporting and analytics.
Data Analyst II
Data Analyst II managing network capacity dashboards, incidents, and cloud networking issues. Supporting customer capacity planning through monitoring, troubleshooting, documentation, and automation.
Senior Manager, Data Analytics
Senior Data Analytics Manager leading five analysts and data scientists at Babylist. Scaling AI-native analytics across eCommerce, health, and supply chain.
Senior Manager, Data Analytics
Senior Manager leading AI-native analytics across Babylist’s e-commerce, health, and supply chain businesses. Managing analysts while shaping data strategy, KPIs, and self-serve analytics.
AML Business Data Analyst
AML data analyst developing and tuning banking financial crime models for Matrix, a global technology services company. Applying Python, SQL, and machine learning to improve detection systems.
Data & Analytics Manager
Gerente de Dados e Analytics liderando BI, DataOps e equipes globais no maior ecossistema imobiliário da América Latina. Garantia de dados confiáveis e soluções analíticas escaláveis.
Industrial Engineer – Equipment Diagnostics, Sensor Data Analysis
Industrial equipment experts reviewing sensor data and automated diagnostics for Terac, which recruits vetted human experts for AI research. Providing technical feedback during paid remote interviews.
Marketing & Growth Data Analyst
Marketing & Growth Data Analyst optimizing paid marketing, customer funnels, and product growth analytics. Supporting FinTech investment platforms with data-driven budget and product decisions.
Senior Data Analyst, Tableau
Senior Data Analyst using Tableau, SQL, and Python to transform datasets into strategic insights. Supporting Factored’s AI, ML, and data teams serving U.S. companies with LATAM talent.
Deputy Team Lead, Data Analyst
Deputy Team Lead/Data Analyst supporting IBTCI’s independent monitoring of CARE’s Yemen WASH and food-security programs. Analyzing mixed-methods evidence, verifying expenditures, and producing donor-facing learning deliverables remotely.
Data Analyst – Customer Analytics
Data Analyst leading customer analytics, dashboards, and measurement frameworks for Granicus, a GovTech provider serving government agencies. Delivering insights that optimize digital communications and customer outcomes.