Regulatory Reporting & Compliance Specialist

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. Responsibilities 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. You will research laws, regulations, and requirements to assess their impact on our organization’s filing processes, procedures, and guidelines. You will partner closely with Finance, Data/BI, Actuarial, and IT to source, validate, and reconcile data used in state regulatory/statistical filings, including 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 and identify process improvements that enhance operational efficiency. You will report to the Senior Manager, Regulatory Reporting and Compliance. Primary Accountabilities Ensure regulatory and stat reporting compliance for Enterprise. Identify industry trends and opportunities for development of controls, procedures, and 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. Qualifications 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. 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. 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 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. Position Compensation $62,000.00 - $103,000.00 (Salary). Benefits We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits, 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. EEO Statement 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 View email address on click.appcast.io to request a reasonable accommodation. #J-18808-Ljbffr American Family Insurance