Regulatory Reporting & Compliance Specialist

American Family Insurance•Boston, MA

8d•$62,000 - $103,000•Hybrid

About The Position

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 Internal candidates are encouraged to apply regardless of location and will be considered based upon the needs of the role. #LI-Hybrid

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.
Relocation support is offered for eligible candidates.
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.