Regulatory Reporting & Compliance Specialist (Hybrid)

As a Regulatory Reporting & Compliance Specialist youll ensure our business succeeds across all states by submitting essential regulatory filings. Youll 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 organizations 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 youll help adapt our business processes to maintain compliance. Moreover youll be a catalyst for innovation identifying and implementing process improvements that enhance our operational efficiency to new heights. Embrace the challenge and improve our organizations 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

Position Compensation Range:

$62000.00 - $103000.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 DOIs Boards Bureaus etc.
• Determine next action for complying communicate and work with other business areas to comply.
• Understandcurrent 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 existingSQL/BigQueryqueries supporting regulatory/statistical filings; identify root causes of data discrepancies and implement fixes within defined change controls.
• Execute and documentreconciliations/tie-outsbetween filing outputs and Financials and/or statutory source reports; investigate variances using query-based analysis
• Performdata 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 inrate 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:

• A bility 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 SQLwith 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 andimplement controls and procedures to ensure compliance.
• Ability to identify industrytrends 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

• 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

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.

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 to request a reasonable accommodation.

#LI-MN2

Required Experience:

IC