Regulatory Data & Reporting Analyst

Preferred Mutual Insurance Company; United States; Remote; USD 73,000 - 100,000; Full time

Benefits offered by this job

Health insurance

Dental coverage

Vision coverage

401k with employer contribution

Student loan repayment assistance

Short-term incentive plan

PTO 25 days

Sick leave

Company holidays

Wellness programs

Job summary

Preferred Mutual Insurance Company is seeking a Data & Statistical Reporting Analyst to collect, analyze, and interpret data across multiple sources and regulatory reports. You will identify trends, ensure data quality, and support cross-functional teams in a dynamic, Agile environment.

The role requires SQL proficiency, strong Excel skills, and deep knowledge of Property & Casualty insurance data. Join a collaborative team focused on accurate reporting and data-driven decision making.

Qualifications

• Bachelor’s degree in computer science, information technology or related field (or equivalent combination of education and experience).
• 3+ years of experience in project management, data analysis, or related field.
• Insurance industry experience required.
• Proficiency in SQL for database querying.
• Knowledge of Microsoft Excel (pivot tables, VLOOKUP).
• Strong understanding of Property & Casualty insurance coverage types and policy structures.

Responsibilities

• Manage preparation, reconciliation, and submission of statistical data files to external bureaus and regulators (e.g., ISO, AAIS, CAR).
• Prepare submission of regulatory data calls.
• Monitor bureau rejections and coordinate corrective actions with internal stakeholders.
• Support special projects related to data quality, compliance, and system upgrades.
• Support or perform testing of system changes or migrations that affect reporting/data (including UAT, validation of data flows).
• Stay current on regulatory reporting developments and help ensure organizational compliance.
• Collect, clean, and analyze structured and unstructured data from multiple data sources to support operations and initiatives.
• Create and maintain source-to-target mapping documents between data warehouse layers, feeds, reports and source systems.
• Create, run and modify SQL queries to analyze data in tables, loads, cubes, reports and feeds.
• Collaborate with Developers, Testers, EPMO and Stakeholders to document and deliver data requirements.
• Write data-level business requirements including complex calculations.
• Create and maintain data dictionaries.

Skills

SQL

Data analysis

Agile

Excel

Communication

Problem solving

Education

Bachelor's degree in CS/IT or related field

Tools

Azure DevOps

Jira

Job description

Preferred Mutual Insurance Company is seeking a Data & Statistical Reporting Analyst to collect, analyze, and interpret data across multiple sources and regulatory reports. You will identify trends, ensure data quality, and support cross-functional teams in a dynamic, Agile environment.

The role requires SQL proficiency, strong Excel skills, and deep knowledge of Property & Casualty insurance data. Join a collaborative team focused on accurate reporting and data-driven decision making.