Just a quick update on this one.
I have now tested building the data set using Custom SQL, which includes the joins, so there is only one data source and the UTC conversion works fine. This is my current work around.
Regardless, I would still be able to use the Quicksight functionality in its current form.
Could the behaviour above be considered a bug?