Statistics & Data Analyst (Workers' Compensation Underwriter) – Actuarial

This position shall be filled in accordance with the provisions of the OCSEA Collective Bargaining Agreement. BWC bargaining unit members have selection rights before non-bargaining unit members. All other applications will only be considered if an internal bargaining unit applicant is not selected for this position.
———————————————————————————————————

Under general supervision, sets employer premium rates, reserves & assessments based on employer loss statistics (e.g. reserves, indemnity & medical paid), payroll & premiums: calculates, maintains employer premium base rates & assessments for appropriate funds (e.g. Private Employer, Public Employer Taxing Districts, Public Employer State Agencies, Self-Insured & the Self-Insured Employers Guaranty Fund, Marine, Black Lung, Public Workers’ Relief); analyzes claim loss development, trends & legislative changes to modify reserve methodology; uses rate calculation formulas to calculate employer premium rates & assessments for funds (i.e. private employer, public employer taxing districts, public employer state agencies, self-insured & self-insured employers guaranty fund, marine fund, black lung fund, public workers’ relief fund). Supports actuarial reserve analysis & financial audit process; supports data collection for the actuarial reserve analysis; reviews & verifies the use of the data, the methodology & the calculations contained in the actuarial reserve analysis; compares actual payment results with expected payment results. Collects payment data & organizes into reports for analysis; maintains data, statistics & graphs on payment data using Microsoft Access, Microsoft Excel & other database & software programs/systems. Responds to risk management strategy issues for employer accounts: reviews risk management programs (e.g. DFSP, OCP) to determine their effectiveness; validates the appropriateness of the discounts given to employers based on risk management programs utilized; determines degree of improvement made due to loss control efforts & whether or not additional services may be needed; maintains, analyzes & evaluates the integrity of underlying factors supporting employer programs (e.g. retrospective rating tables,); interacts with BWC staff & the employer to address & resolve problems; assembles & analyzes work related accident data & payroll data for use in premium rates & assessment calculations & in designing, evaluating, pricing & implementing rating plans; gathers, organizes & analyzes BWC data on administrative payments, compensation losses paid & medical losses paid for reporting & for use in the actuarial reserve analysis using the data warehouse, payment reports & Microsoft Access & other database software programs. Performs other related duties as required: performs statistical data analysis utilizing data warehouse, SAS, & other IT systems to support agency initiatives (e.g. alternate rating plans, legislative changes, cost benefit analyses, group rating studies); Review & validate Actuarial rules prior to readings before Board of Directors. Provides support services for computer systems utilizing Actuarial data: develops, maintains & evaluates Rates & Payment rate calculation system design (e.g. NCCI updates); analyzes & validates modifications to BWC web & other IT computer systems; assists Employer Services in validation of employer systems due to changes in programs & discounts (e.g. stacked discounts, non-group discounts); validates the results of change controls to the Rates & Payments system (e.g. PA, PEC, Reports, Correspondence). Performs other related duties as required: performs statistical analysis utilizing data warehouse & other IT systems to support agency initiatives (e.g. alternate rating plans, legislative changes, cost benefit analyses, group rating studies); assists in special projects & participates in cross-functional BWC teams to provide actuarial data (e.g. analyses of self-insured bankruptcies, establishment of claim loss trends, analysis of liquidity of state insurance fund); provides information & support to employer services team members & participates in mentoring/training of other division employees (e.g. Workers’ Compensation University); calculates present values; maintains & updates annuity tables (e.g. present values & reserves, study to determine future reserves); performs data integrity prior to doing rates to identify errors & tries to rectify (e.g. claims charged without payroll); provides Data Warehouse information as requested to verify other systems & perform statistical analyses; consults with other BWC departments (e.g. Employer Services, IT, Senior management) on technical issues relating to pricing & rating plans; formulates guidelines for data analysis (e.g. creates project plans, completes analysis & writes reports, writes procedures for future & recurring studies & analysis); responds to inquiries from employers, legislators, trade associations, other state agencies or employer representatives regarding premium rates through written (email & letter) & telephonic correspondence.

Minimum Qualifications:

Unless required by legislation or union contract, starting salary will be set at the lowest rate of the salary range. In most cases successful employees will move up a step in the salary range within six months, with subsequent step increases occurring every year as supported by successful performance evaluation results.
———————————————————————————————————

Completion of undergraduate core coursework in business, insurance & risk management, accounting, mathematical sciences or related field of study.

-Or-

2 yrs. trg. or 2 yrs. exp. as underwriter for insurance organization or for agency comparable to Ohio Bureau of Workers’ Compensation.

Or equivalent of Minimum Class Qualifications for Employment noted above.

POSITION-SPECIFIC MINIMUM QUALIFICATIONS

(i.e. in addition to meeting the above, applicants must also meet the following):

9 mos. exp or 9 mos. training in insurance principles & various types of insurance coverage, loss exposures, premium calculations & distributions;

AND 6 mos. exp or 6 mos. training in statistical analysis (e.g., statistics in analyzing data);

AND 6 mos. exp or 6 mos. training in use of Microsoft Excel.

Major Worker Characteristics:

Knowledge of: (1)workers’ compensation laws (e.g., Ohio Revised Code), policies & procedures regarding risk & claims administration*, (2)insurance concepts including types of insurance coverage, loss exposures, premium calculations & collections , (3)distribution & classification of risk, (4)risk management concepts (e.g., identifying & analyzing loss exposures) & risk management techniques, (5)NCCI manual classifications*, (6)loss control methods (e.g., PDP+, DFWP, Group Rating, Retrospective Rating)*, (7)economic environment (e.g., inflation & bond discount rates) & impact on pricing of workers’ compensation premiums*, (9)accounting or business administration, (10)reserve methodology & it’s use as a claims management tool (e.g. MIRA), (11)different types of compensation (indemnity) awarded in claims, (12)the State Insurance Fund & related funds, (13)Self Insured Assessments*, (14)Self Insured Mandatory, Rehabilitation & Handicap Funds*, (15)Self Insured Employer Guaranty Fund (SIEGF)*, (16)Self Insured Surety Bond Fund (SBF)*, (17)Self Insured Receipts & Expenditures Reports (e.g., Collections & Disbursements for Mandatory, Rehabilitation, SIEGF, SBF & Handicap Funds)*, (18)Self Insured Disallowed Claims Reimbursements*, (19)Self Insured Reported Compensation (used as basis for Self Insured Assessments)*, (20)Self Insured Security Reductions, Reverse Buyouts, & Bankruptcy Reserves*, (22)organizational audit techniques (i.e., workflow analysis, project planning concepts & accounting systems); Skill in: (1)use of personal computer & peripheral equipment (e.g., fax, scanner, printer), (3)use of Microsoft Excel , (4)use of Microsoft Access*, (5)use of BWC software (e.g., Rates & Payments, WCIS, V3)*, (6)use of statistical analysis (e.g., statistics to assist in analyzing data) , (7)use of project planning software*; Ability to: (1)define problems, collect data, establish facts & draw valid conclusions, (2)complete problem solving steps (i.e., identify the issue, create alternatives, analyze alternatives, select best alternative, implement, & modify as necessary), (3)review & interpret technical information (e.g. actuarial, statistical & insurance technical information), (6)gather, collate & classify information about data, people or things, (7)add, subtract, multiply and divide whole numbers, (8)organize statistics into meaningful form for analysis, (9)calculate fractions, decimals & percentages, (10)respond to sensitive inquiries from employers & the general public, (11)create formulas & queries using Microsoft Excel & Access, (12)use proper research methods to gather data, (14)work well with other departments, (15)graph information, (16)track projects, (17)manage time.

(*) Developed after employment.

Supplemental Information:

Prior to an offer of employment, the final applicant will be required to sign a background check authorization form and undergo a criminal background check. Criminal convictions do not necessarily preclude an applicant from consideration for a position.
———————————————————————————————————

This position may require travel; therefore, the incumbent must be able to provide own transportation &/or legally operate a state-owned vehicle.

EDUCATIONAL TRANSCRIPT REQUIREMENT:

BWC requires an official transcript for any applicant claiming to meet the minimum qualifications based on educational achievement. A transcript is only considered “official” if it is verifiable through the educational institution that awarded it (e.g., contains institution watermark, ink stamp, embossed stamp, registrar contact information). If provided from an on-line transcript clearinghouse the transcript must contain clearinghouse contact information so that it can be verified. Printouts of course information available to the student through the institution’s website are NOT considered an official transcript. In order for education to be taken into consideration during the application screening process, BWC employees must have an official transcript on file with the Personnel & Benefits department by the deadline date on the job posting. Applicants not currently employed by BWC must attach a copy of the transcript(s) to their application, however, an official transcript will be required if invited to interview for the job opening.

———————————————————————————————————

You can check the status of your application online by signing in to your profile. Jobs you applied for will be listed. The application status is shown to the right of the position title and application submission details. Questions not pertaining to your application status can be directed to: a77509@bwc.state.oh.us.

———————————————————————————————————