Insurance Data Analyst

This is a fully remote position, open to applicants in Washington.

📋 Description

• Develop and maintain SQL queries within BigQuery and SQL Server to facilitate ongoing analysis and respond to ad hoc business inquiries.

• Create and manage Power BI dashboards that monitor essential insurance KPIs such as quotes, binds, retention, premium, and business mix.

• Conduct descriptive and diagnostic analyses to uncover trends, drivers, and anomalies within the insurance portfolio.

• Assist in evaluating product modifications through cohort analysis, pre/post assessments, and trend evaluations to measure business impact.

• Support competitive intelligence efforts by collecting, organizing, and summarizing competitor information to guide pricing and product strategy.

• Maintain data accuracy and integrity through quality assurance checks, reconciliations, and comprehensive documentation of methodologies and data sources.

• Operate independently on intricate, cross-functional challenges with mid-term (12+ month) consequences, proactively identifying issues and opportunities.

⛳️ Requirements

• Bachelor’s degree in Business, Finance, Economics, Statistics, Actuarial Science, or a related discipline.

• Over 3 years of professional experience, including at least 1 year in personal lines insurance in roles related to data analysis, actuarial science, product analytics, or similar fields.

• Proficient in SQL with practical experience in BigQuery and/or SQL Server.

• Advanced skills in building and managing dashboards and reports using Power BI.

• Excellent Microsoft Office skills, particularly in Excel, with a strong focus on detail.

• Proven ability to tackle complex issues with mid-term or wider cross-functional impacts.

• Self-motivated individual with a history of working independently and proactively addressing problems before they escalate.

• Preferred: Proficiency in Python or R for analytical or automation tasks.

• Familiarity with AI tools to enhance research and analysis efficiency.

🏝️ Benefits

• Long-term incentive awards.

• Three (3) Medical plan options.

• Two (2) Dental plan options.

• Vision plan.

• Voluntary Critical Illness, Hospital Indemnity, and Accident plans.

• Pre-tax Health Savings Account.

• Flexible Spending Accounts, including healthcare, dependent care, and transportation savings options.

• Company-paid Basic Life and AD&D.

• Short and Long-Term Disability benefits.

• Voluntary Life and AD&D plans.

• Traditional and Roth 401(k) plans with discretionary employer match.

• Supportlinc wellbeing program featuring guided meditation and mindfulness exercises.

• LifeBalance resource offering discounts on gym memberships, travel, appliances, etc.

• Flexible paid vacation.

• Company-paid holidays (generally nine per year).

• Paid sick time.

• Paid parental leave.

• Identity theft protection program.

• Travel assistance.

• Fitness and other discount programs.