Performance Issues

There are some things here that I'm not sure you can make better – parsing JSON, for example, there is no magic in SQL Server 2014. I would start by getting rid of the table variables. For better input, please generate an actual plan from within Plan Explorer – this will add runtime metrics and other data you don't get when you open a plan generated in Management Studio (especially an estimated plan).