It is my understanding that if we have a simple linear system such as
$$Ax = y$$
The condition number of $A$ provides an indication of how sensitive the solution $x$ will be in relation to changes in $y$. However, if I was to solve this linear system via SVD
$$x = V \Sigma^{-1}U^{T}y$$
Then there is no condition number as x is not been multiplied by anything?
I don't understand why that is the case, because if $y$ had an error then that would change the solution to $x$? Could someone please explain further? Many thanks.
Your line of reasoning amounts to saying "because $x = A^{-1}y$, there is no condition number" to the system of equations. That's false.
You can write the system in two ways. Either as $Ax = y$, or (if you want to use SVD) $(U\Sigma V^T) x = y$. In the case that $A$ is invertible, we may solve this system as $$ x = A^{-1}y = V\Sigma^{-1}U^Ty $$ Whichever way you write these equivalent equations, we can see that changing the value of $y$ affects the value of $x$. The extent of this effect is captured by the condition number.
As it turns out, the condition number of $A$ is the same as the condition number of $\Sigma$.