Insurance Examination Data Specialist

State of Ohio • Columbus, OH

3d • Onsite

About The Position

The Insurance Examination Data Specialist analyzes preliminary market conduct review and examination data for insurance companies authorized to do business in Ohio. The specialist prepares data parameters to help Insurance Compliance Examiners efficiently test for violations of insurance laws, resolves complex data-transfer issues, and works with insurance company personnel to obtain accurate computer data and documentation.

The role designs complex data requests and examiner tests, evaluates submitted data for credibility, and responds to insurance companies’ questions about Market Conduct Division data requirements. It also serves as the examination team’s computer analyst and liaison with insurance company information-systems personnel during in-house and on-site examinations.

The specialist develops market analysis projects to identify industry trends and potential compliance problems; analyzes insurance product submissions, including underwriting rules, statistical information, and claims procedures; and uploads claim and underwriting data into divisional databases. The position designs databases, prepares reports for division management, coordinates data calls, and serves as a contact for technical inquiries. It also exchanges regulatory information with the Department of Insurance, NAIC, other state insurance departments, and insurance companies using electronic media and NAIC systems. Public relations duties, meetings, testimony at administrative hearings as needed, other assigned duties, and travel within and outside Ohio are included.

Requirements

• Completion of an undergraduate core program in computer science, insurance, accounting, business economics, statistics/mathematics, or liberal arts, plus four years of experience (for example, regulatory or industry) in insurance information management systems, internal or external auditing, claims analysis, or underwriting; the experience must include 24 months in computer applications such as Excel, Access, or ACL.
• Satisfactory completion of three insurance and/or insurance designation courses.
• Must provide own transportation.
• Alternative qualification: two years of experience as Insurance Compliance Examiner 3, classification 67213, and two years of experience in computer applications such as Excel, Access, or ACL.
• Equivalent of the stated minimum class qualifications for employment.

Responsibilities

• Analyze preliminary market conduct review and examination data and plans.
• Prepare data parameters that enable Insurance Compliance Examiners to test for violations of insurance laws.
• Resolve complex data-transfer problems and work with insurance company personnel to obtain accurate and complete computer data and documentation.
• Design complex computer data requests, submit them to insurance company management information officers, and test submitted data for credibility.
• Respond to insurance company inquiries about Market Conduct Division data requirements.
• Design tests for examiners to assess insurance company business practices using personal computer applications.
• Serve as examination team computer analyst and liaison with insurance company management information systems officers during in-house and on-site examinations.
• Develop and coordinate market analysis projects to identify industry trends, emerging issues, and potential compliance problems.
• Analyze insurance company product submissions, including underwriting rules, statistical information, and claims procedures, for possible non-compliance with state and federal laws and regulations.
• Upload insurance company claim and underwriting data into division databases; design and program databases for analysis and prepare reports for division management.
• Draft data call notices, coordinate submission requests, and serve as the division point of contact for technical inquiries from insurance company programmers.
• Exchange regulatory information with the Department of Insurance, NAIC, other state insurance departments, and insurance companies through electronic media; retrieve and transmit data using NAIC systems.
• Perform public relations duties, attend meetings, testify at administrative hearings as needed, and perform other duties as assigned.
• Travel within and outside Ohio.

Benefits

• Medical coverage.
• Free dental, vision, and basic life insurance premiums after completion of the eligibility period.
• Paid vacation, personal and sick leave, and 11 paid holidays per year.
• Childbirth, adoption, and foster care leave.
• Education and development opportunities, including employee development funds and Public Service Loan Forgiveness.
• Public retirement systems, including OPERS, STRS, SERS, and HPRS, and optional Ohio Deferred Compensation.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level