Provide analytical support to the Quantitative Analytics function within Claims by developing, maintaining, and updating quantitative models, tools, and reports related to claims activity.
This role focuses on lower-complexity modeling, preparatory analysis, and data organization, working under the direction of the Quantitative Analytics Manager and in partnership with Claims and Actuarial teams.
Develop and update quantitative models in Microsoft Excel to support claims analysis, projections, and scenario evaluation.
Perform lower-complexity modeling and assist with preparatory work for more complex analyses under the guidance of the Quantitative Analytics Manager.
Support reserve-related analyses in coordination with Actuarial and Claims teams.
Assist in building and maintaining settlement trackers, allocation calculators, and reporting tools.
Ensure tools are structured to be scalable and efficient as data volume increases.
Support preparation of recurring reports related to claim payments, reserving activity, and remaining limits.
Convert externally provided data into standardized internal formats.
Assist with system enhancements, data imports/exports, and maintenance of analytical tools in Excel or Access.
Requirements
2-3 years of experience required
Proven ability to work under guidance and supervision to create various formulas/macros in Excel, assessing large data sets, and forecasting futures based on trends.
Four-year degree required: Mathematics, statistics, or actuarial science degrees preferred.
You must be legally authorized to work in the U.S. without requiring immigration sponsorship now or in the future. This includes holders of H-1B, H4, L-1, L-2, TN, OPT, CPT, and other nonimmigrant visas.