IT Portfolio Data Visualization

Work Schedule and Flexibilities: Flexible, Hybrid or remote work (based in Washington, DC office if in-person is required) Project Description: The Mission Systems Directorate (MSD) in the Office of the Chief Information Officer (OCIO) is developing multiple sources of system inventory and resource data, including spreadsheets and internal applications. This project will consolidate, clean, and standardize these datasets and translate them into a user-friendly visualization tool (e.g., Power BI dashboard) to support leadership decision-making. The student will: Transform existing system inventory data into a structured, usable dataset Develop an interactive dashboard highlighting system ownership, technology stacks, lifecycle status, contract support, and resource gaps Produce a short insights summary identifying trends, risks, and opportunities Document the dataset and dashboard to support sustainability and future updates This project provides a clearly defined, time-bound opportunity aligned with IT portfolio management and modernization priorities and will result in tangible deliverables usable by leadership.