Product Analyst

Traders Insurance Company is a reliable, local company providing full-time remote job opportunities. The Product Analyst I supports the Product Manager and other leadership by completing various tasks and projects, including data analysis and comparative studies to drive product success.

What you'll do:

• Obtaining data and reports from policy and claims systems using menu-based reporting tools or previously prepared reports. Using SQL or other query language to develop ad hoc reports
• Organizing and processing data and reports into pre-determined formats for use by managers
• Obtaining competitor rate filings and extracting relevant competitor information to perform comparative analyses
• Use comparative rating tools to obtain competitor rates and perform rate comparisons and organize comparisons into market baskets or other pre-determined formats for use by managers
• Completing template-based analyses, such as monthly reports, rate level indications or rating factor analyses, by populating inputs in prepared templates
• Obtaining and comparing competitor policy forms as directed
• Creating business requirements for IT revisions
• Researching operational problems related to products (rating errors, etc.)
• Editing rule manuals with updates and revisions as directed
• Describing or researching business processes (policy issuance, renewal, invoice, cancellation, quoting, etc.) to document workflow, identify gaps and redundancies, evaluate data quality, and relate process to product components
• Preparing and submitting SERFF (NAIC System for Electronic Rate and Form Filing) filings
• Executing User Acceptance Testing of product-related IT revisions

What they're looking for:

• Bachelor's degree required
• Minimum 1 year as an assistant product analyst or equivalent in a P&C insurance environment or 2 years as a quantitative analyst in an industry other than insurance or 3 years of progressively increasing experience in an operational role with the company
• Proficiency with MS Excel (lookups, complex formulae, if/then/else logic, data scrubbing), Word, PowerPoint
• Understanding of pricing and segmentation theory, include rate adequacy, adverse selection, pure premium relativity, and eligibility
• Profound understanding of rating calculation formulae, rating variables and factor tables
• Profound understanding of internal templates or documents specifying business requirements for rating, eligibility, billing and other product characteristics
• Working knowledge of comparative rater processes, from both agency and company perspective, and familiarity with data available for rate comparisons or competitive analysis
• Awareness of key competitors
• Strong analytical and quantitative aptitude
• Attention to detail
• Ability to work independently to complete assigned tasks and projects
• Proficiency with SQL Server Management Studio, Cloverleaf, Power BI, VBA, or Snowflake are desired

Benefits:

• Group Medical/Dental/Vision
• Pet Insurance
• Employee and Dependent Life Insurance
• Paid Time Off
• 401K Plan
• Parental Leave
• Training and Career Development
• Opportunities for Advancement