Sql Remote Jobs in Madison, WI (NOW HIRING)

Perform most complex analyses for the full range of actuarial activities related to Reinsurance pricing and analysis for one or more lines of business (property, casualty, mortgage, non-standard auto). Build complex models and projections to help the business to create sound pricing and appropriate risk-adjusted returns on capital. Build forecasts and models for reinsurance. Be a subject matter expert and consultant to partners throughout the organization. Present recommendations regarding the development or effectiveness of multiple strategies.
You will report to the Head of Reinsurance Pricing & Analytics, AmFamRe.
We are open to candidates anywhere in the United States. This is a primarily remote position.
Internal candidates are encouraged to apply regardless of location and will be considered based upon the needs of the role.
#LI-Remote

Position Compensation Range:

$113,000.00 - $194,000.00

Pay Rate Type:

Salary

Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.

Responsibilities:

• Develop relationships with important partners and provide insights and solutions to address specific business concerns.
• Explore new concepts, statistical models, and data sources to provide solutions for the business.
• May contribute to all aspects of pricing, lead the recurring process, facilitate the pricing strategy, and help develop pricing for new products and rating structures.
• Monitor industry and competitor trends to determine potential impact to actuarial strategies and solutions.
• Analyze the profitability of assumed property & casualty treaty reinsurance opportunities.
• Maintain a portfolio analytics framework, ensuring consistent analytical standards for evaluating assumed reinsurance opportunities.
• Create a collaborative, performance-driven work environment by promoting trust, transparency, and inclusion.
• Collaborate with Underwriting and the rest of the Pricing & Analytics team to help with submissions and potential deals.

Requirements:

• Associate or Fellow in Casualty Actuary Society (ACAS or FCAS).
• Prior reinsurance experience strongly preferred, but candidates with strong primary pricing experience, especially large account pricing, will also be considered.
• Demonstrated experience providing customer-driven solutions, support or service.
• Demonstrated experience analyzing assumed reinsurance treaties.
• Solid knowledge and understanding of complex insurance and reinsurance structures.
• Solid knowledge and understanding of property and casualty products, pricing, rates and industry trends.
• Solid knowledge and understanding of the global reinsurance industry and its markets.
• Demonstrated experience with Excel, SQL, Python, and basic programming.
• Solid knowledge of catastrophe models.
• Extensive knowledge and understanding of advanced financial and statistical analysis techniques including actuarial techniques.
• Solid knowledge and understanding of data models and database design and development concepts.

Travel Requirements:

• Up to 10%.

Additional Information

• To ensure a strong start, all employees participate in our New Employee Orientation during their first week. This experience is held in person at our Madison, WI Headquarters or one of our AmFam core locations to help you connect with our mission, meet key team members and build relationships that support your growth. At times, sessions may be delivered virtually based on scheduling and availability.
• 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
• Sponsorship will not be considered for this position unless specified in the posting

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.

American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email AskHR@AmFam.com to request a reasonable accommodation.

#LI-DB1