Update dbt example to use latest best practices

[slopp]

• [x] Remove dbt2
• [ ] Remove DBT_PROFILES_DIR. Just place the profiles.yml in the root dbt project directory
• [ ] Link resources to creating the manifest at build time; Add comment to Makefile and Github action file & Add comment to dbt reference
• [x] Remove https://github.com/dagster-io/hooli-data-eng-pipelines/blob/master/hooli_data_eng/assets/dbt_assets.py#L104-L108. This is already added as part of the integration.
• [x] Remove https://github.com/dagster-io/hooli-data-eng-pipelines/blob/master/hooli_data_eng/assets/dbt_assets.py#L119-L120. This is not necessary since an Exception is already raised by default.
• [ ] Make node_path.split agnostic to the OS: https://dagster.slack.com/archives/C02LJ7G0LAZ/p1698162597348859