Regulatory Reporting Analyst

Clearbrook Group Services Inc.; City of Albany (NY); On-site; USD 74,000 - 98,000; Full time

Benefits offered by this job

Health insurance

Dental plan

Vision plan

401(k) with company match

Paid time off

Professional development

Job summary

Clearbrook Holdings Inc. is seeking a Regulatory Reporting Analyst to support preparation and submission of property and casualty regulatory reports, ensuring compliance across jurisdictions.

The role involves data validation, process automation, and collaboration with IT, Claims, underwriters, and finance to gather data and improve quality. You must be a US citizen or green card holder and possess strong SQL and Excel skills, with a focus on accuracy and timely reporting.

Qualifications

• Bachelor’s degree or equivalent experience required.
• Minimum 3 years of regulatory reporting or data analysis experience.
• Proficiency in SQL or similar data querying tools.
• Strong Excel skills and data accuracy focus.

Responsibilities

• Prepare and submit regulatory reporting and statistical data.
• Ensure compliance with jurisdictional requirements and validate outputs.
• Perform data extraction, manipulation, and analysis to support reporting needs.
• Collaborate with IT, Claims, U/W and Finance to gather data and resolve issues.
• Identify trends and anomalies; document data limitations for audits.

Skills

SQL proficiency

Excel

Data analysis

Communication skills

Attention to detail

Team collaboration

Education

Bachelor’s degree or equivalent experience

Tools

Snowflake

Microsoft Fabric

Python

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.

Salary

Salary for this role - $74k - $98k.

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 partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence.