Regulatory Reporting & Compliance Specialist

Role Overview

• 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

Requirements

• 5+ years of experience in regulatory compliance, insurance, or relevant fields
• 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)
• 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
• Experience in documenting processes and procedures related to regulatory and statistical reporting

Tech Stack

• BigQuery
• SQL

Benefits

• Comprehensive medical, dental, vision and wellbeing benefits
• 401(k) contribution
• Pension plan
• Annual incentive
• 9 paid holidays
• Paid time off program (23 days accrued annually for full-time employees)
• Student loan repayment program
• Paid-family leave