Regulatory Reporting Analyst — NA Data & SQL Expert

Oliver James Group; New York (NY); On-site; USD 70,000 - 100,000; Full time

Job summary

Oliver James Group is seeking a Regulatory Reporting Analyst to support North American operations in a growing specialty insurance business. The role involves owning reporting processes, working cross-functionally, and enhancing how regulatory data is managed and delivered.

The ideal candidate will have experience in insurance regulatory reporting, strong SQL and data analysis skills, and be able to support accurate reporting across multiple jurisdictions.

Qualifications

• Experience in insurance regulatory reporting.
• Strong SQL and data analysis skills.
• Understanding of US and Canadian regulatory reporting requirements.
• Exposure to surplus lines reporting or state-specific filings is desirable.

Responsibilities

• Extract, query, and analyze large datasets using SQL and Snowflake to support regulatory reporting.
• Support US and Canadian insurance reporting requirements, including state-specific premium tax and surplus lines reporting.
• Prepare, validate, and reconcile premium and policy data for regulatory submissions.
• Investigate data discrepancies, resolve reporting issues, and implement data quality improvements.
• Partner with Finance, Legal, Compliance, Operations, and Tech teams to deliver accurate reporting data.
• Identify opportunities to streamline reporting processes and support automation initiatives.
• Take ownership of reporting activities and manage competing deadlines.

Skills

SQL

Regulatory reporting

Data analysis

Insurance

Tools

Snowflake

Job description

Oliver James Group is seeking a Regulatory Reporting Analyst to support North American operations in a growing specialty insurance business. The role involves owning reporting processes, working cross-functionally, and enhancing how regulatory data is managed and delivered.

The ideal candidate will have experience in insurance regulatory reporting, strong SQL and data analysis skills, and be able to support accurate reporting across multiple jurisdictions.