• Develop and maintain a variety of dashboards, scorecards, and reporting tools (standard, ongoing, ad-hoc) that deliver real-time insights and data visualization on staffing trends, demand forecasting and operational performance • Manage SimpliFi's survey and evaluation data for all performance and assignment completion evaluations across clients • Develop and implement a data management strategy to ensure data accuracy, accessibility, relevance, and consistency across systems • Develop, maintain, and manage a robust menu of scheduled reporting and analysis to inform business decision-making • Work closely with Operations and Client Strategy to develop analytics tools that align with business objectives; apply industry knowledge to interpret data and improve performance • Develop, implement, and maintain a system for keeping data/reporting SOPs current • Lead and/or participate in data and analytics projects by executing the entire data analytics life cycle (e.g., including meeting with business stakeholder, gathering requirements/discovery, data preparation/cleaning, building reports visualizations, communicating results, operationalization) • Continually explore and implement ways to improve/streamline current data gathering and reporting processes for maximum efficiency and scalability • Serve as an advisory resource for other team members by providing guidance and assistance on data and analytics-related interactions

• Develop and maintain a variety of dashboards, scorecards, and reporting tools (standard, ongoing, ad-hoc) that deliver real-time insights and data visualization on staffing trends, demand forecasting and operational performance • Manage SimpliFi's survey and evaluation data for all performance and assignment completion evaluations across clients • Develop and implement a data management strategy to ensure data accuracy, accessibility, relevance, and consistency across systems • Develop, maintain, and manage a robust menu of scheduled reporting and analysis to inform business decision-making • Work closely with Operations and Client Strategy to develop analytics tools that align with business objectives; apply industry knowledge to interpret data and improve performance • Develop, implement, and maintain a system for keeping data/reporting SOPs current • Lead and/or participate in data and analytics projects by executing the entire data analytics life cycle (e.g., including meeting with business stakeholder, gathering requirements/discovery, data preparation/cleaning, building reports visualizations, communicating results, operationalization) • Continually explore and implement ways to improve/streamline current data gathering and reporting processes for maximum efficiency and scalability • Serve as an advisory resource for other team members by providing guidance and assistance on data and analytics-related interactions

• Translate questions into insight. Partner and embed with cross-functional teams to turn ambiguous business and operational questions into clear, useful analytical outputs. You will quickly assimilate subject matter expertise across brokerage operations, ledger systems, and compliance. • Build and own analytics data models. Write clean, maintainable SQL against PostgreSQL, Trino, and Apache Iceberg to power core financial metrics, dashboards, and analytical workflows. • Build and iterate on metrics and tables. Build and iterate on metrics and tables using dbt, surfacing them through dashboards in Metabase to help teams understand transaction volumes, revenue streams, and system performance over time. • Explore data deeply to answer open-ended questions. Use SQL as your primary tool, with Python in a notebook environment like Jupyter when helpful, to investigate trends, anomalies, complex profit and loss (P&L) calculations, and trading behaviors, connecting analyses back to real business questions. • Help operationalize data. Identify structural opportunities for standardizing core business entities, proactively transitioning ad-hoc analytical requests into intuitive, user-friendly self-serve environments. • Assist with reporting capabilities and streamline report automation, including servicing requests in a timely manner, cataloguing recurring reports, and driving conversations around standardization and productization of data reports.

Role 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. 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. 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. - 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. Requirements - The application window for this position is anticipated to close in 2 weeks (10 business days) from 6/12/2025. - 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. Benefits - Pay Range*: $88,500 - $123,900 annually. - Eligible to receive long-term incentive awards, subject to program guidelines and approvals. - Three (3) Medical plan options, two (2) Dental plan options, and a Vision plan. - Voluntary Critical Illness, Hospital Indemnity, and Accident plans. - Pre-tax savings options including a partially employer funded Health Savings Account and employee Flexible Savings Accounts. - Company paid Basic Life and AD&D, Short and Long-Term Disability benefits. - Voluntary Life and AD&D plans available. - Traditional and Roth 401(k) plans with a discretionary employer match. - Supportlinc for wellbeing, providing access to guided meditation, mental health coaching, and online resources. - LifeBalance for year-round discounts on various services. - Wellness programs including flexible paid vacation, company-paid holidays, paid sick time, paid parental leave, identity theft program, travel assistance, and fitness discounts.