Insurance Program Analyst

The Insurance Program Analyst is the operational and analytical owner of the company’s insurance and warranty products (GAP, VSI, VSC). This role ensures financial integrity through meticulous reconciliation, drives program profitability via trend analysis, and maintains seamless data flow between internal systems and third-party vendors. The Analyst is also responsible for scaling these programs through process automation and process improvements.

1. Policy Sales Processing: Manage weekly process of preparing and uploading files to vendor site
and sync with internal Accounting department.
2. Loss Development Triangles: Analyze loss and premium data to prepare monthly loss
development trends.
3. Tracking & Insurance Coverage: Prepare and upload weekly insurance coverage information to
insurance tracking vendor.
4. Invoice Reconciliation: Verify monthly vendor invoices against portfolio size; manage payment
approvals.
5. Special Project: Lead operational initiatives for vendor transitions or portfolio migrations.

2. VSI (Vendor Single Interest)
1. Program Performance: Develop monthly loss development results and call out data trends
regarding surplus/deficit projections.
2. Premium Management: Calculate accurate premium payments across multiple insurance
channels.
3. Audit & Reporting: Monthly audit of claim payments to ensure accuracy and reporting
consistency.
4. Primary Insurance Trends: Analyze total loss payback trends; flag low-performing cohorts to
management.

3. VSC (Vehicle Service Contract)
1. Cancellation Management: Confirm cancellation funds and amounts for processing and reconcile
with operational specialists.
2. Billing & Reconciliations: Perform VIN-level audits for vendor results.
3. Issue Resolution: Resolve rejected sales/VIN coverage issues with Sales and vendor teams.
4. Vendor Onboarding: Manage operational data setup for any new VSC product launches.

4. Dealer & Portfolio Strategy
1. Dealer Performance Audits: Conduct deep-dives into "Dealer Bands" to identify high-loss retailers
and recommend pricing or product adjustments.
2. Profitability Modeling: Move beyond basic loss development triangles to model the long-term ROI
of each insurance product line.
3. Market Benchmarking: Periodically review competitor program structures to ensure our VSC/GAP
offerings remain competitive.

5. Compliance, Documentation & Systems
1. Standard Operating Procedures (SOPs): Create and maintain a comprehensive "Insurance
Operations Manual" for all tasks (IQQ, Sigma, Allied FTP, etc).
2. Reporting Automation: Partner with the Data/IT team to automate manual spreadsheet tasks into
Salesforce or Sigma dashboards.