Insurance Data Analyst

• Partner with Product Managers and business leaders across Porch's insurance platform to transform complex insurance data into actionable insights
• Support decisions across pricing, underwriting, retention, and competitive intelligence
• Write and maintain SQL queries across BigQuery and SQL Server for recurring analysis and ad hoc business requests
• Build and maintain Power BI dashboards tracking quotes, binds, retention, premium, and business mix
• Perform descriptive and diagnostic analyses to identify trends, drivers, and anomalies across the insurance portfolio
• Measure product changes using cohorts, pre/post analysis, and trend analysis to quantify business impact
• Gather, organize, and summarize competitor data to inform pricing and product strategy
• Ensure data accuracy and integrity through QA checks, reconciliations, and documentation of methodology and sources
• Work autonomously on complex, cross-functional issues with mid-term 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
• Advanced experience building and maintaining dashboards and reports in Power BI
• Exceptional Microsoft Office skills, especially Excel
• 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
• Ability to work 8 hours excluding breaks, with 4 core US hours overlap from 7:30pm–11:30pm IST and 4 flexible hours
• Quiet workspace and internet connection of at least 30 Mbps download and 10 Mbps upload

• Medical insurance
• Accident insurance
• Retiral benefits
• 12 company-paid holidays
• 2 flexible holidays
• Privilege/earned leave
• Casual/sick leave
• Paid maternity and paternity leaves
• Weekly wellness events
• Virtual interviews as part of the hiring process