Assign `LOGGER` role to `TRANSFORMER` role

[ian-r-rose]

In order to access cost information as part of our normal data pipelines (cf. #427), the TRANSFORMER role probably needs access to the LOGGER role.

I'm a little agnostic as to whether this is useful to do in terraform. If it is, it could probably be at the top-level, rather than in the "elt" module.

[ram-kishore-odi]

I would also like to think a little more about this and come back with additional feedback.

[ian-r-rose]

Yeah, it may also be that a different permission structure is helpful here