Regulatory Reporting & Compliance Specialist

American Family Insurance Agency Staff; Boston (MA); Hybrid; USD 62,000 - 103,000; Full time

Benefits offered by this job

401(k)

Comprehensive medical, dental, and vision benefits

Paid time off program

Student loan repayment program

Job summary

American Family Insurance Agency Staff in Boston is looking for a Regulatory Reporting & Compliance Specialist. This hybrid position involves ensuring compliance with state regulations, collaborating with cross-functional teams, and maintaining relevant documentation.

The role requires strong analytical skills, proficiency in SQL and Excel, and a background in insurance compliance. The salary range is between $62,000 and $103,000, with benefits including 401(k) and medical coverage.

Qualifications

• Demonstrated experience providing customer-driven solutions.
• Solid knowledge and understanding of state insurance laws.
• Experience in rate and form filings.

Responsibilities

• Ensure regulatory and statutory reporting compliance.
• Monitor and interpret regulatory legislation.
• Develop and provide business requirements for compliance projects.
• Document procedures for regulatory and statistical reporting.

Skills

Customer-driven solutions

Regulatory compliance

Insurance knowledge

SQL

Microsoft Excel

Data analysis

Education

5+ years in regulatory compliance or relevant fields

Tools

SQL/BigQuery

Excel

PowerPoint

Jira

Job description

Job Overview

In this hybrid role, you will be expected to work a minimum of 10 days per month out of the Keene, NH; Madison, WI or Boston, MA offices. Internal candidates are encouraged to apply regardless of location and will be considered based upon the needs of the role.

As a Regulatory Reporting & Compliance Specialist you'll ensure our business succeeds across all states by submitting essential regulatory filings. You'll work with a diverse team of internal partners, forging collaborations to guarantee timely and precise compliance with state laws and regulations. Dive deep into researching laws, regulations, and requirements to assess their impact on our organization's filing processes, procedures, and guidelines. You will also partner closely with Finance, Data/BI, Actuarial, and IT to source, validate, and reconcile data used in state regulatory/statistical filings. This will include writing and maintaining SQL and GCP queries and documenting data procedures and controls that support audit-ready reporting.

As changes unfold, you'll help adapt our business processes to maintain compliance. Moreover, you'll be a catalyst for innovation, identifying and implementing process improvements that enhance our operational efficiency to new heights. Embrace the challenge and improve our organization's success!

You will report to the Senior Manager, Regulatory Reporting and Compliance.

#LI-Hybrid

Position Compensation Range

$62,000.00 - $103,000.00

Pay Rate Type

Salary

Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.

Primary Accountabilities

• 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.
• Determine next action for complying - communicate and work with other business areas to comply.
• 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, new product, state development, legacy retirements, new data source development.
• Ensure consistency through documentation and review of existing policies driving automation, future state success while minimizing penalties and capitalizing on credit opportunities.
• 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; identify root causes of data discrepancies and implement fixes within defined change controls.
• Execute and document reconciliations/tie-outs between filing outputs and Financials and/or statutory source reports; investigate variances using query-based analysis
• Perform data quality checks (completeness, duplicates, outliers, trend/variance) and escalate potential data defects with clear evidence.
• Document query purpose, logic, assumptions, parameters, and data field to source mapping to support audit/regulator inquiries and repeatable reporting.
• Partner with Finance, Actuarial, Data/BI, and IT to confirm business definitions, mapping, and source-of-record alignment for filing data elements.
• Identify opportunities to improve reliability/efficiency (standardized checks, controlled templates, query optimization) and contribute to automation roadmap.

Specialized Knowledge, Skills, and Education Requirements

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

Additional Preferred Qualifications

• Ability to translate reporting requirements into controlled, repeatable workflows using SQL/BigQuery, Excel, and work-tracking tools (e.g., Jira), with strong documentation to enhance operational efficiency and transparency.
• Ability to reconcile and validate regulatory datasets to financial or source-of-record totals
• Working knowledge of SQL with the ability to read, understand, update, and troubleshoot existing queries
• Advanced expertise in Microsoft Excel, including the use of pivot tables, VLOOKUP, and complex formulas.
• Knowledge of regulatory and statutory reporting requirements.
• 5+ years of experience in regulatory compliance, insurance, or relevant fields.
• Ability to develop and implement controls and procedures to ensure compliance.
• Ability to identify industry trends and opportunities for the development of controls and procedures.
• Strong analytical skills to monitor and interpret regulatory legislation.
• Ability to collaborate with regulators, states, boards, bureaus, vendors, and statistical agents.
• Experience in documenting processes and procedures related to regulatory and statistical reporting.
• Skills in driving automation and future state success while minimizing penalties and capitalizing on credit opportunities.
• Demonstrated expertise in PowerPoint to create impactful presentations.
• Ability to present complex information clearly in Excel/PowerPoint; strong attention to formatting and accuracy

Travel Requirements

• Up to 10%

Licenses

• Not applicable.

Physical Requirements

• Work that primarily involves sitting/standing.

Working Conditions

• Not applicable.

Additional Information

• To ensure a strong start, all employees participate in our New Employee Orientation during their first week. This experience is held in person at our Madison, WI Headquarters or one of our AmFam core locations to help you connect with our mission, meet key team members and build relationships that support your growth. At times, sessions may be delivered virtually based on scheduling and availability.
• Offer to selected candidate will be made contingent on the results of applicable background checks
• Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions
• Sponsorship will not be considered for this position unless specified in the posting

We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email [e-mail] to request a reasonable accommodation.

#LI-MN2