Insurance Data Analyst, HOA

Porch Group; India; Remote; INR 694,000 - 971,000; Full time

Benefits offered by this job

Health insurance

Life insurance

Paid holidays

Wellness programs

Job summary

Porch Group in India is seeking an Insurance Data Analyst to transform insurance data into actionable insights for pricing, underwriting, retention and competitive intelligence. You will work with BigQuery, SQL Server and Power BI to build dashboards and analytics used by product managers and leaders across the insurance platform.

The role requires 3+ years of experience, strong SQL, Power BI and Excel skills, plus proficiency in Python or R.

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.
• Excellent Excel skills with attention to detail.
• Proficiency in Python or R for analysis or automation.
• Familiarity with AI tools to accelerate research and analysis.
• Experience working with global and/or US based business teams.
• Excellent written and communication skills in English.

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 implications, proactively identifying problems and opportunities.

Skills

SQL

BigQuery

Power BI

Excel

Python

R

English communication

Autonomous/Self-starter

Education

Bachelor's degree in Business/Finance/Economics/Statistics/Actuarial Science or related field

Tools

SQL Server

Power BI Desktop

AI tooling familiarity

Job description

**Job Summary** The future is bright for the Porch Group, and we'd love for you to be a part of it as our **Insurance Data Analyst.**In this role, you will partner directly with Product Managers and business leaders across Porch's insurance platform to transform complex insurance data into actionable insights that drive profitable growth. You will support critical decisions across pricing, underwriting, retention, and competitive intelligence, areas that sit at the very core of how Porch wins in the homeowners insurance market.Your work will span BigQuery, SQL Server, and Power BI, building the analytical infrastructure and dashboards that keep key stakeholders informed and ahead of the curve. 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. **What You Will Do As An Insurance Data Analyst** * 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. **What You Will Bring As An Insurance Data Analyst** * 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* Working Hours: 8 Hours (Excluding breaks) 4 Core US Hours Overlap (7:30pm - 11:30pm IST) 4 flexible hours (IST)* Workspace: A quiet space to work, an internet connection of at least 30 Mbps download | 10 Mbps upload*The application window for this position is anticipated to close in 2 weeks (10 business days) from 10/05/26. Please know this may change based on business and interviewing needs.* **What You Will Get As A Porch Group Team Member** **Pay Range\\*:** 693,800 - 971,300 INR annually*\\*Please know your actual pay at Porch will reflect a number of factors among which are your work experience and skillsets, job-related knowledge, alignment with market and our Porch employees, as well as your geographic location.* * Our benefits package will provide you with comprehensive coverage for your health, life, and financial well-being.* Our benefits include medical insurance, accident insurance and retiral benefits.* Our wellness programs include 12 company-paid holidays, 2 flexible holidays, privilege/earned leave, casual/sick leave, paid maternity and paternity Leaves, and weekly wellness events.