Statistical Reporting Analyst (Remote)

California FAIR Plan Association; Los Angeles (CA); Remote; USD 70,000 - 90,000; Full time

Job summary

A leading company in the insurance sector is seeking a Statistical Reporting Analyst to manage and enhance reporting processes for data requests and regulatory compliance. The ideal candidate will possess a background in data analytics, technical skills in Excel and SQL, and a strong attention to detail.

Qualifications

• 3 to 5 years of relevant work experience in data analysis.
• Understanding of property and casualty insurance principles.
• Ability to create and run SQL scripts.

Responsibilities

• Extracting and reporting information on statistical data including policy and claims data.
• Develop and maintain reporting requirements for insurance bureaus.
• Analyze data integrity and ensure compliance with regulations.

Skills

Data Analysis

SQL

Microsoft Excel

Microsoft Access

Attention to Detail

Communication

Education

Bachelor’s degree in Data or Business Analytics

Mathematics or equivalent

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 & EXPERIENCE

The individual in this position must meet the following general requirements:

• 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.
• Excellent oral and written communication skills.