IT and Financial products Intern at Illinois Treasurer's Office

Session Number

Biz INTRN 05

Advisor(s)

Alexandra Lara, Joseph Daniels

Discipline

Business

Start Date

17-4-2025 2:45 PM

End Date

17-4-2025 3:00 PM

Abstract

The Illinois State Treasurer's Office (STO) manages the stateS portfolio and runs several financial programs for the benefit of Illinois families, such as the Secure Choice retirement savings program and the Bright Start and First Steps college savings programs. The STO is building a new Data Team to support the Office's existing programs and divisions. This team is the first of its kind in any Illinois State govemment agency and works closely with the STO's IT division to build solutions to meet the needs of the various teams at the STO This work includes building a new database, creating automated ingestions pipelines for various data pieces, generating Visualizations and reports, automating manual processes, and running ad-hoc analyses on on as-needed basis. Over the past few months. I've supported this team on a variety of tasks, including analyzing Illinois Secure Choice program data to identify enforcement opportunities, and reviewing/analyzinq Illinois College Savings data to ensure the accuracy of First Steps claims ' eligibility determination. I have worked collaboratively with the STO's internal teams to determine each team 's individual needs, and build the necessary infrastructure and processes to generate the required deliverables.

Share

COinS
 
Apr 17th, 2:45 PM Apr 17th, 3:00 PM

IT and Financial products Intern at Illinois Treasurer's Office

The Illinois State Treasurer's Office (STO) manages the stateS portfolio and runs several financial programs for the benefit of Illinois families, such as the Secure Choice retirement savings program and the Bright Start and First Steps college savings programs. The STO is building a new Data Team to support the Office's existing programs and divisions. This team is the first of its kind in any Illinois State govemment agency and works closely with the STO's IT division to build solutions to meet the needs of the various teams at the STO This work includes building a new database, creating automated ingestions pipelines for various data pieces, generating Visualizations and reports, automating manual processes, and running ad-hoc analyses on on as-needed basis. Over the past few months. I've supported this team on a variety of tasks, including analyzing Illinois Secure Choice program data to identify enforcement opportunities, and reviewing/analyzinq Illinois College Savings data to ensure the accuracy of First Steps claims ' eligibility determination. I have worked collaboratively with the STO's internal teams to determine each team 's individual needs, and build the necessary infrastructure and processes to generate the required deliverables.