I have same sentiments as Jack. SQL Agent jobs is not designed for your 1-min response time.

If you have any future plans for scaling, this solution won't last you long.

Does the RAW table also need to be updated as well, during each transaction?

If it's purely read-only, while you process the new data into another table, that would allow different strategies.