Insurance Program Analyst

Key Responsibilities (Monthly Allocation) GAP & Insurance Tracking Policy Sales Processing: Manage weekly process of preparing and uploading files to vendor site and sync with internal Accounting department. Loss Development Triangles: Analyze loss and premium data to prepare monthly loss development trends. Tracking & Insurance Coverage: Prepare and upload weekly insurance coverage information to insurance tracking vendor. Invoice Reconciliation: Verify monthly vendor invoices against portfolio size; manage payment approvals. Special Project: Lead operational initiatives for vendor transitions or portfolio migrations. VSI (Vendor Single Interest) Program Performance: Develop monthly loss development results and call out data trends regarding surplus/deficit projections. Premium Management: Calculate accurate premium payments across multiple insurance channels. Audit & Reporting: Monthly audit of claim payments to ensure accuracy and reporting consistency. Primary Insurance Trends: Analyze total loss payback trends; flag low-performing cohorts to management. VSC (Vehicle Service Contract) Cancellation Management: Confirm cancellation funds and amounts for processing and reconcile with operational specialists. Billing & Reconciliations: Perform VIN-level audits for vendor results. Issue Resolution: Resolve rejected sales/VIN coverage issues with Sales and vendor teams. Vendor Onboarding: Manage operational data setup for any new VSC product launches. Dealer & Portfolio Strategy Dealer Performance Audits: Conduct deep-dives into "Dealer Bands" to identify high-loss retailers and recommend pricing or product adjustments. Profitability Modeling: Move beyond basic loss development triangles to model the long-term ROI of each insurance product line. Market Benchmarking: Periodically review competitor program structures to ensure our VSC/GAP offerings remain competitive. Compliance, Documentation & Systems Standard Operating Procedures (SOPs): Create and maintain a comprehensive "Insurance Operations Manual" for all tasks (IQQ, Sigma, Allied FTP, etc). Reporting Automation: Partner with the Data/IT team to automate manual spreadsheet tasks into Salesforce or Sigma dashboards. Key Requirements Financial Literacy: Deep understanding of insurance accounting (accruals, loss ratios, and premium disbursements). Analytical Rigor: Ability to turn raw data triangles into executive-level narratives and business recommendations. Advanced Data Proficiency: High-level Excel and Salesforce. $60,000 - $80,000 a year #J-18808-Ljbffr Lendbuzz Inc.