Property Underwriting & Programs Analyst

Vantage Risk Companies•Chicago, IL

10h•$80,000 - $100,000•Remote

About The Position

At Vantage, the Property Underwriting & Programs Analyst provides the technical and operational backbone for our property underwriting teams. You will support the health of our property programs by managing data flows, performing reviews, and building the reporting tools necessary to UW and track risk adequacy and portfolio concentration. This person will also support our product and portfolio manager in UA tasks for property submissions and delegated underwriting authority referrals. This role reports to our VP, Product Underwriting - Property and is a remote opportunity for the appropriate candidate.

Requirements

Bachelor’s Degree preferred or equivalent professional experience.
1-3 years of Property Insurance experience in underwriting and/or product/program management support roles.
Proficient in SQL or Snowflake for data extraction and expert-level Excel (Power Pivot/DAX) for program reporting.
Practical experience building and troubleshooting dashboards in Power BI or Tableau.
Proven ability to validate financial data and ensure alignment between underwriting standards and reporting.
Ability to process and adapt to change in a rapid growth new-company environment. Vantage associates are expected to be curious, thrifty, and resourceful to manage through the unknowns of growing a specialty (re)insurance business from the ground up.

Responsibilities

Property Underwriting: Support property underwriting needs in an Underwriting Analyst capacity, reviewing and underwriting property referrals, updating and reviewing guideline changes, and working with internal teams to build/improve referral process and analytics.
Program Support: Coordinate the lifecycle of assigned property programs, assist with monthly premium estimates, prepare meeting materials, stakeholder follow-ups, and the Underwriting Financial Review process.
Underwriting Analytics: Build new and maintain dashboards to help underwriters and program manager track production, quote-to-bind ratios, TIV concentrations, and CAT aggregation.
Audit & Compliance: Prepare automated data extracts for regulatory filings and support bi-annual program audits as well as financial quarterly external audits for program partners.
Operational Execution: Route program inquiries efficiently and conduct UAT for new product launches to ensure system logic aligns with underwriting standards. Perform regular internal review of program exposure data against guidelines to ensure compliance.