This role is part of American Family's Actuarial Tools & Modeling team supporting areas across personal and commercial lines, including property, auto, specialty, and other commercial product areas. The Actuarial Tools & Modeling team is responsible for developing and operationalizing modeling frameworks, advanced pricing platforms, actuarial methodologies, and processes to support various personal and commercial lines pricing teams. As a member of this team, you will design and develop new processes and tools which require technical skills in python and SQL along with database management. You will maintain and update the pricing platform used by the pricing actuaries for their rate revision work throughout the United States. You will work on the creation of new Actuarial tools and processes using newer technologies by collaborating with other teams to satisfy business needs. You will use actuarial concepts to analyze impacts of rate plan changes on various personal and commercial line books.Position Compensation Range:$76,000.00 - $125,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 You will create, maintain, and improve upon existing data parsing scripts. You will complete and enhance data validation processes to deliver pricing datasets. You will be a subject matter expert on data efforts including dataset development and consultation on data and analytical development in collaboration with the pricing teams. You will contribute to recommendations and revisions to ratemaking methodologies. You will explore new actuarial concepts, statistical models, and data sources to deliver innovative solutions for the business. You will assist with the development and analysis of pricing impacts for new products and rating structures. You will assist with development of classification ratemaking methodologies and models.Specialized Knowledge & Skills Requirements Demonstrated experience providing customer-driven solutions, support, or service. Ability to work as part of a team and to communicate effectively. Coding proficiency in SQL, R, Python, VBA, or other related languages. Solid knowledge and understanding of at least one personal or commercial property and casualty product, pricing, rates and industry trends. Solid knowledge and understanding of underwriting guidelines and concepts. Demonstrated experience performing statistical/actuarial analysis and data forecasting and modeling techniques. Solid knowledge and understanding of forecasting and statistical analysis and modeling. Pursuing Associate or Fellow in Casualty Actuary Society (ACAS or FCAS) with at least 2 CAS/SOA exams completed.Licenses Not applicable.Travel Requirements Up to 10%.Physical Requirements Work that primarily involves sitting/standing.Working Conditions Not applicable.minimum of 10 days per month from one of the following office locations: Madison, WI 53783; Boston, MA 02110; Denver, CO 80112; Eden Prairie, MN 55343; Keene, NH 03431; St. Joseph, MO 64507; Phoenix, AZ 85034.Relocation may be provided based on business need.#LI-HybridWe 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-AB1
