[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.ResponsibilitiesObtaining 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 reportsOrganizing and processing data and reports into pre-determined formats for use by managersObtaining competitor rate filings and extracting relevant competitor information to perform comparative analysesUse 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 managersCompleting template-based analyses, such as monthly reports, rate level indications or rating factor analyses, by populating inputs in prepared templatesObtaining and comparing competitor policy forms as directedCreating business requirements for IT revisionsResearching operational problems related to products (rating errors, etc.)Editing rule manuals with updates and revisions as directedDescribing 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 componentsPreparing and submitting SERFF (NAIC System for Electronic Rate and Form Filing) filingsExecuting User Acceptance Testing of product-related IT revisionsAd hoc analysis and miscellaneous support of the products and product managersSkillsBachelor's degree requiredQuantitative discipline (math, physics, finance, economics) highly desiredBachelor'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 filingsMinimum 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 companyProficiency with MS Excel (lookups, complex formulae, if/then/else logic, data scrubbing), Word, PowerPointProficiency with SQL Server Management Studio, Cloverleaf, Power BI, VBA, or Snowflake are desiredUser-level proficiency with internal Business Intelligence or Management Information applicationsPower BI and Python knowledge and experienceUnderstanding of pricing and segmentation theory, include rate adequacy, adverse selection, pure premium relativity, and eligibilityProfound understanding of rating calculation formulae, rating variables and factor tablesProfound understanding of internal templates or documents specifying business requirements for rating, eligibility, billing and other product characteristicsWorking knowledge of comparative rater processes, from both agency and company perspective, and familiarity with data available for rate comparisons or competitive analysisAwareness of key competitorsStrong analytical and quantitative aptitudeAttention to detailAbility to work independently to complete assigned tasks and projectsBenefitsGroup Medical/Dental/VisionPet InsuranceEmployee and Dependent Life InsurancePaid Time Off401K PlanParental LeaveTraining and Career DevelopmentOpportunities for AdvancementCompany OverviewWelcome to Traders Insurance! We are an insurance company proudly based in Kansas City, MO. Our primary focus is auto insurance. It was founded in 1976, and is headquartered in Kansas City, Missouri, USA, with a workforce of 51-200 employees. Its website is https://tradersauto.com/.