Aggarwala was tapped by New York City Mayor Michael Bloomberg to create the Office of Long-Term Planning and Sustainability and served as director of the office from 2006 to 2010.[6] He also helped author the PlaNYC blueprint, a sustainability plan for the city.[7][8]
From 2010 to 2015, he worked at Bloomberg Philanthropies, heading its sustainability practice division. He served as Chair, Committee on the Fourth Regional Plan, for the Regional Plan Association from the inception of the process in 2014 until the publication of the Fourth Plan in 2017.[9] He was president of the board of directors of the C40 Cities Climate Leadership Group and was a member of the founding team of Sidewalk Labs, where he served as chief policy officer,[10][11] head of urban systems, and remained a senior advisor.[12][13] For his role at Sidewalk Labs, he was named one of the "Politico 50" by the eponymous magazine in 2018.[14] He led a high-profile smart city-building project in Waterfront Toronto before it was cancelled in May 2020 due to stakeholders' disagreements, privacy concerns, and the COVID-19 pandemic, which also led to his exit from the company.[15][16][17]
In 2020, he was named Senior Urban Tech Fellow at Cornell Tech.[18] He is the lead author of the Rebooting NYC report, published by Cornell Tech in 2022, which proposes urban tech solutions to New York City's biggest challenges.[19][20][21] He is also an adjunct associate professor at the School of International and Public Affairs, Columbia University, where he teaches urban policy.[1]