Insurance Data Analyst

Job not on LinkedIn

🕒 July 16

☕ Washington – Remote

☕ Washington – Remote

💵 $88.5k - $123.9k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📉 Data Analyst

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

PORCH 💚

WebsiteLinkedInAll Job Openings

1 - 10 employees

Founded 2022

💼 Consulting

🏥 Healthcare

🏨 Hospitality

Consulting • Healthcare • Hospitality

PORCH 💚 is a next-generation insurance company that provides comprehensive software and services to various home service industries. It streamlines interactions for home professionals, utility customers, realtors, and homeowners by offering tools for inspections, moving, mortgage processes, and home maintenance. Through its partnerships, Porch enhances the home buying experience by simplifying service requests, onboarding new customers for warranty and insurance companies, and assisting with home improvement projects.

📋 Description

• Write and maintain SQL queries across BigQuery and SQL Server to support recurring analysis and ad hoc business requests • Build and maintain Power BI dashboards tracking key insurance KPIs including quotes, binds, retention, premium, and business mix • Perform descriptive and diagnostic analyses to identify trends, drivers, and anomalies across the insurance portfolio • Support measurement of product changes using cohorts, pre/post analysis, and trend analysis to quantify business impact • Assist with competitive intelligence by gathering, organizing, and summarizing competitor data to inform pricing and product strategy • Ensure data accuracy and integrity through QA checks, reconciliations, and thorough documentation of methodology and sources • Work autonomously on complex, cross-functional issues with mid-term (12+ month) implications, proactively identifying problems and opportunities

🎯 Requirements

• Bachelor’s degree in Business, Finance, Economics, Statistics, Actuarial Science, or a related field • 3+ years of professional experience, including 1+ years in personal lines insurance in data analysis, actuarial, product analytics, or related roles • Strong SQL skills with hands-on experience in BigQuery and/or SQL Server • Advanced experience building and maintaining dashboards and reports in Power BI • Exceptional Microsoft Office skills, especially Excel, with strong attention to detail • Demonstrated ability to work on complex issues with mid-term or broader cross-functional implications • Self-starter with a track record of working autonomously and proactively identifying problems before they escalate • Preferred: Proficiency in Python or R for analysis or automation • Familiarity using AI tools to accelerate research and analysis

🏖️ 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 with guided meditation and mindfulness exercises • LifeBalance resource for discounts on gym memberships, travel, appliances, etc. • Flexible paid vacation • Company-paid holidays (typically nine per year) • Paid sick time • Paid parental leave • Identity theft program • Travel assistance • Fitness and other discounts programs