Insurance Product Resolution Analyst

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.

• 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 (Auto It 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

• 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.
• Auto It 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

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.

Illinois, Colorado, California, District of Columbia, Hawaii, Maryland, Minnesota, Nevada, New York, or Jersey City, New Jersey, Cincinnati or Toledo, Ohio,…