Location: St. Paul, Minnesota
Duration: June 2025 – Present
About the Metropolitan Council
The Met Council is a non-elected government agency that provides long-term planning and services for the 7-county Twin Cities Metro Area. The Met Council employs over 4,000 individuals in 5 divisions, the largest of which is Metro Transit. Metro Transit is the primary public transportation provider for the Twin Cities Metro Area with a network of buses, light rail and commuter trains. In 2024, Metro Transit provided more than 47 million rides across the Twin Cities region! I interned with the Sustainability team. The sustainability team works across the entire Council to conduct climate action planning and implementation, emissions tracking and reporting, natural systems management, environmental justice work, energy utilities management, energy efficiency work, and much more.
My role
At Metro Transit, I work with the Sustainability team, focusing on Greenhouse Gas data analytics.
My major projects
GHG Calculations + Tracking:
As the highest emitting state agency in Minnesota, Metro Transit must calculate and report its emissions annually.
The previous method for reporting involved a time-intensive, out-of-date manual-entry spreadsheet that was riddled with errors.
By teaching myself new software, I created an automated reporting system that streamlines accurate annual GHG reporting! This system automatically pulls data from our utility software server to provide annual emissions reports.
Facilities Energy Targets Dashboard: I created an interactive dashboard displaying energy use by facility. This tool will help the Sustainability team discover trends in each facility and create nuanced targets to lower energy use.
Achievements
Took initiative to successfully propose projects.
Independently learned new software (PowerBI, EnergyCAP, B3) and coding languages (DAX, M).
Complex data querying, wrangling, analysis, visualization, and communication.
