Regulatory Reporting Analyst: Data-Driven Compliance

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

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.