Hiring.Camp

Insurance Data Analyst, HOA

Porch

·

Today

Location
CO Remote, Colombia
Workplace
Remote
Type
Full-time
Department
Insurance
Experience
3+ years
Source
Workday

Description

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) led by advantaged underwriting in insurance

3) to protect 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 Title: Insurance Data Analyst

Location: Colombia 

Workplace Type: Remote  

  

This role is employed through RemoFirst, Porch Group's Employer of Record partner in Colombia. Your employment will be legally administered through RemoFirst, while your day-to-day work is led by Porch Group.

 
 Job Summary 

The future is bright for the Porch Group, and we’d love you to be a part of it as a 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  

  • 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 08/27/26. Please know this may change based on business and interviewing needs. 

 

What You Will Get Supporting Porch Group 

Pay Range: COP 8,500,000.00 to COP 9,500,000.00 salary per month

 

#LI-FQ1  

#LI-Remote

What’s next?

Submit your application below and our Talent Acquisition team will be reviewing your application shortly! If your resume gets us intrigued, we will look to connect with you for a chat to learn more about your background, and then possibly invite you to have virtual interviews. What's important to call out is that we want to make sure not only that you're the right person for us, but also that we're the right next step for you, so come prepared with all the questions you have!

Skills

PythonSQLSQL ServerBigQueryExcelPower BIUnderwriting

Similar Jobs

30

Analyst, Insurance

AIA Careers · MM-Yangon (Junction City), Myanmar

2 days ago

Insurance Analyst

Delivery Hero · Buenos Aires, Argentina · Hybrid

2 days ago

Insurance Analyst

Suffolk Jobs Direct · United Kingdom, GB · Hybrid

1 week ago

Insurance Analyst

NielsenIQ · Warsaw, 30, Poland

1 week ago

Analyst, Insurance

AIA Careers · MM-Yangon (Junction City), Myanmar

3 weeks ago

Analyst, Insurance

AIA Careers · MM-Taunggyi (AYA Banks), Myanmar

4 weeks ago

Insurance Analyst

Berkadia · Ambler, Pennsylvania, United States · Hybrid

1 month ago

Insurance Analyst

BWE is · Remote, Ohio, United States of America +1 · Remote

1 month ago

Insurance Analyst

IKO is · Toronto - Yorkdale, Canada

1 month ago

Insurance Business Analyst

N Consulting Ltd · London, England, London, United Kingdom · Hybrid

3 months ago

Business Analyst - Insurance

BIP · Munich, Bayern, Germany, DE

6 months ago

Analyst, Insurance

AIA Careers · MM-Junction City Tower, Myanmar

11 months ago

Business Analyst - Insurance

Capco · Italy - Milan +1

1+ year ago

Business Analyst (Insurance)

Sequoiaconnect · Remote

1+ year ago

Insurance Service Analyst II - Commercial Lines

Nationwide Careers · Iowa-Work from Home-2, United States of America +1 · Remote

Today

Analyst- Insurance Operations

Mmc · Bogota - Calle 26, Colombia · Hybrid

Yesterday

INSURANCE RATE & POLICY ANALYST III - DOWNTOWN, OAHU

State of Hawai'i, Executive Branch · Island of Oahu, HI, US

Yesterday

Life Insurance - IT Analyst III

Pekin Insurance Careers · Pekin, IL

Yesterday

Senior Insurance Contract & QA Analyst

Branchinsurance · Branch HQ · Remote

2 days ago

Account Analyst, Business Insurance Property & Casualty

Mmc · Melville - Whitman, United States of America · Hybrid

2 days ago

Case Design Life Insurance Illustrations Analyst

Pacificlife · Newport Beach CA-700, United States of America +1 · Onsite

3 days ago

2027 Insurance, Winter Business and Data Analyst (4-16 months)

Rbc · MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA, Canada +1

3 days ago

Analyst - Sandy Grant Management & Insurance

NYC Department of City Planning · New York, NY, United States

5 days ago

Sr. Analyst, Product Development - Personal Insurance Auto

Travelers · Hartford - Tower, United States of America · Hybrid

1 week ago

2027 Blackstone Credit and Insurance, Quant and Portfolio Analytics Analyst (London)

Blackstone · Berkeley Square House London, United Kingdom

1 week ago

Quantitative Insurance Solutions Analyst

Franklintempleton · POL-PZ1B-Poznan, Poland

1 week ago

2027 Blackstone Credit and Insurance, Private Credit Strategies Summer Analyst (London)

Blackstone · London, United Kingdom

1 week ago

Senior P&C Insurance Regulatory Reporting Business Analyst

Verisk Careers | Verisk · Jersey City, NJ, United States, US · Hybrid

1 week ago

Analyst- Insurance Operations

Mmc · Bogota - Calle 26, Colombia · Hybrid

1 week ago

Commercial Underwriting Analyst - Fremont Insurance

AAA The Auto Club Careers · MI-Fremont Insurance, United States of America +1 · Remote

1 week ago