Insurance Product Resolution Analyst

Hagerty Insurance Agency; Northern (KY); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Remote work options

Hybrid schedule near Traverse City

Job summary

Hagerty Insurance Agency seeks an Insurance Product Resolution Analyst to audit insurance product configurations, validate post-release setups, and support compliance activities. You will write SQL queries, develop automated tests, and coordinate across Product, Compliance, IT, and Billing to ensure accurate configurations and timely remediation.

The role emphasizes attention to detail, strong analytical thinking, and ability to communicate complex technical results to stakeholders in a clear

Qualifications

• Strong SQL skills, including joins, CTEs, and performance tuning.
• Experience with AutoIt automation preferred.
• Proficiency with Microsoft Excel and SharePoint; familiarity with project tracking tools (ADO or similar).
• Experience with Salesforce and Drivetrain is a plus.
• Familiarity with SOX or public company regulatory requirements is advantageous.

Responsibilities

• Execute insurance product audits across rates, features, and post-release configurations.
• Write and run SQL queries and automated tests for post-release audits.
• Produce data-driven results for product/compliance requests.
• Lead corrective action plans across cross-functional teams until resolution.
• Develop automation using AutoIt to support production cleanup and ticketing workflows.

Skills

SQL

AutoIt

Excel

Salesforce

Drivetrain

SharePoint

Tools

AutoIt

Salesforce

Excel

SharePoint

Job description

Insurance Product Resolution Analyst page is loaded## Insurance Product Resolution Analystlocations: USA-Remotetime type: Full timeposted on: Posted Yesterdaytime left to apply: End Date: October 9, 2026 (5 days left to apply)job requisition id: R5429**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.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 escalate 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 please email [e-mail] for compensation, comprehensive benefits and the perks that set us apart.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*If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!*