Insurance Data Analyst, HOA

PORCH INDIA PRIVATE LIMITED; India; Remote; INR 694,000 - 971,000; Full time

Benefits offered by this job

Medical insurance

Accident insurance

Retiral benefits

Wellness programs

Job summary

Porch Group is seeking an Insurance Data Analyst in India to write and optimize SQL across BigQuery and SQL Server, build Power BI dashboards, and deliver descriptive analyses of the insurance portfolio. You will support product change measurements using cohorts and pre/post analyses, and assist with competitive intelligence to guide pricing and strategy.

You will contribute to data accuracy through QA checks, documentation, and cross‑functional collaboration, working autonomously on mid‑term

Qualifications

• Bachelor's degree in Business, Finance, Economics, Statistics, Actuarial Science, or a related field.

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 (12+ month) implications, proactively identifying problems and opportunities.

Skills

SQL

Power BI

Excel

Python

R

English

Autonomous work

AI tools

Education

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

Tools

BigQuery

SQL Server

Job description

Job Summary

Porch Group is a leading vertical software and insurance platform and is positioned to be the best partner to help homebuyers move, maintain, and fully protect their homes. We offer differentiated products and services, with homeowners insurance at the center of this relationship. We differentiate and look to win in the massive and growing homeowners insurance opportunity by: 1) providing the best services for homebuyers 2) being led by advantaged underwriting in insurance 3) protecting the whole home. As a leader in the home services software-as-a-service ("SaaS") space, we’ve built deep relationships with approximately 30 thousand companies that are key to the home-buying transaction, such as home inspectors, mortgage companies, and title companies. In 2020, Porch Group rang the Nasdaq bell and began trading under the ticker symbol PRCH. We are looking to build a truly great company and are JUST GETTING STARTED.

Job Details

• Job Title: Insurance Data Analyst
• Location: India
• Workplace Type: Remote

What You Will 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 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

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

What You Will Get

• Pay Range: 693,800 - 971,300 INR annually
• 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.

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

Application Deadline

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.

Porch is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable laws, regulations, and ordinances.

Porch is committed to building an inclusive culture of belonging that not only embraces the diversity of our people but also reflects the diversity of the communities in which we work and the customers we serve. We know that the happiest and highest performing teams include people with diverse perspectives that encourage new ways of solving problems, so we strive to attract and develop talent from all backgrounds and create workplaces where everyone feels seen, heard and empowered to bring their full, authentic selves to work.

Values

• No Jerks / No Egos
• Be Ambitious
• Solve Each Problem
• Care Deeply
• Together We Win

At Porch Group, we're committed to an inclusive work culture where everyone is respected. We trust our team members with significant responsibilities, which creates true ownership opportunities and meaningful contributions. This culture of empowerment and accountability drives individual personal growth and our overall company's success!