Insurance Product Resolution Analyst

Hagerty Insurance Agency; United States; Remote; USD 70,000 - 100,000; Full time

Benefits offered by this job

Remote work option

Hybrid schedule for local team

Job summary

Hagerty Insurance Agency seeks an Insurance Product Resolution Analyst to audit new product changes and support regulatory audits. You will write SQL queries, develop automation using AutoIt, and coordinate with Product, Compliance, IT, and Billing to ensure post-release accuracy and resolve issues quickly.

You will translate incomplete business requests into technical requirements, maintain data quality, and contribute to SOX/compliance processes while working in a remote-enabled environment.

Qualifications

• Strong SQL skills with complex joins and performance optimization.
• Proven ability to translate business requests into technical requirements.
• Experience with Excel and data reporting tools.

Responsibilities

• Execute insurance product audits by reviewing rates, features, and configurations.
• Write and execute SQL queries and automated tests for post-release audits.
• Proactively identify errors in product configuration and coordinate solutions across teams.
• Own corrective action plans from identification through resolution.
• Design and maintain automation code for production cleanup and data tasks.

Skills

SQL

Excel

Automation

Cross-functional collaboration

Problem solving

Communication

Tools

AutoIt

SharePoint

ADO

Salesforce

Drivetrain

Job description

Insurance Product Resolution Analyst Say hello to Hagerty Hagerty is a company built by drivers for drivers. We put our members at the center of everything we do, and are dedicated to making it easier and more enjoyable for enthusiasts to drive and celebrate the machines they love. We're proud to be the world's largest insurer of collectible and enthusiast vehicles and are home to the Hagerty Drivers Club, the world's largest car club. Our Marketplace business presents live and digital sales across the U.S. and Europe, we host a number of driving events and concours, and our award-winning automotive journalists produce the most popular car magazine globally, alongside internationally awarded videos. We're committed to Never Stop Driving. Ready to get in the driver's seat? Join us!

As an Insurance Product Resolution Analyst, you'll be responsible for executing audits specific to new product and/or regulatory changes as well as supporting DOI and Carrier audits. This individual will work with the teams responsible for product and compliance development as well as the Product Implementation team responsible for product system configuration to ensure accuracy of all jobs post release by performing production audits.

Success in this role is achieved by a strong focus on finding errors that may require recall and assisting in those recall efforts.

What you'll do

• Execute insurance product audits by reviewing rates, features, factors, document sending conditions, and post-release configurations.
• Write and execute global SQL queries.
• Write and execute automated testing to perform post-release audits.
• Produce data-driven results for product and compliance query requests.
• Proactively identify and elevate errors in insurance product configuration, coverage mapping, billing, and compliance processes; develop and propose solutions in collaboration with appropriate teams.
• Own insurance product corrective action plans from identification through resolution, coordinating across internal teams (Product, Compliance, MSC, IT, Billing, Treasury) as needed.
• Serve as the subject matter expert on active compliance and product resolution issues, fielding questions, investigating impacts, and communicating strategies to all impacted stakeholders.
• Design, write, and maintain automation code (AutoIt and similar tools) for production cleanup efforts; Respond and track Service Now tickets for rate inquiries and ensure timely resolution and closure of each ticket in accordance with team service standards.
• Support corrective action efforts for the Apex insurance product when needed

This might describe you

• Strong attention to detail and analytical thinking, with the ability to identify root causes and navigate complex, multi-variable problems.
• Excellent organizational and communication skills, including the ability to relay technical information clearly to both internal and external audiences.
• Demonstrated ability to lead cross-functional work independently, managing competing priorities without direct supervision.
• Ability to translate incomplete business requests into documented technical and reporting requirements.
• Strong SQL skills, including complex joins, common table expressions, query troubleshooting, and performance optimization.
• AutoIt automation experience preferred; ability to build, maintain, and expand an automation library.
• Experience with insurance product configuration, compliance, or corrective action processes preferred.
• Proficiency in Microsoft Excel, SharePoint, and ADO or similar project tracking tools.

• Minimum of one year Excel experience
• Minimum of one year Drivetrain and Salesforce experience

Other things to note

This position is open to U.S. remote work. However, team members who reside within 20 miles of the Traverse City headquarters will follow a hybrid schedule, working from the office three days per week. Familiarity with public company requirements, including Sarbanes Oxley and key regulations, if applicable. For SOX compliant roles, responsible for designing, executing, and documenting internal controls where they have been identified as owners to prevent errors in financial reporting, processes, and business operations. Including attestation to the completeness, accuracy, and compliance of all financial reporting data, where applicable.

If you reside in the following jurisdictions:

Illinois, Colorado, California, District of Columbia, Hawaii, Maryland, Minnesota, Nevada, New York, or Jersey City, New Jersey, Cincinnati or Toledo, Ohio, Rhode Island, Washington, British Columbia, Canada

At Hagerty, we share the road. We are an inclusive automotive community where all are welcomed, valued and belong regardless of race, gender, age, or car preference. We are united by our shared passion for driving, our commitment to preserve car culture for future generations and our desire to make a positive impact in the world.

#LI-Remote / LI-Hybrid / #LI-Onsite

EEO/AA US Benefits Overview Canada Benefits Overview UK Benefits Overview

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us! Hagerty is an automotive enthusiast brand committed to saving driving and to fueling car culture for future generations. We are a leading provider of specialty vehicle insurance, expert car valuation data and insights, live and digital car auction services, immersive events and automotive entertainment custom made for the 67 million Americans who self-describe as car enthusiasts. Hagerty also operates in Canada and the U.K. and is home to Hagerty Drivers Club, a community of over 800,000 who can't get enough of cars. We are a rapidly growing company that values a winning, values-driven culture. We provide meaningful work for, and invest in, every single team member.