Porch Group
Insurance Data Analyst
US WA Remote - Non Seattle, USA · Mid
Sponsorship not specified$89k-$124kDetected 28 days ago
PythonSQLBigQueryData AnalysisData VisualizationStatisticsExcelRecruitingPatient CareResearchMentoringMicrosoft OfficeActuarial ScienceUnderwriting
About the role
- We differentiate and look to win in the massive and growing homeowners insurance opportunity by 1) providing the best services for homebuyers, 2) led by advantaged underwriting in insurance, 3) to protect the whole home.
- In 2020, Porch Group rang the Nasdaq bell and began trading under the ticker symbol PRCH.
- If you thrive on solving ambiguous problems autonomously, communicating findings with clarity, and making a measurable impact on a fast-growing insurance business, this is the role for you.
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.
- Advanced experience building and maintaining dashboards and reports in Power BI.
Nice to have
- 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.
- 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.
- 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.
Compensation
- Pay Range*: $88,500 - $123,900 annually
Benefits
- Our traditional healthcare benefits include three (3) Medical plan options, two (2) Dental plan options, and a Vision plan from which to choose.
- 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.
- 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.
Apply directly at Porch Group →Create a free account for alerts like thisView Porch Group immigration profile
This listing is sourced directly from Porch Group's careers page and normalized into a canonical job model.