Remote Advanced Excel Jobs in Chicago, IL (NOW HIRING)

Location(s)

Details

Kemper is one of the nation's leading specialized insurers. Our success is a direct reflection of the talented and diverse people who make a positive difference in the lives of our customers every day. We believe a high-performing culture, valuable opportunities for personal development and professional challenge, and a healthy work-life balance can be highly motivating and productive. Kemper's products and services are making a real difference to our customers, who have unique and evolving needs. By joining our team, you are helping to provide an experience to our stakeholders that delivers on our promises.

The Associate Product Manager plays a key role in managing and optimizing personal auto products by executing pricing strategies, enhancing coverage options, and supporting market expansion. The role bridges technical analysis and strategic planning.

Principal Duties and Responsibilities:

• Manage product filings, including preparation, submission, and correspondence with regulators to ensure timely and accurate approvals.
• Analyze product and competitor data to identify gaps and recommend enhancements to coverage, pricing, or segmentation.
• Support implementation of new product initiatives, collaborating with IT, operations, and marketing to ensure smooth rollout.
• Communicate pricing or product changes to internal stakeholders, ensuring understanding and proper execution.
• Monitor state-level profitability and retention metrics to identify areas for improvement.
• Develop project timelines and coordinate deliverables across departments to meet business objectives.
• Handle audit and compliance reviews by ensuring documentation and decisions are well-supported and traceable.
• This is a hybrid position that could be based out of Dallas, Alpharetta, Chicago; or if applicant is not able to commute to those locations, remote is an option.

Minimum Job Requirements:

• Bachelor's degree in a STEM discipline; Actuarial Science, Mathematics, Statistics, Economics, Finance, Data Science, Business, or a related analytical discipline required.
• Master's degree in Business Administration, Analytics, or a related field is a plus.
• Minimum 3-5 years of experience in product management, pricing, or insurance operations.
• Experience with rate filings and multi-state product management preferred.
• Proficiency in Excel, SQL, and data analysis platforms; experience with insurance policy admin systems is beneficial.
• Understanding of regulatory filing systems (e.g., SERFF).
• CPCU, AINS, or other industry certifications encouraged.

Required Job Skills:

• Advanced Excel and solid experience using SQL
• Proficient in SERFF and filing support tools
• Familiarity with pricing tools and product management systems
• Working knowledge of insurance policy admin and rating platforms
• Strong analytical skills and decision-making capabilities
• Excellent documentation and communication skills
• Ability to translate technical data into actionable insights
• Project coordination and time management skills
• Strong attention to detail and regulatory accuracy

The range for this position is $99,000 to $164800. When determining candidate offers, we consider experience, skills, education, certifications, and geographic location among other factors. This job is eligible for an annual discretionary bonus and Kemper benefits (Medical, Dental, Vision, PTO, 401k, etc.)

Kemper is proud to be an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, disability status or any other status protected by the laws or regulations in the locations where we operate. We are committed to supporting diversity and equality across our organization and we work diligently to maintain a workplace free from discrimination.

Kemper does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Kemper and Kemper will not be obligated to pay a placement fee.

Kemper will never request personal information, such as your social security number or banking information, via text or email. Additionally, Kemper does not use external messaging applications like WireApp or Skype to communicate with candidates. If you receive such a message, delete it.