Data Quality Analyst - Financial Data Reporting

The Data Quality Analyst reports to the Supervisor, Financial Data Reporting. In this role, they will analyze and edit Annual Financial Data Calls for Experience reported by carriers who write workers’ compensation insurance in Pennsylvania and Delaware. The financial data calls include historical reporting of various levels of premium, loss information and expense reporting by policy and calendar year for individual insurance carriers. The Data Quality Analyst will be responsible for identifying data outliers and anomalies and contacting carriers both orally and in writing regarding data submissions. They must have the ability to communicate data reporting issues and make sound decisions regarding their explanations. Duties of the role include; implementing the Financial Data Incentive Program; recommending, implementing, and testing modifications to the Financial Data Reporting Application and producing reports to assist in data verification. The Data Quality Analyst should possess strong problem solving, communication and organizational skills.

Essential Responsibilities:

• Edit all carrier FDM submissions. Analyze and evaluate premium, loss and expense reporting patterns and critically review carrier data submissions and comments for reasonability and accuracy. Make recommendations regarding the acceptance, use and/or modification of carrier data within summary reports.
• Identify data outliers and anomalies thru FDM edits and data comparisons to prior submissions and in relation to statewide data
• Make recommendations regarding the acceptance, use and/or modification of carrier data within summary reports
• Contact carriers for data, corrections and/or clarification, diary follow-up contacts regarding data submission, produce status reports of carrier submissions
• Identify, analyze and interpret trends or patterns in various data sets such as Financial data, Unit Statistical data, Medical data and Indemnity data
• Participate in FDM user acceptance testing
• Timely and consistent attendance

Non - Essential Responsibilities:

• Perform other miscellaneous duties as requested.

Requirements:

Education: Bachelor’s Degree – B.A. / B.S. Mathematics or Sciences strongly preferred.
Experience: None required. Successful completion of one actuarial exam or other insurance industry certification preferred.
Skills Required: Strong organizational, communication, written and analytical skills with the ability to work independently and adapt to various situations. Employee must possess the ability to manage multiple assignments and prioritize tasks accordingly. PC proficient in Microsoft Office Suite; advanced knowledge of Excel is required (use of pivot tables, v-lookups, macros, create tables, formulas, charts, and graphs) and experience in Microsoft Word. Communicate effectively with all levels of personnel and outside contacts.

Work Hours:

Normal PCRB hybrid Flex time is available. Employee must be flexible when needed as projects or deadlines may sometimes necessitate extended hours.