Insurance Data Analyst

Job Title: Insurance Data Analyst Location: United States (Remote) About the Job The role involves partnering with product managers and business leaders to transform complex insurance data into actionable insights that drive profitable growth. Responsibilities include writing and maintaining SQL queries, building and maintaining Power BI dashboards, performing descriptive and diagnostic analyses, and ensuring data accuracy and integrity. Responsibilities 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. Qualifications Bachelor’s degree in Business, Finance, Economics, Statistics, Actuarial Science, or 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, exercising wide latitude in determining objectives and approaches. Self‑starter with a track record of working autonomously and proactively identifying problems before they escalate. Preferred Skills Proficiency in Python or R for analysis or automation. Familiarity using AI tools to accelerate research and analysis. Eligibility Position available to applicants residing in the United States (Remote) except the following states: Alabama, Alaska, Arkansas, Colorado, Connecticut, Delaware, District of Columbia, Hawaii, Maryland, Mississippi, Montana, Nebraska, Nevada, NewHampshire, NorthDakota, Utah, Vermont, Virginia, WestVirginia, Wyoming. Pay Range $88,500 – $123,900 annually (actual pay depends on experience, skills, and location). Benefits Eligibility for long‑term incentive awards subject to program guidelines and approvals. Three medical plan options, two dental plan options, and a vision plan. Critical Illness, Hospital Indemnity, and Accident plans available on a voluntary basis. Pre‑tax savings options including a partially employer‑funded Health Savings Account and employee Flexible Savings Accounts for healthcare, dependent care, and transportation savings. Company‑paid Basic Life and AD&D, Short and Long‑Term Disability benefits; voluntary Life and AD&D plans available. Traditional and Roth 401(k) plans with discretionary employer match. Well‑being program access to guided meditation, mental health coaching, and confidential resources. Flexible paid vacation, company‑paid holidays (typically nine per year), paid sick time, paid parental leave, identity theft program, travel assistance, and fitness and discount programs. Equal Opportunity Employer Porch is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable laws, regulations, and ordinances. Porch Group is an E-Verify employer. E-Verify is a web-based system that allows an employer to determine an employee's eligibility to work in the United States using information reported on an employee's Form I‑9. The E-Verify system confirms eligibility with both the Social Security Administration (SSA) and Department of Homeland Security (DHS). For more information, please go to the USCIS E‑Verify website. #J-18808-Ljbffr Porch.com, Inc.