Insurance Data Analyst

PORCH 💚

. Partner with Product Managers and business leaders across Porch's insurance platform to transform complex insurance data into actionable insights .

Posted 10/6/2026full-timeRemote • IndiaMid-LevelSenior💰 ₹693,800 - ₹971,300 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL, Power BI, and data analysis within the insurance sector, focusing on actionable insights and data integrity. Proven ability to work autonomously on complex issues while collaborating with cross-functional teams to drive strategic decisions.

Highest-signal resume keywords

SQL ExpertisePower BI Dashboard DevelopmentData Analysis in InsurancePython or R ProficiencyStrong Communication Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLBigQuerySQL ServerPower BIData AnalysisDescriptive AnalysisDiagnostic AnalysisCohort AnalysisTrend AnalysisData Quality Assurance

Soft Skills

Self-StarterProactive Problem IdentificationAutonomous WorkCollaborationCommunication

Tools & Technologies

Microsoft OfficeExcelAI Tools

Industry Keywords

InsurancePersonal Lines InsuranceProduct AnalyticsActuarial ScienceBusiness Strategy

Tech Stack

Tools & technologies

BigQueryPythonSQL

About the role

Key responsibilities & impact

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

Requirements

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

Benefits

Comp & perks

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