> Markdown version of [/jobs/ext/539334-insurance-data-analyst](https://www.wearedevelopers.com/jobs/ext/539334-insurance-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Insurance Data Analyst - **Company:** Porch - **Location:** Seattle, WA, United States (Remote available) - **Salary:** $88,500.0 - $123,900.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, BigQuery, Database Queries, Python (Programming Language), Microsoft Office, Microsoft SQL Server, Power BI, Software Tools, SQL Databases, Usage Analysis - **Published:** June 14, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=dab2a9e09f553d7f ## About the Role * 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. Preferred * Proficiency in Python or R for analysis or automation. * Familiarity using AI tools to accelerate research and analysis. ## Description The 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., * 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. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)