No, you can accomplish this within the same profile. Just create a different target and when you perform any dbt build or dbt run, just append --target to specify the different environments you want to run into. You can use this to specify a test and production environment all within one profile.