[Remote] Product Analyst

Note: The job is a remote job and is open to candidates in USA. Traders Insurance Company is a reliable and local company providing full-time remote job opportunities. The Product Analyst I supports the Product Manager and other leadership by completing tasks and projects that involve quantitative analysis and data tools, playing a crucial role in driving success within the organization.

Responsibilities

• 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
• Ad hoc analysis and miscellaneous support of the products and product managers

Skills

• Bachelor's degree required
• Quantitative discipline (math, physics, finance, economics) highly desired
• Bachelor's degree requirement could be replaced by five-plus years of demonstrated extremely high-quality and relevant experience working with rating applications, IT business requirements, user acceptance testing, operational quality assurance or policy forms and filings
• 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
• Proficiency with SQL Server Management Studio, Cloverleaf, Power BI, VBA, or Snowflake are desired
• User-level proficiency with internal Business Intelligence or Management Information applications
• Power BI and Python knowledge and experience
• 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

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

Company Overview