Insurance Data Analyst, HOA

Overview

Partner with Product Managers and business leaders across Porch's insurance platform to transform complex insurance data into actionable insights that support profitable growth and decisions across pricing, underwriting, retention, and competitive intelligence.

What you'll do

• 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 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.

What you'll need

• 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, exercising wide latitude in determining objectives and approaches.
• Self-starter with a track record of working autonomously and proactively identifying problems before they escalate.
• Proficiency in Python or R for analysis or automation.
• Familiarity using AI tools to accelerate research and analysis.
• Experience working with global and/or US based business teams.
• Excellent written and communication skills in English language.

Details

• Workplace type: Remote.
• Location: India.
• Working hours: 8 hours, excluding breaks.
• 4 core US hours overlap from 7:30pm to 11:30pm IST.
• 4 flexible hours in IST.
• Workspace requires a quiet space to work and an internet connection of at least 30 Mbps download and 10 Mbps upload.