Summary Provide support for various actuarial functions, including pricing, liability estimates, and the creation of financial projections. Essential Duties and Responsibilities Provide support for pricing projects Compile data to be used in analysis Analyze production and loss experience by agent, dealer, plans, classes, terms, and other rating variables to determine key drivers for product performance Use actuarial methods to determine proper rate levels by product Identify high loss dealers and develop high risk rates for them Create write-up of pricing recommendations for leadership review Provide support for implementation of new rates Prepare underwriting request with supporting documents for carrier review Provide rates to Operations for implementation Create or update rate cards used by Sales Provide loss experience requested by Sales Review exception requests from Sales and recommend responses Provide support for financial projections and liability estimates including profit share forecasts Calculating buyout offers for agreements with contingent liabilities No Charge-Back reserves Roadside reserves Assist in other tasks as needed Setup earnings for new programs Review application of earnings curves Serve as testing lead for department Education and Experience Bachelors of Science degree in Actuarial Science, Mathematics, Statistics, or related field 2 or more years prior work experience in actuarial, risk management, or similar function Prior work experience with vehicle service contracts preferred Advanced Excel knowledge Proficient with MS Office suite Knowledge of SQL, PowerBI, or other data analysis tools preferred Skills Intermediate/Advanced Excel Proficient with MS Office programs Proficient with database queries Advanced analytical skills Attention to detail and accuracy. Physical Demands While performing the duties of this job, the employee is regularly required to type and look at a computer screen for long periods of the day. The employee must be able to sit for long periods of time. Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodation will be made to enable individuals with disabilities to perform the essential functions. Note This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. Automobile Protection Corporation(APCO)is a Drug Free Workplace as well as an Equal Opportunity Employer. Qualified applicants shall be considered for all positions without regard to race, color, sex, religion, national origin, age, disability, veteran status, or any other status protected by federal, state or local law. #J-18808-Ljbffr