[Remote] Insurance Data Analyst

Note: The job is a remote job and is open to candidates in USA. Porch Group is a leading vertical software and insurance platform, aiming to be the best partner for homebuyers. They are seeking an Insurance Data Analyst to transform complex insurance data into actionable insights that drive profitable growth, supporting key decisions across pricing, underwriting, and retention.ResponsibilitiesWrite and maintain SQL queries across BigQuery and SQL Server to support recurring analysis and ad hoc business requestsBuild and maintain Power BI dashboards tracking key insurance KPIs including quotes, binds, retention, premium, and business mixPerform descriptive and diagnostic analyses to identify trends, drivers, and anomalies across the insurance portfolioSupport measurement of product changes using cohorts, pre/post analysis, and trend analysis to quantify business impactAssist with competitive intelligence by gathering, organizing, and summarizing competitor data to inform pricing and product strategyEnsure data accuracy and integrity through QA checks, reconciliations, and thorough documentation of methodology and sourcesWork autonomously on complex, cross-functional issues with mid-term (12+ month) implications, proactively identifying problems and opportunitiesSkillsBachelor's degree in Business, Finance, Economics, Statistics, Actuarial Science, or a related field3+ years of professional experience, including 1+ years in personal lines insurance in data analysis, actuarial, product analytics, or related rolesStrong SQL skills with hands-on experience in BigQuery and/or SQL ServerAdvanced experience building and maintaining dashboards and reports in Power BIExceptional Microsoft Office skills, especially Excel, with strong attention to detailDemonstrated ability to work on complex issues with mid-term or broader cross-functional implications, exercising wide latitude in determining objectives and approachesSelf-starter with a track record of working autonomously and proactively identifying problems before they escalateProficiency in Python or R for analysis or automationFamiliarity using AI tools to accelerate research and analysisBenefitsAdditionally, you will be eligible to receive long-term incentive awards, subject to program guidelines and approvals.Our traditional healthcare benefits include three (3) Medical plan options, two (2) Dental plan options, and a Vision plan from which to choose.Critical Illness, Hospital Indemnity and Accident plans are offered on a voluntary basis.We offer pre-tax savings options including a partially employer funded Health Savings Account and employee Flexible Savings Accounts including healthcare, dependent care, and transportation savings options.We provide company paid Basic Life and AD&D, Short and Long-Term Disability benefits. We also offer Voluntary Life and AD&D plans.Both traditional and Roth 401(k) plans are available with a discretionary employer match.Supportlinc is part of our employer paid wellbeing program and provides employees and their families access to on demand guided meditation and mindfulness exercises, mental health coaching, clinical care and online access to confidential resources including will preparation.LifeBalance is a free resource to employees and their families for year-round discounts on things like gym memberships, travel, appliances, movies, pet insurance and more.Our wellness programs include flexible paid vacation, company-paid holidays of typically nine per year, paid sick time, paid parental leave, identity theft program, travel assistance, and fitness and other discounts programs.Company OverviewPorch Group is a vertical software platform for residential environments. It was founded in 2013, and is headquartered in Seattle, Washington, USA, with a workforce of 1001-5000 employees. Its website is https://www.porchgroup.com.