The role involves collecting claim data from various sources to analyze trends and generate situational forecasts. The analyst monitors the status of aging claims and provides notifications for those exceeding specific timeframes. Responsibilities include organizing data for regular progress reports and executing ad hoc reporting or special projects. The position requires designing, implementing, and maintaining large-scale enterprise data ETL processes. The analyst must consistently meet strict management deadlines while ensuring data accuracy.

Candidates must hold a bachelor's degree in Statistics, Accounting, Business, Analytics, or possess equivalent experience. A minimum of two to three years of data analytics experience is required for the role. Proficiency in Microsoft Excel, including advanced functions such as PIVOT and VLOOKUP, is necessary. Additionally, the role requires strong communication, interpersonal, and critical thinking skills to interpret and simplify complex information.