The Design Team at Aero Automatic Sprinkler Company is responsible for creating detailed plans and specifications for fire protection systems, including fire sprinklers and alarms. They ensure that designs meet safety standards and regulatory codes while collaborating with other departments to integrate these systems into construction projects efficiently.