Product Support Specialist- Rate and Filing Implementation (Hybrid)

Company: American Family Insurance
Location: Saint Joseph
Posted on: May 6, 2025

Job Description:

You will oversee the integrity of rule and rate revisions for all commercial lines. You will analyze and interpret rate and rating plan changes. Compile and integrate data into rating processes and systems. Effectively communicate the status, implementation, and impact of changes to rules, rates, and procedures. Develop and run standard and ad-hoc reports for the department to support the analysis and business partner requests. Provide enhanced technical project support to project teams and will participate on projects within defined scope and responsibility. You will report directly to the Senior Manager. Internal candidates are encouraged to apply regardless of location and will be considered based upon the needs of the role. In this hybrid, you will be expected to work a minimum of 10 days per month from one of the following office locations: Madison, WI 53783; Boston, MA 02110; Denver, CO 80112; Keene, NH 03431; St. Joseph, MO 64507; Phoenix, AZ 85034. #LI-HybridPosition Compensation Range:$56,000.00 - $92,000.00Pay Rate Type:SalaryCompensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.Primary Accountabilities

• Leads process for integrating and manipulating industry, bureau and other data into worksheets, exhibits and other documents and processes utilized with rate revisions.
• Leads process for rate change implementation, systems impact and agent communications of rate and rule changes.
• Prepares communications for the department.
• Prepares and submits filings.
• Reviews bureau activity and makes recommendations for department changes.
• Conducts premium comparisons & analysis and contributes to consumer responses.
• Creates and defines reports as requested and provide basic analysis to support business decisions.
• Ensures that each request for data and/or analysis is delivered effectively and on time to support department needs.
• Gathers and analyzes data and define data requirements to support business reporting.
• Responsible for the coordination of business projects. Document and maintain business project plans, and goals, roles, and processes to clarify scope, schedule, and budget. Identify key dependencies, resources, timeframes, and milestones for key deliverables.
• Gathers information and analyze problems across the team and department to proactively recommend solutions to leadership. Work with the team to create and maintain a business project plan containing objectives, timeline, priorities, and risks.
• Provides post-implementation results monitoring and adjustment. Continually improve project skills via learnings and best practices from prior business projects, training, peers, etc. Facilitate distribution and/or archival of project documentation.Specialized Knowledge & Skills Requirements
  • Demonstrated experience providing customer-driven solutions, support or service.
  • Demonstrated experience with various PC software applications and Microsoft Office products.
  • Demonstrated experience using and manipulating data in databases, spreadsheets, and analysis tools.
  • Solid knowledge and understanding of actuarial rates and filing standards and insurance pricing terminology.
  • Solid knowledge and understanding of reporting tools and techniques.
  • Demonstrated experience with project management, coordination or analysis.Travel Requirements
    • Up to 10%.Physical Requirements
      • Work that primarily involves sitting/standing.Preferred candidate:
        • Experience working in the P&C Insurance space.
        • Advanced excel experience (INDEX and MATCH, VLOOKUP and HLOOKUP, ARRAY FORMULAS, IFERROR).
          • Offer to selected candidate will be made contingent on the results of applicable background checks.
          • Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions.
          • Our policy restricts consideration of applicants needing employment sponsorship (visa) to specialty occupations. Sponsorship will not be considered for this position.We encourage you to apply even if you do not meet all of the requirements listed above. Skills can be used in many different ways, and your life and professional experience may be relevant beyond what a list of requirements will capture. We encourage those who are passionate about what we do to apply!We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.#LI-MR1

Keywords: American Family Insurance, Saint Joseph , Product Support Specialist- Rate and Filing Implementation (Hybrid), Other , Saint Joseph, Missouri