Statistical Reporting Analyst (Remote)

California FAIR Plan Association; Oregon; Hybrid; USD 70,000 - 110,000; Full time

Job summary

California FAIR Plan Association seeks a Statistical Reporting Analyst to develop and maintain reporting for internal and external data requests. You will interpret regulatory requirements, coordinate with bureaus, and ensure timely, accurate data delivery.

The role requires experience with policy and claims data, SQL, Excel/Access, and ArcGIS for credit verification. Strong communication and project participation are essential to success.

Qualifications

• Bachelor's degree in Data or Business Analytics, Mathematics, or equivalent.
• 3 to 5 years of relevant work experience.
• Understanding of property and casualty insurance data is desirable.
• Strong Excel/Access and SQL scripting capabilities.
• Excellent written and verbal communication skills.

Responsibilities

• Develop, produce, maintain, and enhance reporting for external and internal data requests.
• Ensure compliance with requirements and deadlines; interpret and communicate results to regulatory entities.
• Extract and report information on policy, claims, commissions, and unclaimed property data.
• Develop detailed reporting requirements for insurance bureaus and other entities.
• Analyze data, processes, and systems to assure data integrity, quality, and regulatory reporting compliance.
• Suggest process improvements, quality controls, and best reporting practices.
• Assist with member company participation verification using ArcGIS.
• Support testing and post-production monitoring; participate in data reporting projects.
• Identify opportunities for data and reporting initiatives aligned with corporate goals.

Skills

Data analysis

SQL scripting

Communication skills

Time management

Education

Bachelor's degree in Data or Business Analytics, Mathematics, or equivalent

Tools

Microsoft Excel

Microsoft Access

SQL

ArcGIS

Job description

POSITION SUMMARY

The Statistical Reporting Analyst is responsible for development, production, maintenance, and enhancement of reporting for external and internal data requests. They will assure compliance with requirements and deadlines, interpret, and communicate the results of reported data with various regulatory entities, bureaus, and other stakeholders.

PRINCIPAL DUTIES & RESPONSIBILITIES

• Responsible for extracting and reporting on information related to statistical data, including policy and claims data, commissions data (for 1099 reporting), and unclaimed property data.
• Develop and maintain detailed requirements (including instructions, process flows, data reports, and data sources) for reporting to various insurance bureaus, insurance department, and other entities.
• Responds to correspondence from regulatory entities, bureaus, and internal stakeholders in a timely and professional manner.
• Communicate with internal departments regarding data concerns or issues.
• Analyze data, processes, workflows, documentation, and systems development to provide assurance of data integrity, quality, efficiency, and regulatory and statistical reporting compliance.
• Recommend process and efficiency improvements, quality control measures, and reporting best practices.
• Research, interpret, and apply industry requirements and acquire necessary clarifications; develop, document, maintain, and implement business and technical requirements.
• Research, formulate, and communicate moderate to complex data and regulatory reporting solutions.
• Assist with member company participation process, including verification of credits submitted by utilizing mapping software (ArcGIS).
• Assist in business testing and post-production monitoring around reporting.
• Participate in projects which impact data reporting.
• Identify opportunities and recommend data and reporting initiatives that support corporate strategic plans, goals, and objectives.
• Assist with defining reporting requirements for policy, billing and claims system.
• Serve as potential backup for other areas as needed.
• Perform additional duties and/or special projects as required.

EDUCATION AND EXPERIENCE

• Bachelor's degree in Data or Business Analytics, Mathematics, or equivalent.
• 3 to 5 years of relevant work experience.
• Principles of property and casualty insurance products and prior analytical work experience in that setting highly desirable.
• Ability to understand data information systems and the relationship to business data, including the flow of policy coverage and claims data from the point of entry through all applicable computer systems.
• Intermediate to advanced Microsoft Excel and Access skills.
• Ability to create, modify, and run SQL scripts required.
• Ability to efficiently manage time, organize work with minimal supervision, and meet timelines.
• Excellent attention to detail, oral and written communication skills.