Insurance Data Analyst

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 AnalystLocation: United StatesWorkplace Type: RemoteAbout the JobThe 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 AnalystWrite 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 AnalystBachelor’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.PreferredProficiency in Python or R for analysis or automation.Familiarity using AI tools to accelerate research and analysis.The application window for this position is anticipated to close in 2 weeks (10 business days) from 6/12/2025. Please know this may change based on business and interviewing needs.At this time, Homeowners of America does not consider applicants from the following states or jurisdictions for Remote positions: Alabama, Alaska, Arkansas, Colorado, Connecticut, Delaware, the District of Columbia, Hawaii, Maryland, Mississippi, Montana, Nebraska, Nevada, New Hampshire, North Dakota, Utah, Vermont, Virginia, West Virginia, or Wyoming.What You Will Get As A Porch Group Team MemberPay Range*: $88,500 - $123,900 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.Additionally, you will be eligible to receive long-term incentive awards, subject to program guidelines and approvals.Our traditional healthcare benefits include three (3) Medical plan options, two (2) Dental plan options, and a Vision plan from which to choose.Critical Illness, Hospital Indemnity and Accident plans are offered on a voluntary basis.We offer pre-tax savings options including a partially employer funded Health Savings Account and employee Flexible Savings Accounts including healthcare, dependent care, and transportation savings options.We provide company paid Basic Life and AD&D, Short and Long-Term Disability benefits. We also offer Voluntary Life and AD&D plans.Both traditional and Roth 401(k) plans are available with a discretionary employer match.Supportlinc is part of our employer paid wellbeing program and provides employees and their families access to on demand guided meditation and mindfulness exercises, mental health coaching, clinical care and online access to confidential resources including will preparation.LifeBalance is a free resource to employees and their families for year-round discounts on things like gym memberships, travel, appliances, movies, pet insurance and more.Our wellness programs include flexible paid vacation, company-paid holidays of typically nine per year, paid sick time, paid parental leave, identity theft program, travel assistance, and fitness and other discounts programs.#LI-NH1What’s next?Submit your application and our Porch Group 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!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.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 Group is an E-Verify employer. E-Verify is a web-based system that allows an employer to determine an employee's eligibility to work in the US using information reported on an employee's Form I-9. The E-Verify system confirms eligibility with both the Social Security Administration (SSA) and Department of Homeland Security (DHS). For more information, please go to the USCIS E-Verify website.SummaryLocation: US WA Remote - Non SeattleType: Full time