Regulatory Reporting Analyst

Farm Family; Northern (KY); Hybrid; USD 74,000 - 98,000; Full time

Benefits offered by this job

Annual bonus

Generous benefits

401(k) with company match

Paid time off

Professional development

Job summary

Farm Family, a specialty property and casualty insurer, is seeking a Regulatory Reporting Analyst to support the preparation and submission of regulatory and statistical reports. You will work with data, validate outputs, and help improve data quality within a collaborative team.

You will use SQL and Excel to extract and analyze data, assist cross-functional partners, and ensure compliance with jurisdictional requirements. U.S. citizenship or a Green Card is required.

Qualifications

• Bachelor’s degree or equivalent experience.
• Minimum of 3 years in regulatory reporting, data analysis, insurance operations, or related field.
• Working knowledge of SQL or similar data querying tools.
• Proficiency in Microsoft Excel.
• Exposure to data platforms or programming languages is a plus.
• Familiarity with Property & Casualty insurance concepts.
• Strong attention to detail and analytical mindset.

Responsibilities

• Assist in the preparation and submission of regulatory reporting and statistical reports.
• Support understanding of regulatory requirements across jurisdictions and apply them to reporting activities.
• Perform quality checks to ensure accuracy, completeness, and timeliness of submissions.
• Help monitor reporting outputs and flag errors or inconsistencies for resolution.
• Extract, manipulate, and analyze data to support regulatory reporting needs.
• Utilize SQL (or similar tools) to assist in querying and validating data.
• Support data reconciliation and validation efforts, escalating discrepancies.
• Assist in identifying data limitations or issues and documenting findings.
• Follow established regulatory reporting processes and procedures.
• Partner with internal teams to gather required data and clarify reporting needs.

Skills

SQL

Excel

Data analysis

Regulatory reporting

Attention to detail

Education

Bachelor’s degree

Tools

Snowflake

Python

Microsoft Fabric

Job description

Company Shared Services Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly-owned subsidaries of Clearbrook Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence.

Job Description

The Regulatory Reporting Analyst supports the preparation and submission of Property & Casualty statistical and regulatory reports. This role assists in ensuring compliance with jurisdictional requirements by working with data, validating reporting outputs, and supporting process execution. The Analyst will develop technical and analytical skills to contribute to data-driven reporting, improve data quality, and support ongoing enhancements to regulatory reporting processes. In order to qualify for this position, you must be a US Citizen or Green Card holder.

Key Responsibilities

• Assist in the preparation and submission of regulatory reporting and statistical reports (e.g., Workers' Compensation, Proof of Coverage, unit statistical data, financial data calls).
• Support understanding of regulatory requirements across jurisdictions and apply them to reporting activities.
• Perform quality checks to help ensure accuracy, completeness, and timeliness of submissions.
• Help monitor reporting outputs and flag errors or inconsistencies for resolution.
• Extract, manipulate, and analyze data to support regulatory reporting needs.
• Utilize SQL (or similar tools) to assist in querying and validating data.
• Support data reconciliation and validation efforts, escalating discrepancies as appropriate.
• Assist in identifying trends or anomalies in data sets.
• Follow established regulatory reporting processes and procedures.
• Support efforts to streamline recurring tasks through basic automation or improved workflows.
• Participate in process improvement initiatives to enhance efficiency and data quality.
• Partner with internal teams (e.g., IT, Claims, U/W, Finance & Accounting) to gather required data and clarify reporting needs.
• Work with team members and external partners (e.g., bureaus, vendors) to support reporting activities.
• Communicate status updates, questions, and issues in a timely and clear manner.
• Maintain documentation of reporting activities to support audits and compliance reviews.
• Assist in identifying data limitations or issues and documenting findings.
• Support adherence to internal controls and regulatory standards.

Qualifications

• Bachelor’s degree or equivalent experience required.
• Minimum of 3 years of relevant experience in regulatory reporting, data analysis, insurance operations, or related field.
• Working knowledge of SQL or similar data querying tools (ability to write and interpret basic queries).
• Proficiency in Microsoft Excel.
• Exposure to data platforms (e.g., Snowflake, Microsoft Fabric) or programming languages (e.g., Python) is a plus.
• Familiarity with Property & Casualty insurance concepts.
• Exposure to ISO, NCCI, NISS, or other regulatory/bureau reporting is helpful, but not required.
• Strong attention to detail and accuracy.
• Analytical mindset with developing problem-solving skills.
• Ability to manage multiple tasks with guidance.
• Effective written and verbal communication skills.
• Collaborative approach with willingness to learn and develop.
• Demonstrates curiosity and a willingness to build technical and industry knowledge.
• Seeks guidance appropriately while building independence over time.
• Contributes to a team environment focused on accuracy, compliance, and continuous improvement.

Compensation and Benefits

The base salary range provided below is for hires in those geographic areas only and will be commensurate with candidate experience. Pay ranges for candidates in other locations may differ based on the cost of labor in that location. In addition to base salary, this position is eligible for an annual bonus based on company and individual performance as well as a generous benefits package.

Richmond and Albany Pay Range: $74,000 - $98,000

PLEASE NOTE: Applicants must be legally authorized to work in the United States. At this time, we are not able to sponsor or assume sponsorship of employment visas.

If you have a disability under the Americans with Disabilities Act or similar state or local law and you wish to discuss potential reasonable accommodations related to applying for employment with us, please contact our Benefits Department at 210-321-8400.

Benefits and Compensation

We offer a competitive compensation package, performance-based incentives, and a comprehensive benefits program—including health, dental, vision, 401(k) with company match, paid time off, and professional development opportunities.

Core Values

At Clearbrook our Core Values are Integrity, Collaboration, Pursuit of Excellence and Forward Thinking. These values reflect who we are today and who we aspire to be - guiding how we work, how we lead and how we succeed.

Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly owned subsidiaries of Clearbrook Group Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence.

At Clearbrook our Core Values are Integrity, Collaboration, Pursuit of Excellence and Forward Thinking. These values reflect who we are today and who we aspire to be - guiding how we work, how we lead and how we succeed.