Actuarial Small Business Spectrum

The Hartford; Hartford (CT); On-site; USD 113,000 - 170,000; Full time

Job summary

The Hartford in Hartford, CT is seeking an AD & Associate Actuary to support Spectrum and E&S pricing for Small Business. You will develop rate indications, refine class plans, and advance analytic capabilities using SQL, R, and Python.

This hybrid role involves collaboration with underwriting and product teams, mentoring junior actuaries, and presenting results to leadership across multiple states.

Qualifications

• Bachelor’s degree required.
• 6–7 actuarial exams and 4+ years of experience.
• Strong analytical, critical thinking and problem-solving skills.
• Strong Excel skills required.
• Proficiency in SQL, VBA, R, Python, SAS or similar.

Responsibilities

• Support updates to Spectrum and E&S loss development factors, trend selections, and pricing assumptions.
• Roll out Spectrum class plan to states and update pricing factor analyses.
• Prepare slides for leadership on new business results and profitability.
• Collaborate with underwriting and product teams on the latest class plan.
• Leverage SQL, R, Python to enhance analytics.
• Lead and mentor junior team members.

Skills

Analytical thinking

Communication skills

Time management

Leadership / mentoring

Problem solving

Attention to detail

Education

Bachelor's Degree

Tools

SQL

VBA

R

Python

SAS

Job description

AD & Associate Actuary - AS07AE We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future. The position is part of the Spectrum actuarial team which provides support for $3.0B of Commercial Multi-Peril business for The Hartford’s Small Business segment. Our Spectrum BOP product is proprietary to The Hartford and is regarded as the market leader in the industry. Additionally, the team supports the growth and development of Small Business’ Multi-Peril E&S offering. As we operate in both a fluid and competitive industry, we continuously innovate the line and create product / coverage improvements that meet the ever-changing needs of our customers and to remain ahead of our competitors.

Opportunities

• Develop internal modeled rate level indications to inform product rate strategy.
• Continuously evolve the Spectrum class plan through improvements to pricing segmentation via additional granularity and new variable introduction.
• Advance our analytic and monitoring capabilities for the E&S product offering.
• Think creatively to enhance or automate long-standing actuarial methodology using more contemporary techniques.
• Help develop countrywide rate strategy for the various Spectrum products.
• Engage in continuous learning and professional development opportunities to stay updated with industry trends and best practices.

Responsibilities

• Support the update of Spectrum and E&S Loss Development Factors, Trend Selections, and Pricing Assumptions to feed into modeled indications.
• Support the rollout of the latest Spectrum class plan to all states and create updated analysis for pricing factors such as deductibles & ILF’s.
• Update slides for monthly presentations to leadership around New Business results & profitability.
• Partner with the Small Business Territory Actuarial Team to support ad hoc requests from business partners in Underwriting & Product and the rollout of our latest class plan.
• Utilize programming languages such as SQL, R, and Python to enhance analytical capabilities.
• Lead and mentor junior team members to foster a collaborative and innovative work environment.

Experience & Skills

• Bachelor’s Degree required.
• 6-7 actuarial exams, 4+ years of experience.
• Strong analytical, critical thinking and problem-solving skills, with the ability to effectively resolve complex issues.
• Strong Excel skills required.
• Knowledge of SQL, VBA, R, Python, SAS or similar code languages a plus.
• Excellent written and verbal communication skills.
• Attention to detail with strong time and project management skills.
• Driven, intellectually curious, passionate, resourceful and creative.
• Proactive individual, who challenges existing processes, can influence others and drive a process to a conclusion while meeting critical deadlines.

This role can have a Hybrid work schedule out of Hartford, Chicago, Charlotte offices. Candidates will have the expectation of working in an office 3 days a week (Tuesday through Thursday).

Compensation

The annualized base pay range for this role is: $113,200 - $169,800

Equal Opportunity Employer

Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us

About Us | Our Culture | What It’s Like to Work Here | Perks & Benefits Every day, a day to do right. Showing up for people isn’t just what we do. It’s who we are – and have been for more than 200 years. We’re devoted to finding innovative ways to serve our customers, communities and employees—continually asking ourselves what more we can do. Is our policy language as simple and inclusive as it can be? Can we better help businesses navigate our ever-changing world? What else can we do to destigmatize mental health in the workplace? Can we make our communities more equitable? That we can rise to the challenge of these questions is due in no small part to our company values that our employees have shaped and defined. And while how we contribute looks different for each of us, it’s these values that drive all of us to do more and to do better every day.