Product Analyst (Remote)
Description Reliable, Local Company, Providing Full-Time Remote Job Opportunities – While this role is fully remote, candidates must be located in the Kansas City metro area. The Product Analyst I supports the Product Manager, as well as other leadership and executives across other functional areas, by completing tasks and projects. Projects may be detailed and occasionally repetitive, requiring strong attention to detail and consistency. Some assignments will involve quantitative analysis, logical problem-solving, and the use of computer application and data tools. In this role, you’ll play an integral role in driving success, being a part of a passionate team, working directly from the comfort of your own home. We value your expertise and passion and aim to create a supportive atmosphere that encourages personal and professional growth. We pride ourselves on being a leading company in our industry, known for our stability, reliability, and commitment to excellence. At Traders Insurance, we value employee empowerment, open communication, and the ability to make a difference. Join us today to enjoy a multitude of opportunities for learning, development, and advancement. Responsibilities Working independently, this role will 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. Requirements Degree of Independence and Supervision 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. 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. Summary Qualifications 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. Candidates are generally expected to meet both the education and experience requirements. Compensation is commensurate with experience Traders' e mployees also benefit from: 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