Insurance Examination Data Specialist

State of Ohio; Columbus (OH); On-site; USD 39,000 - 56,000; Full time

Job summary

The State of Ohio is seeking an Insurance Examination Data Specialist within the Ohio Department of Insurance to analyze preliminary market conduct data and support examinations of insurers authorized in Ohio. You will design data requests, test data for credibility, and collaborate with insurers and MIS teams.

Travel within and outside Ohio is required. Strong data analysis, regulatory knowledge, and experience with Excel, Access, and ACL are essential for success in this role.

Qualifications

• Completion of undergraduate core program in computer science, insurance, accounting, business economics, statistics/mathematics or liberal arts.
• 4 yrs. exp. (i.e., regulatory or industry) in insurance information management systems, internal or external auditing, claims analysis, or underwriting that includes 24 mos. exp. in computer applications.
• Satisfactory completion of 3 insurance and/or insurance designation courses; must provide own transportation.

Responsibilities

• Systematically analyzes preliminary market conduct review and examination plans and prepares data parameters to enable Insurance Compliance Examiners to test for violations.
• Resolves complex data transfer problems and works with insurance company personnel to obtain accurate data for examinations.
• Designs complex data requests, submits them to company officers, and tests data for credibility to support examiner review.
• Responds to inquiries regarding data requirements; designs tests for examiners to assess practices using PC applications.
• Acts as liaison with MIS officers to resolve data issues identified during examinations.
• Develops and coordinates market analysis projects to identify industry trends and potential issues.
• Analyzes product submissions to determine possible non-compliance with laws and regulations.
• Uploads data into division databases; designs databases for analysis and prepares reports.
• Drafts data call notices and coordinates submissions; serves as division contact for inquiries.
• Liaises with NAIC and other entities to exchange regulatory information; retrieves and transmits data.
• Performs PR duties and travels within and outside Ohio.

Skills

Insurance

Education

Undergraduate degree

Tools

Excel

Access

ACL

Job description

All job postings will expire at 11:59 PM Eastern Time on the application deadline.

Organization: Insurance

Work Location:

50 West Town Street, Suite 300
Columbus, Ohio, 43215
United States

Compensation: 34.53

Schedule: Permanent - Full Time

Work Hours: Monday - Friday 8am - 5 pm

Classified Indicator: Classified

Union: OCSEA

Primary Job Skill: Insurance

About Us:

The Ohio Department of Insurance (ODI) was established in 1872 as an agency charged with overseeing insurance regulations, enforcing statutes mandating consumer protections, educating consumers, and fostering the stability of insurance markets in Ohio.

Today, the mission of the Ohio Department of Insurance is to provide consumer protection through education and fair but vigilant regulation while promoting a stable and competitive environment for insurers.

Please visit our website Department of Insurance and also find us on LinkedIn.

The Market Conduct Division monitors and examines insurance companies to confirm they are complying with the laws of the State of Ohio. Most regulatory reviews are initiated based on alleged patterns or practices reported to the division.

If this sounds interesting to you, continue reading below to learn more about the opportunity with our Department!

The Insurance Examination Data Specialist is responsible for analyzing preliminary market conduct review and examination data prior to market conduct reviews and examinations of insurance companies authorized to conduct business in Ohio.

Responsibilities:

1. Systematically analyzes preliminary market conduct review and examination plans and prepares data parameters to enable Insurance Compliance Examiners to efficiently and effectively test for violations of insurance laws.
2. Resolves complex data transfer problems and works directly with insurance company personnel to obtain accurate and complete computer data and documentation necessary for compliance examinations.
3. Designs complex computer data requests, submits them to insurance company management information officers, and tests resulting data for credibility to support examiner review and analysis.
4. Responds to all insurance company inquiries regarding the Market Conduct Division’s data requirements; designs specific tests for examiners to assess insurance company business practices using personal computer applications.
5. Serves as examination team computer analyst and acts as liaison with insurance company management information systems officers to resolve data issues identified during in‑house or on‑site examinations.
6. Develops and coordinates market analysis projects to identify industry trends, emerging issues, and potential compliance problems using various data sources, market surveillance reviews, and industry survey data calls.
7. Analyzes a full range of complex insurance company product submissions, including underwriting rules, statistical information, and claims procedures, to determine possible non‑compliance with state and federal laws and regulations.
8. Uploads insurance company claim and underwriting data into division databases; designs and programs divisional databases for data analysis and prepares reports for review by division management.
9. Drafts data call notices to insurance company senior management, coordinates submission requests, and serves as division point‑of‑contact for complex technical inquiries from insurance company programmers regarding data requirements.
10. Serves as divisional liaison with the Department of Insurance, NAIC, other state insurance departments, and insurance companies through electronic media to exchange regulatory information; retrieves and transmits data using NAIC systems.
11. Performs public relations duties, attends meetings, testifies at administrative hearings as needed, and performs other duties as assigned. Travel within and outside Ohio is required.

Why Work for the State of Ohio:

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full‑time and part‑time employees*. For a list of all the State of Ohio Benefits, visit our Total Rewards website! Our benefits package includes:

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems (such as OPERS, STRS, SERS, and HPRS) & Optional Deferred Compensation (Ohio Deferred Compensation)

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications:

Completion of undergraduate core program in computer science, insurance, accounting, business economics, statistics/mathematics or liberal arts 4 yrs. exp. (i.e., regulatory or industry) in insurance information management systems, internal or external auditing, claims analysis, or underwriting that includes 24 mos. exp. in computer applications (e.g., Excel, Access, ACL) satisfactory completion of 3 insurance &/or insurance designation courses must provide own transportation.

-Or 2 yrs. exp. as Insurance Compliance Examiner 3, 67213 2 yrs exp. in computer applications (e.g., Excel, Access, ACL).

-Or equivalent of minimum class qualifications for employment noted above.

Job Skills: Insurance

ADA Statement:

Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.

Drug‑Free Workplace:

The State of Ohio is a drug‑free workplace which prohibits the use of marijuana (recreational marijuana/non‑medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug‑Free Workplace Policy (HR‑39), and as outlined in the posting.