Regulatory Reporting & Compliance Specialist (Hybrid)

American Family Mutual Insurance Company•Keene, NH

2d•Hybrid

About The Position

As a Regulatory Reporting & Compliance Specialist, you will ensure the company's success across all states by submitting essential regulatory filings. You will collaborate with a diverse team of internal partners to guarantee timely and precise compliance with state laws and regulations. This role involves in-depth research of laws, regulations, and requirements to assess their impact on the 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 includes writing and maintaining SQL and GCP queries and documenting data procedures and controls that support audit-ready reporting. You will help adapt business processes to maintain compliance as changes unfold and identify and implement process improvements to enhance operational efficiency. The position reports to the Senior Manager, Regulatory Reporting and Compliance.

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

Nice To Haves

Internal candidates are encouraged to apply regardless of location and will be considered based upon the needs of the role.

Responsibilities

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.