Logo for Porch Group

Insurance Data Analyst, HOA

Role overview

Qualifications

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

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.

Key facts

Other skills

  • Communication
  • Detail Oriented
  • Problem Solving

About the company

Porch Group logo

Porch Group

Insurance

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. Join the team at https://porchgroup.com/careers

Company details

Company typeLarge
IndustryInsurance
Company size1001 - 5000

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Data Analyst Related jobs

Other jobs at Porch Group

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.