Regulatory Reporting & Compliance Specialist

American Family Insurance

Regulatory Reporting & Compliance Specialist ensuring compliance with state laws and regulations for American Family Insurance. Collaborating with various teams to enhance operational efficiency and maintain data integrity.

Posted 5/13/2026full-timeKeene • Massachusetts, New Hampshire, Wisconsin • 🇺🇸 United StatesMid-LevelSenior💰 $62,000 - $103,000 per yearWebsite

Tech Stack

Tools & technologies

BigQuerySQL

About the role

Key responsibilities & impact

Ensure regulatory and stat reporting compliance for Enterprise
Identify Industry trends and opportunities for development of controls, procedures, cross functional alignment and regulatory reporting
Monitor and interpret regulatory legislation from DOI's, Boards, Bureaus, etc
Understand current market trends ensuring compliance, data integrity and best practices
Work closely with regulators, states, boards, bureaus, vendors and stat agents related to new and existing regulations
Develop and provide business requirements for the implementation and maintenance of compliance reporting project
Document procedures related to regulatory and statistical reporting
Maintain and troubleshoot existing SQL/BigQuery queries supporting regulatory/statistical filings
Perform data quality checks (completeness, duplicates, outliers, trend/variance) and escalate potential data defects

Requirements

What you’ll need

5+ years of experience in regulatory compliance, insurance, or relevant fields
Demonstrated experience providing customer-driven solutions, support, or service
Demonstrated experience in rate and form filings
Solid knowledge and understanding of insurance products and related pricing concepts
Solid knowledge and understanding of state insurance laws and regulations
Ability to reconcile and validate regulatory datasets to financial or source-of-record totals
Strong analytical skills to monitor and interpret regulatory legislation
Advanced expertise in Microsoft Excel, including the use of pivot tables, VLOOKUP, and complex formulas
Working knowledge of SQL with the ability to read, understand, update, and troubleshoot existing queries
Ability to develop and implement controls and procedures to ensure compliance.

Benefits

Comp & perks

comprehensive medical, dental, vision and wellbeing benefits
competitive 401(k) contribution
pension plan
annual incentive
9 paid holidays
paid time off program (23 days accrued annually for full-time employees)
student loan repayment program
paid-family leave

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLBigQueryMicrosoft Exceldata quality checksregulatory reportingstatistical reportingrate and form filingsdata integritycontrols developmentprocedures implementation

Soft Skills

analytical skillscustomer-driven solutionssupportservicecross functional alignmentcommunicationtroubleshootingproblem-solvingattention to detailcollaboration