IT Modernization Specialist

Project Overview: The student Intern- IT Modernization Specialist will support an IT modernization project focused on transforming a legacy Excel-based program used for annuity calculations under the Railroad Retirement Act. The project aims to improve efficiency, capability, and long-term sustainability of mission-critical calculation tools. As a IT Modernization Specialist, you will: Analyze an existing Excel-based calculation model, including formulas, logic, and data flow. Collaborate with agency subject matter experts to document business requirements. Evaluate potential modernization platforms (e.g. web-based applications, database solutions, or other programming environments). Assists in designing and developing an updated solution to replace existing excel-based calculation model.